PREVIEW / etf_1hour / 2021-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-29.parquet
  size:    439 KB
  rows:    15,697

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-12-29 04:00:00	SPY	ETF	477.9	477.93	477.6	477.82	9987.0
2021-12-29 05:00:00	SPY	ETF	477.89	477.96	477.52	477.66	9790.0
2021-12-29 06:00:00	SPY	ETF	477.59	477.59	477.1	477.25	8809.0
2021-12-29 07:00:00	SPY	ETF	477.26	477.29	476.86	476.86	26362.0
2021-12-29 08:00:00	SPY	ETF	476.9001	477.8396	476.48	476.92	181974.0
2021-12-29 09:00:00	SPY	ETF	476.89	478.149	476.87	477.58	3979185.0
2021-12-29 10:00:00	SPY	ETF	477.59	477.73	475.92	477.23	5576053.0
2021-12-29 11:00:00	SPY	ETF	477.22	477.43	476.44	476.5846	2994477.0
2021-12-29 12:00:00	SPY	ETF	476.6	476.798	476.161	476.785	2903388.0
2021-12-29 13:00:00	SPY	ETF	476.78	477.285	476.62	477.18	2330548.0
2021-12-29 14:00:00	SPY	ETF	477.17	477.63	477.025	477.585	2784919.0
2021-12-29 15:00:00	SPY	ETF	477.58	478.56	477.36	477.47	10833884.0
2021-12-29 16:00:00	SPY	ETF	477.47	477.74	477.34	477.41	3421028.0
2021-12-29 17:00:00	SPY	ETF	477.34	477.52	477.34	477.45	36422.0
2021-12-29 18:00:00	SPY	ETF	477.47	477.62	476.89	477.05	140016.0
2021-12-29 19:00:00	SPY	ETF	477.04	477.08	476.64	477.05	81408.0
2021-12-29 04:00:00	QQQ	ETF	402.89	403.31	402.88	403.14	16979.0
2021-12-29 05:00:00	QQQ	ETF	403.15	403.15	402.76	402.76	10540.0
2021-12-29 06:00:00	QQQ	ETF	402.72	402.73	402.26	402.36	29439.0
2021-12-29 07:00:00	QQQ	ETF	402.51	402.53	401.85	401.89	81491.0
2021-12-29 08:00:00	QQQ	ETF	402.47	403.4	401.13	401.57	209885.0
2021-12-29 09:00:00	QQQ	ETF	401.48	403.05	401.32	402.075	3535995.0
2021-12-29 10:00:00	QQQ	ETF	402.12	402.27	399.11	401.0	5905237.0
2021-12-29 11:00:00	QQQ	ETF	400.97	401.54	400.07	400.25	2700365.0
2021-12-29 12:00:00	QQQ	ETF	400.25	400.49	399.79	400.41	2055514.0
2021-12-29 13:00:00	QQQ	ETF	400.42	401.17	400.36	401.03	1897340.0
2021-12-29 14:00:00	QQQ	ETF	401.02	401.97	400.86	401.88	1959919.0
2021-12-29 15:00:00	QQQ	ETF	401.86	402.459	401.37	401.6	3812719.0
2021-12-29 16:00:00	QQQ	ETF	401.6	401.75	401.3	401.34	2397733.0
2021-12-29 17:00:00	QQQ	ETF	401.33	401.41	401.33	401.37	7638.0
2021-12-29 18:00:00	QQQ	ETF	401.43	401.66	400.82	400.98	120360.0
2021-12-29 19:00:00	QQQ	ETF	400.88	400.9	400.5	400.89	66658.0
2021-12-29 04:00:00	IWM	ETF	223.18	223.39	222.92	223.34	20086.0
2021-12-29 05:00:00	IWM	ETF	223.4	223.47	223.05	223.23	22145.0
2021-12-29 06:00:00	IWM	ETF	223.08	223.17	222.67	222.92	22750.0
2021-12-29 07:00:00	IWM	ETF	222.88	222.96	222.54	222.6	32144.0
2021-12-29 08:00:00	IWM	ETF	222.5401	223.33	222.43	222.81	94760.0
2021-12-29 09:00:00	IWM	ETF	222.82	223.19	221.64	222.19	3248673.0
2021-12-29 10:00:00	IWM	ETF	222.2	223.105	221.255	223.105	2543028.0
2021-12-29 11:00:00	IWM	ETF	223.1	223.4901	222.605	222.77	1180920.0
2021-12-29 12:00:00	IWM	ETF	222.77	222.87	222.33	222.66	827382.0
2021-12-29 13:00:00	IWM	ETF	222.65	223.01	222.58	222.92	723007.0
2021-12-29 14:00:00	IWM	ETF	222.91	223.11	222.46	222.8	1323396.0
2021-12-29 15:00:00	IWM	ETF	222.8	223.205	222.3	222.99	2702369.0
2021-12-29 16:00:00	IWM	ETF	222.99	223.12	222.57	222.62	1148436.0
2021-12-29 17:00:00	IWM	ETF	222.78	222.78	222.53	222.56	3716.0
2021-12-29 18:00:00	IWM	ETF	222.68	222.76	222.33	222.49	29540.0
2021-12-29 19:00:00	IWM	ETF	222.47	222.47	222.16	222.31	66859.0
2021-12-29 04:00:00	DIA	ETF	364.21	364.21	364.21	364.21	411.0
2021-12-29 06:00:00	DIA	ETF	364.09	364.11	364.09	364.11	2099.0

> showing 50 of 15,697 rows — these rows as CSV

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