PREVIEW / etf_1hour / 2021-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-18.parquet
  size:    416 KB
  rows:    14,488

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-18 04:00:00	SPY	ETF	417.07	417.08	416.77	416.77	19902.0
2021-05-18 05:00:00	SPY	ETF	416.75	417.01	416.67	416.74	13922.0
2021-05-18 06:00:00	SPY	ETF	416.67	417.05	416.55	416.66	15225.0
2021-05-18 07:00:00	SPY	ETF	416.68	416.78	415.98	416.16	272915.0
2021-05-18 08:00:00	SPY	ETF	416.15	417.55	415.7	415.88	213869.0
2021-05-18 09:00:00	SPY	ETF	415.87	416.06	414.82	415.11	5998267.0
2021-05-18 10:00:00	SPY	ETF	415.1	415.98	414.46	415.71	7296912.0
2021-05-18 11:00:00	SPY	ETF	415.7	415.8199	414.86	414.89	4165070.0
2021-05-18 12:00:00	SPY	ETF	414.89	415.52	414.75	415.27	3067527.0
2021-05-18 13:00:00	SPY	ETF	415.27	415.59	414.96	414.99	3170254.0
2021-05-18 14:00:00	SPY	ETF	414.97	415.1	413.1	413.99	6835907.0
2021-05-18 15:00:00	SPY	ETF	413.99	414.59	411.77	411.98	14430922.0
2021-05-18 16:00:00	SPY	ETF	411.99	412.32	410.96	411.17	3962495.0
2021-05-18 17:00:00	SPY	ETF	411.17	411.29	411.03	411.12	77931.0
2021-05-18 18:00:00	SPY	ETF	411.12	411.94	411.09	411.5	226204.0
2021-05-18 19:00:00	SPY	ETF	411.48	411.91	410.6	410.6	403983.0
2021-05-18 04:00:00	QQQ	ETF	326.51	327.0	326.51	326.77	43679.0
2021-05-18 05:00:00	QQQ	ETF	326.6	327.05	326.6	326.9	34122.0
2021-05-18 06:00:00	QQQ	ETF	327.05	327.07	326.46	326.6	32905.0
2021-05-18 07:00:00	QQQ	ETF	326.68	326.68	325.91	326.1	136491.0
2021-05-18 08:00:00	QQQ	ETF	326.73	327.36	325.63	325.92	194763.0
2021-05-18 09:00:00	QQQ	ETF	325.88	325.88	324.3	324.97	4527297.0
2021-05-18 10:00:00	QQQ	ETF	324.97	326.65	324.55	326.34	5266279.0
2021-05-18 11:00:00	QQQ	ETF	326.33	326.54	324.9894	325.02	2581789.0
2021-05-18 12:00:00	QQQ	ETF	325.03	326.14	324.95	325.71	1937493.0
2021-05-18 13:00:00	QQQ	ETF	325.72	325.97	324.96	325.08	2371789.0
2021-05-18 14:00:00	QQQ	ETF	325.06	325.24	322.86	323.56	4705271.0
2021-05-18 15:00:00	QQQ	ETF	323.56	324.59	321.94	322.15	5684484.0
2021-05-18 16:00:00	QQQ	ETF	322.15	322.4	321.37	321.58	1026375.0
2021-05-18 17:00:00	QQQ	ETF	321.5	321.65	321.45	321.47	33293.0
2021-05-18 18:00:00	QQQ	ETF	321.45	322.13	321.4	321.97	91972.0
2021-05-18 19:00:00	QQQ	ETF	321.97	322.4	321.08	321.12	140947.0
2021-05-18 04:00:00	IWM	ETF	222.2	222.31	221.98	221.98	11840.0
2021-05-18 05:00:00	IWM	ETF	222.11	222.11	221.91	221.91	5050.0
2021-05-18 06:00:00	IWM	ETF	222.2	222.2	222.0	222.15	6500.0
2021-05-18 07:00:00	IWM	ETF	222.17	222.4	221.86	221.88	31980.0
2021-05-18 08:00:00	IWM	ETF	221.99	222.58	221.37	221.55	89003.0
2021-05-18 09:00:00	IWM	ETF	221.51	222.43	220.52	222.11	2814294.0
2021-05-18 10:00:00	IWM	ETF	222.1	223.24	221.32	222.76	3314843.0
2021-05-18 11:00:00	IWM	ETF	222.78	222.99	221.95	222.27	1965092.0
2021-05-18 12:00:00	IWM	ETF	222.28	222.57	221.84	222.21	1429594.0
2021-05-18 13:00:00	IWM	ETF	222.22	222.65	222.13	222.34	1119777.0
2021-05-18 14:00:00	IWM	ETF	222.36	222.41	220.34	221.32	3078016.0
2021-05-18 15:00:00	IWM	ETF	221.32	221.69	219.47	219.63	4298876.0
2021-05-18 16:00:00	IWM	ETF	219.64	220.05	218.95	219.3	935986.0
2021-05-18 17:00:00	IWM	ETF	219.3	219.31	219.05	219.08	15714.0
2021-05-18 18:00:00	IWM	ETF	219.06	219.74	218.86	219.5	66376.0
2021-05-18 19:00:00	IWM	ETF	219.59	219.77	218.84	218.92	53666.0
2021-05-18 04:00:00	DIA	ETF	344.75	344.75	344.52	344.52	3200.0
2021-05-18 05:00:00	DIA	ETF	344.55	344.55	344.17	344.17	1355.0

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

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