PREVIEW / etf_30min / 2021-12-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-29.parquet
  size:    641 KB
  rows:    25,363

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.75	7971.0
2021-12-29 04:30:00	SPY	ETF	477.83	477.84	477.8	477.82	2016.0
2021-12-29 05:00:00	SPY	ETF	477.89	477.96	477.62	477.75	5322.0
2021-12-29 05:30:00	SPY	ETF	477.75	477.76	477.52	477.66	4468.0
2021-12-29 06:00:00	SPY	ETF	477.59	477.59	477.19	477.3	5990.0
2021-12-29 06:30:00	SPY	ETF	477.14	477.28	477.1	477.25	2819.0
2021-12-29 07:00:00	SPY	ETF	477.26	477.29	476.91	477.17	16313.0
2021-12-29 07:30:00	SPY	ETF	477.19	477.19	476.86	476.86	10049.0
2021-12-29 08:00:00	SPY	ETF	476.9001	477.8396	476.59	476.72	107685.0
2021-12-29 08:30:00	SPY	ETF	476.74	476.93	476.48	476.92	74289.0
2021-12-29 09:00:00	SPY	ETF	476.89	477.4	476.87	477.02	142798.0
2021-12-29 09:30:00	SPY	ETF	477.0	478.149	476.9	477.58	3836387.0
2021-12-29 10:00:00	SPY	ETF	477.59	477.73	475.92	476.64	3392759.0
2021-12-29 10:30:00	SPY	ETF	476.67	477.45	476.47	477.23	2183294.0
2021-12-29 11:00:00	SPY	ETF	477.22	477.43	476.65	476.7	1664631.0
2021-12-29 11:30:00	SPY	ETF	476.7	476.96	476.44	476.5846	1329846.0
2021-12-29 12:00:00	SPY	ETF	476.6	476.69	476.22	476.2784	1352627.0
2021-12-29 12:30:00	SPY	ETF	476.2767	476.798	476.161	476.785	1550761.0
2021-12-29 13:00:00	SPY	ETF	476.78	477.1	476.71	476.74	1227557.0
2021-12-29 13:30:00	SPY	ETF	476.7499	477.285	476.62	477.18	1102991.0
2021-12-29 14:00:00	SPY	ETF	477.17	477.42	477.025	477.32	1423882.0
2021-12-29 14:30:00	SPY	ETF	477.32	477.63	477.23	477.585	1361037.0
2021-12-29 15:00:00	SPY	ETF	477.58	477.95	477.36	477.9125	2851556.0
2021-12-29 15:30:00	SPY	ETF	477.92	478.56	477.36	477.47	7982328.0
2021-12-29 16:00:00	SPY	ETF	477.47	477.74	477.34	477.42	3262109.0
2021-12-29 16:30:00	SPY	ETF	477.41	477.51	477.35	477.41	158919.0
2021-12-29 17:00:00	SPY	ETF	477.34	477.52	477.34	477.52	23895.0
2021-12-29 17:30:00	SPY	ETF	477.51	477.52	477.4	477.45	12527.0
2021-12-29 18:00:00	SPY	ETF	477.47	477.62	476.89	476.98	101661.0
2021-12-29 18:30:00	SPY	ETF	477.48	477.48	476.98	477.05	38355.0
2021-12-29 19:00:00	SPY	ETF	477.04	477.04	476.64	476.85	46768.0
2021-12-29 19:30:00	SPY	ETF	476.81	477.08	476.81	477.05	34640.0
2021-12-29 04:00:00	QQQ	ETF	402.89	403.31	402.88	403.07	13695.0
2021-12-29 04:30:00	QQQ	ETF	403.09	403.14	403.03	403.14	3284.0
2021-12-29 05:00:00	QQQ	ETF	403.15	403.15	402.88	403.02	6955.0
2021-12-29 05:30:00	QQQ	ETF	402.98	403.09	402.76	402.76	3585.0
2021-12-29 06:00:00	QQQ	ETF	402.72	402.73	402.26	402.38	25965.0
2021-12-29 06:30:00	QQQ	ETF	402.33	402.46	402.26	402.36	3474.0
2021-12-29 07:00:00	QQQ	ETF	402.51	402.53	401.93	402.29	40579.0
2021-12-29 07:30:00	QQQ	ETF	402.25	402.27	401.85	401.89	40912.0
2021-12-29 08:00:00	QQQ	ETF	402.47	403.4	401.13	401.36	148917.0
2021-12-29 08:30:00	QQQ	ETF	401.4	401.59	401.2	401.57	60968.0
2021-12-29 09:00:00	QQQ	ETF	401.48	402.25	401.48	401.78	134499.0
2021-12-29 09:30:00	QQQ	ETF	401.78	403.05	401.32	402.075	3401496.0
2021-12-29 10:00:00	QQQ	ETF	402.12	402.27	399.11	400.27	3726922.0
2021-12-29 10:30:00	QQQ	ETF	400.29	401.24	399.83	401.0	2178315.0
2021-12-29 11:00:00	QQQ	ETF	400.97	401.54	400.5	400.59	1267058.0
2021-12-29 11:30:00	QQQ	ETF	400.6	400.73	400.07	400.25	1433307.0
2021-12-29 12:00:00	QQQ	ETF	400.25	400.49	399.93	400.0568	917654.0
2021-12-29 12:30:00	QQQ	ETF	400.05	400.47	399.79	400.41	1137860.0

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

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