PREVIEW / etf_1hour / 2021-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-24.parquet
  size:    418 KB
  rows:    14,627

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-08-24 04:00:00	SPY	ETF	447.98	448.44	447.98	448.19	16633.0
2021-08-24 05:00:00	SPY	ETF	448.11	448.29	447.68	447.75	34613.0
2021-08-24 06:00:00	SPY	ETF	447.75	448.1	447.74	448.1	24637.0
2021-08-24 07:00:00	SPY	ETF	448.17	448.19	447.77	447.8	117522.0
2021-08-24 08:00:00	SPY	ETF	448.19	448.25	447.36	447.56	310251.0
2021-08-24 09:00:00	SPY	ETF	447.63	448.18	447.42	448.01	4961256.0
2021-08-24 10:00:00	SPY	ETF	448.02	448.46	447.82	448.19	4183409.0
2021-08-24 11:00:00	SPY	ETF	448.19	448.38	447.74	448.025	3077188.0
2021-08-24 12:00:00	SPY	ETF	448.03	448.035	447.59	447.92	1708940.0
2021-08-24 13:00:00	SPY	ETF	447.925	448.32	447.91	448.23	1916887.0
2021-08-24 14:00:00	SPY	ETF	448.24	448.5	448.215	448.47	2610464.0
2021-08-24 15:00:00	SPY	ETF	448.48	448.54	447.69	447.95	7513074.0
2021-08-24 16:00:00	SPY	ETF	447.96	448.4	447.53	448.02	2629385.0
2021-08-24 17:00:00	SPY	ETF	448.0	448.17	447.97	448.1	302307.0
2021-08-24 18:00:00	SPY	ETF	448.1	448.12	447.97	447.98	72200.0
2021-08-24 19:00:00	SPY	ETF	447.98	447.98	447.67	447.791	127045.0
2021-08-24 04:00:00	QQQ	ETF	374.11	374.98	374.11	374.8	70227.0
2021-08-24 05:00:00	QQQ	ETF	374.8	374.98	374.16	374.28	66565.0
2021-08-24 06:00:00	QQQ	ETF	374.31	374.4	374.15	374.31	32467.0
2021-08-24 07:00:00	QQQ	ETF	374.34	374.38	373.78	373.88	114768.0
2021-08-24 08:00:00	QQQ	ETF	374.26	374.83	373.3	373.63	231200.0
2021-08-24 09:00:00	QQQ	ETF	373.68	374.33	373.36	373.81	3334450.0
2021-08-24 10:00:00	QQQ	ETF	373.82	374.99	373.605	374.47	3223640.0
2021-08-24 11:00:00	QQQ	ETF	374.47	374.68	373.83	374.48	2327074.0
2021-08-24 12:00:00	QQQ	ETF	374.49	374.54	373.77	374.03	1316676.0
2021-08-24 13:00:00	QQQ	ETF	374.04	374.3599	373.89	374.1833	1254780.0
2021-08-24 14:00:00	QQQ	ETF	374.19	374.549	374.05	374.53	995085.0
2021-08-24 15:00:00	QQQ	ETF	374.54	374.8	374.12	374.39	3107156.0
2021-08-24 16:00:00	QQQ	ETF	374.4	374.56	374.26	374.52	574396.0
2021-08-24 17:00:00	QQQ	ETF	374.49	374.74	374.45	374.6	78033.0
2021-08-24 18:00:00	QQQ	ETF	374.61	374.61	374.41	374.4101	43413.0
2021-08-24 19:00:00	QQQ	ETF	374.44	374.45	374.3	374.42	25572.0
2021-08-24 04:00:00	IWM	ETF	220.21	220.68	220.2	220.36	17836.0
2021-08-24 05:00:00	IWM	ETF	220.31	220.35	219.95	220.0	17354.0
2021-08-24 06:00:00	IWM	ETF	220.02	220.63	220.02	220.56	14910.0
2021-08-24 07:00:00	IWM	ETF	220.68	220.75	220.5	220.63	20564.0
2021-08-24 08:00:00	IWM	ETF	220.7499	220.96	219.83	220.17	80964.0
2021-08-24 09:00:00	IWM	ETF	220.15	220.97	219.62	220.69	2561586.0
2021-08-24 10:00:00	IWM	ETF	220.66	221.05	219.69	220.98	2328726.0
2021-08-24 11:00:00	IWM	ETF	220.99	221.32	220.4	220.54	1588332.0
2021-08-24 12:00:00	IWM	ETF	220.56	221.12	220.33	221.0	1064841.0
2021-08-24 13:00:00	IWM	ETF	221.0	221.6	220.97	221.51	1136398.0
2021-08-24 14:00:00	IWM	ETF	221.51	221.75	221.13	221.71	1724010.0
2021-08-24 15:00:00	IWM	ETF	221.72	221.92	221.44	221.77	3892057.0
2021-08-24 16:00:00	IWM	ETF	221.78	222.0	221.64	221.99	1131871.0
2021-08-24 17:00:00	IWM	ETF	221.97	222.0	221.78	221.99	14481.0
2021-08-24 18:00:00	IWM	ETF	221.93	221.98	221.87	221.87	26333.0
2021-08-24 19:00:00	IWM	ETF	221.84	221.84	221.62	221.67	20224.0
2021-08-24 04:00:00	DIA	ETF	354.02	354.08	353.87	353.87	800.0
2021-08-24 05:00:00	DIA	ETF	353.65	353.66	353.57	353.57	1100.0

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

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