PREVIEW / etf_30min / 2021-12-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-27.parquet
  size:    665 KB
  rows:    25,621

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-27 04:00:00	SPY	ETF	471.03	471.31	470.82	471.0	3026.0
2021-12-27 04:30:00	SPY	ETF	471.07	471.51	470.88	471.41	5113.0
2021-12-27 05:00:00	SPY	ETF	471.49	471.55	471.33	471.51	6503.0
2021-12-27 05:30:00	SPY	ETF	471.51	471.6	471.47	471.47	4882.0
2021-12-27 06:00:00	SPY	ETF	471.52	471.53	471.45	471.47	5579.0
2021-12-27 06:30:00	SPY	ETF	471.4	471.51	471.29	471.48	3927.0
2021-12-27 07:00:00	SPY	ETF	471.53	471.9	471.45	471.88	25866.0
2021-12-27 07:30:00	SPY	ETF	471.89	472.36	471.88	472.09	119672.0
2021-12-27 08:00:00	SPY	ETF	471.43	472.43	470.6	472.23	84465.0
2021-12-27 08:30:00	SPY	ETF	472.24	472.54	472.19	472.36	109479.0
2021-12-27 09:00:00	SPY	ETF	472.34	472.48	472.02	472.06	257471.0
2021-12-27 09:30:00	SPY	ETF	472.03	473.71	472.01	473.185	4378957.0
2021-12-27 10:00:00	SPY	ETF	473.19	474.66	473.08	474.65	2766913.0
2021-12-27 10:30:00	SPY	ETF	474.66	474.99	474.43	474.98	3255929.0
2021-12-27 11:00:00	SPY	ETF	474.98	475.28	474.633	475.14	2388093.0
2021-12-27 11:30:00	SPY	ETF	475.14	475.29	474.82	475.25	1446254.0
2021-12-27 12:00:00	SPY	ETF	475.26	475.69	475.23	475.68	1546806.0
2021-12-27 12:30:00	SPY	ETF	475.675	475.8	475.48	475.78	1080723.0
2021-12-27 13:00:00	SPY	ETF	475.77	476.1499	475.64	475.99	1649030.0
2021-12-27 13:30:00	SPY	ETF	475.985	476.31	475.84	476.3	1527226.0
2021-12-27 14:00:00	SPY	ETF	476.305	476.6	476.05	476.595	1729891.0
2021-12-27 14:30:00	SPY	ETF	476.6	476.61	475.93	476.17	2491073.0
2021-12-27 15:00:00	SPY	ETF	476.17	476.31	475.6931	476.27	2625401.0
2021-12-27 15:30:00	SPY	ETF	476.27	477.31	476.11	477.27	9577036.0
2021-12-27 16:00:00	SPY	ETF	477.27	477.4	477.05	477.22	2659427.0
2021-12-27 16:30:00	SPY	ETF	477.22	477.32	477.14	477.17	793721.0
2021-12-27 17:00:00	SPY	ETF	477.16	477.26	476.92	477.16	352227.0
2021-12-27 17:30:00	SPY	ETF	477.06	477.16	477.03	477.08	26989.0
2021-12-27 18:00:00	SPY	ETF	477.02	477.22	476.8	476.8	35939.0
2021-12-27 18:30:00	SPY	ETF	477.26	477.26	476.8	476.8	28970.0
2021-12-27 19:00:00	SPY	ETF	476.8	476.88	476.5	476.86	27058.0
2021-12-27 19:30:00	SPY	ETF	476.86	477.01	476.7	476.98	46183.0
2021-12-27 04:00:00	QQQ	ETF	397.37	398.09	397.37	397.91	14030.0
2021-12-27 04:30:00	QQQ	ETF	397.92	398.19	397.64	398.13	3289.0
2021-12-27 05:00:00	QQQ	ETF	398.18	398.24	398.11	398.11	1479.0
2021-12-27 05:30:00	QQQ	ETF	398.17	398.22	398.1	398.1	1754.0
2021-12-27 06:00:00	QQQ	ETF	398.08	398.11	398.02	398.03	3020.0
2021-12-27 06:30:00	QQQ	ETF	398.0	398.0	397.91	398.0	1073.0
2021-12-27 07:00:00	QQQ	ETF	398.06	398.38	397.99	398.38	28627.0
2021-12-27 07:30:00	QQQ	ETF	398.38	399.0	398.38	398.76	97453.0
2021-12-27 08:00:00	QQQ	ETF	398.078	398.98	396.96	398.93	1549986.0
2021-12-27 08:30:00	QQQ	ETF	398.901	399.13	398.9	398.95	53703.0
2021-12-27 09:00:00	QQQ	ETF	398.9	399.02	398.22	398.27	143624.0
2021-12-27 09:30:00	QQQ	ETF	398.26	400.69	398.2194	400.37	4436858.0
2021-12-27 10:00:00	QQQ	ETF	400.42	402.08	400.23	402.08	2716535.0
2021-12-27 10:30:00	QQQ	ETF	402.09	402.54	401.85	402.36	1861028.0
2021-12-27 11:00:00	QQQ	ETF	402.36	402.78	401.68	402.34	1709332.0
2021-12-27 11:30:00	QQQ	ETF	402.36	402.38	401.87	402.1845	999380.0
2021-12-27 12:00:00	QQQ	ETF	402.135	402.5999	402.135	402.5999	759157.0
2021-12-27 12:30:00	QQQ	ETF	402.5821	402.68	402.12	402.64	831184.0

> showing 50 of 25,621 rows — these rows as CSV

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