PREVIEW / etf_1hour / 2021-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-21.parquet
  size:    403 KB
  rows:    14,016

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
2021-05-21 04:00:00	SPY	ETF	415.85	416.02	415.36	415.75	6669.0
2021-05-21 05:00:00	SPY	ETF	415.86	416.4	415.86	416.2	25302.0
2021-05-21 06:00:00	SPY	ETF	416.1	416.5	416.02	416.02	22433.0
2021-05-21 07:00:00	SPY	ETF	416.12	417.03	416.12	416.9	157895.0
2021-05-21 08:00:00	SPY	ETF	416.2599	417.0	416.1504	416.53	210076.0
2021-05-21 09:00:00	SPY	ETF	416.58	418.19	416.49	418.17	7395288.0
2021-05-21 10:00:00	SPY	ETF	418.18	418.2	416.34	417.06	8904074.0
2021-05-21 11:00:00	SPY	ETF	417.07	417.27	415.85	415.9596	4833322.0
2021-05-21 12:00:00	SPY	ETF	415.95	416.22	414.45	414.89	6673187.0
2021-05-21 13:00:00	SPY	ETF	414.88	415.94	414.81	415.72	3986831.0
2021-05-21 14:00:00	SPY	ETF	415.73	416.19	414.96	415.735	4826339.0
2021-05-21 15:00:00	SPY	ETF	415.735	416.25	414.7	414.95	14393411.0
2021-05-21 16:00:00	SPY	ETF	414.9501	415.93	414.9035	415.41	3224161.0
2021-05-21 17:00:00	SPY	ETF	415.42	415.55	415.25	415.45	56339.0
2021-05-21 18:00:00	SPY	ETF	415.51	415.68	414.94	415.54	39163.0
2021-05-21 19:00:00	SPY	ETF	415.54	415.56	415.4	415.44	25314.0
2021-05-21 04:00:00	QQQ	ETF	329.74	329.85	329.29	329.47	26996.0
2021-05-21 05:00:00	QQQ	ETF	329.64	329.93	329.53	329.6	32524.0
2021-05-21 06:00:00	QQQ	ETF	329.54	329.78	329.4	329.48	40153.0
2021-05-21 07:00:00	QQQ	ETF	329.48	330.34	329.48	330.18	243281.0
2021-05-21 08:00:00	QQQ	ETF	330.19	330.3096	329.37	329.76	235928.0
2021-05-21 09:00:00	QQQ	ETF	329.78	330.86	328.805	330.2298	4910861.0
2021-05-21 10:00:00	QQQ	ETF	330.23	330.36	327.82	328.485	6031180.0
2021-05-21 11:00:00	QQQ	ETF	328.5	328.81	327.109	327.23	3971932.0
2021-05-21 12:00:00	QQQ	ETF	327.23	327.73	326.71	327.3	4432415.0
2021-05-21 13:00:00	QQQ	ETF	327.29	328.05	326.94	327.83	2959823.0
2021-05-21 14:00:00	QQQ	ETF	327.87	328.26	327.08	327.7772	2794450.0
2021-05-21 15:00:00	QQQ	ETF	327.77	328.11	326.64	326.97	6028028.0
2021-05-21 16:00:00	QQQ	ETF	326.96	327.23	326.85	327.07	1399057.0
2021-05-21 17:00:00	QQQ	ETF	327.01	327.1	326.95	327.01	173127.0
2021-05-21 18:00:00	QQQ	ETF	327.0	327.19	327.0	327.19	12971.0
2021-05-21 19:00:00	QQQ	ETF	327.11	327.13	326.9	327.07	17792.0
2021-05-21 04:00:00	IWM	ETF	219.87	219.94	219.49	219.93	3997.0
2021-05-21 05:00:00	IWM	ETF	220.04	220.5	220.04	220.31	5599.0
2021-05-21 06:00:00	IWM	ETF	220.17	220.58	220.17	220.28	12400.0
2021-05-21 07:00:00	IWM	ETF	220.07	220.99	220.06	220.91	104564.0
2021-05-21 08:00:00	IWM	ETF	220.4396	220.95	219.77	220.77	176208.0
2021-05-21 09:00:00	IWM	ETF	220.78	222.33	220.65	222.14	3524063.0
2021-05-21 10:00:00	IWM	ETF	222.14	222.37	220.55	221.56	2940600.0
2021-05-21 11:00:00	IWM	ETF	221.57	222.2083	220.34	220.53	1829468.0
2021-05-21 12:00:00	IWM	ETF	220.53	220.69	219.51	220.015	1797503.0
2021-05-21 13:00:00	IWM	ETF	220.01	220.66	219.89	220.575	1290761.0
2021-05-21 14:00:00	IWM	ETF	220.6	220.88	220.281	220.83	1180435.0
2021-05-21 15:00:00	IWM	ETF	220.83	221.17	219.9	220.0	3390938.0
2021-05-21 16:00:00	IWM	ETF	219.97	220.41	219.96	220.18	1600508.0
2021-05-21 17:00:00	IWM	ETF	220.28	220.28	219.97	220.05	242609.0
2021-05-21 18:00:00	IWM	ETF	220.07	220.15	220.07	220.15	3604.0
2021-05-21 19:00:00	IWM	ETF	220.18	220.18	220.04	220.15	2757.0
2021-05-21 04:00:00	DIA	ETF	340.88	340.98	340.85	340.98	1141.0
2021-05-21 05:00:00	DIA	ETF	341.42	341.82	341.42	341.74	800.0

> showing 50 of 14,016 rows — these rows as CSV

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