PREVIEW / etf_1hour / 2022-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-27.parquet
  size:    458 KB
  rows:    16,930

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2022-10-27 04:00:00	SPY	ETF	382.8	383.76	382.55	383.2	67932.0
2022-10-27 05:00:00	SPY	ETF	383.01	383.09	382.11	382.13	100853.0
2022-10-27 06:00:00	SPY	ETF	382.11	382.48	381.7	381.73	79641.0
2022-10-27 07:00:00	SPY	ETF	381.83	382.58	381.43	381.66	195920.0
2022-10-27 08:00:00	SPY	ETF	381.83	384.21	381.34	383.5	1389733.0
2022-10-27 09:00:00	SPY	ETF	383.54	384.5	380.52	381.2	7006335.0
2022-10-27 10:00:00	SPY	ETF	381.195	385.0	380.83	382.19	10201380.0
2022-10-27 11:00:00	SPY	ETF	382.18	383.46	380.89	381.35	6943428.0
2022-10-27 12:00:00	SPY	ETF	381.39	382.415	380.13	381.54	6409704.0
2022-10-27 13:00:00	SPY	ETF	381.56	382.77	380.7323	380.7801	6410336.0
2022-10-27 14:00:00	SPY	ETF	380.78	381.06	379.81	380.13	6061009.0
2022-10-27 15:00:00	SPY	ETF	380.13	381.33	379.33	379.96	11783232.0
2022-10-27 16:00:00	SPY	ETF	379.96	380.32	373.8	377.13	5366078.0
2022-10-27 17:00:00	SPY	ETF	377.25	379.98	376.0	377.8	606397.0
2022-10-27 18:00:00	SPY	ETF	377.8	378.63	377.5	377.85	172553.0
2022-10-27 19:00:00	SPY	ETF	377.9	378.21	377.39	377.5	148549.0
2022-10-27 04:00:00	QQQ	ETF	277.77	278.3	277.33	277.78	106725.0
2022-10-27 05:00:00	QQQ	ETF	277.72	277.72	276.5	276.5	98531.0
2022-10-27 06:00:00	QQQ	ETF	276.57	276.92	275.92	276.07	202519.0
2022-10-27 07:00:00	QQQ	ETF	276.07	276.9	275.96	276.14	386939.0
2022-10-27 08:00:00	QQQ	ETF	276.01	279.2	275.65	277.66	1514976.0
2022-10-27 09:00:00	QQQ	ETF	277.75	278.2795	273.395	274.1	6551834.0
2022-10-27 10:00:00	QQQ	ETF	274.08	277.99	273.7	274.79	7555044.0
2022-10-27 11:00:00	QQQ	ETF	274.785	276.23	273.91	274.06	4513306.0
2022-10-27 12:00:00	QQQ	ETF	274.0399	274.99	273.01	274.0	4317006.0
2022-10-27 13:00:00	QQQ	ETF	274.02	275.17	273.35	273.3997	3523722.0
2022-10-27 14:00:00	QQQ	ETF	273.39	273.63	272.58	272.89	3653419.0
2022-10-27 15:00:00	QQQ	ETF	272.89	273.88	272.34	272.83	6504050.0
2022-10-27 16:00:00	QQQ	ETF	272.83	273.05	265.1	269.35	5437035.0
2022-10-27 17:00:00	QQQ	ETF	269.32	272.21	268.7	270.51	907065.0
2022-10-27 18:00:00	QQQ	ETF	270.46	272.87	270.11	270.73	506550.0
2022-10-27 19:00:00	QQQ	ETF	270.7	270.95	270.14	270.26	118880.0
2022-10-27 04:00:00	IWM	ETF	179.67	180.31	179.64	180.06	37567.0
2022-10-27 05:00:00	IWM	ETF	180.05	180.05	179.56	179.56	10256.0
2022-10-27 06:00:00	IWM	ETF	179.61	179.79	179.33	179.36	17014.0
2022-10-27 07:00:00	IWM	ETF	179.39	179.7	179.15	179.22	30883.0
2022-10-27 08:00:00	IWM	ETF	179.54	180.54	179.1	180.21	237684.0
2022-10-27 09:00:00	IWM	ETF	180.28	181.96	179.32	179.84	3888072.0
2022-10-27 10:00:00	IWM	ETF	179.83	181.78	179.58	180.25	3406809.0
2022-10-27 11:00:00	IWM	ETF	180.19	181.72	180.11	180.92	2988589.0
2022-10-27 12:00:00	IWM	ETF	180.93	181.58	180.3309	181.4	2070582.0
2022-10-27 13:00:00	IWM	ETF	181.43	182.0	181.05	181.09	2466002.0
2022-10-27 14:00:00	IWM	ETF	181.09	181.19	179.42	179.55	2036911.0
2022-10-27 15:00:00	IWM	ETF	179.54	179.95	178.87	179.05	4456174.0
2022-10-27 16:00:00	IWM	ETF	179.09	179.36	177.581	179.03	1488425.0
2022-10-27 17:00:00	IWM	ETF	179.02	179.44	178.71	179.34	128324.0
2022-10-27 18:00:00	IWM	ETF	179.11	179.36	178.8	179.03	158419.0
2022-10-27 19:00:00	IWM	ETF	179.02	179.3	178.78	178.78	70900.0
2022-10-27 04:00:00	DIA	ETF	319.53	320.19	319.53	320.19	4150.0
2022-10-27 05:00:00	DIA	ETF	319.86	319.93	319.4	319.46	1780.0

> showing 50 of 16,930 rows — these rows as CSV

> unlock the full archive -- $79 one-time