PREVIEW / etf_30min / 2021-12-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-28.parquet
  size:    650 KB
  rows:    25,284

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-28 04:00:00	SPY	ETF	477.81	478.39	477.69	478.33	23113.0
2021-12-28 04:30:00	SPY	ETF	478.29	478.47	478.21	478.4	8609.0
2021-12-28 05:00:00	SPY	ETF	478.46	478.69	478.44	478.46	8891.0
2021-12-28 05:30:00	SPY	ETF	478.37	478.56	478.3	478.3	4495.0
2021-12-28 06:00:00	SPY	ETF	478.49	478.52	478.34	478.52	9219.0
2021-12-28 06:30:00	SPY	ETF	478.52	478.52	478.17	478.2	4018.0
2021-12-28 07:00:00	SPY	ETF	478.24	478.58	478.14	478.55	19579.0
2021-12-28 07:30:00	SPY	ETF	478.53	478.66	478.5	478.5	29431.0
2021-12-28 08:00:00	SPY	ETF	478.41	478.68	476.95	478.44	88859.0
2021-12-28 08:30:00	SPY	ETF	478.44	478.62	477.89	477.91	87038.0
2021-12-28 09:00:00	SPY	ETF	477.99	478.02	477.45	477.76	222823.0
2021-12-28 09:30:00	SPY	ETF	477.72	478.81	477.23	478.47	4093328.0
2021-12-28 10:00:00	SPY	ETF	478.4911	478.75	477.11	477.92	2737658.0
2021-12-28 10:30:00	SPY	ETF	477.92	478.4367	477.59	477.84	1984961.0
2021-12-28 11:00:00	SPY	ETF	477.84	478.13	477.17	477.58	2275241.0
2021-12-28 11:30:00	SPY	ETF	477.59	478.16	477.275	478.05	1493065.0
2021-12-28 12:00:00	SPY	ETF	478.05	478.09	476.81	476.86	1410479.0
2021-12-28 12:30:00	SPY	ETF	476.85	477.03	476.06	476.77	1873078.0
2021-12-28 13:00:00	SPY	ETF	476.77	477.0	476.44	476.88	1043131.0
2021-12-28 13:30:00	SPY	ETF	476.875	477.19	476.52	477.17	949186.0
2021-12-28 14:00:00	SPY	ETF	477.17	477.17	476.24	476.67	1350430.0
2021-12-28 14:30:00	SPY	ETF	476.665	477.06	476.48	476.99	1311088.0
2021-12-28 15:00:00	SPY	ETF	477.0	477.169	476.61	476.98	1700778.0
2021-12-28 15:30:00	SPY	ETF	476.96	477.7	476.44	476.8901	6685586.0
2021-12-28 16:00:00	SPY	ETF	476.89	477.43	476.7109	476.87	1947271.0
2021-12-28 16:30:00	SPY	ETF	477.33	477.33	477.02	477.02	191586.0
2021-12-28 17:00:00	SPY	ETF	477.02	477.05	476.86	476.86	39937.0
2021-12-28 17:30:00	SPY	ETF	476.95	477.02	476.87	477.02	15437.0
2021-12-28 18:00:00	SPY	ETF	477.02	477.44	477.02	477.39	69972.0
2021-12-28 18:30:00	SPY	ETF	476.87	477.63	476.87	477.52	16843.0
2021-12-28 19:00:00	SPY	ETF	477.59	477.64	477.36	477.45	13737.0
2021-12-28 19:30:00	SPY	ETF	477.43	477.58	477.33	477.58	12742.0
2021-12-28 04:00:00	QQQ	ETF	404.46	405.18	404.45	405.09	26920.0
2021-12-28 04:30:00	QQQ	ETF	405.05	405.29	404.93	405.25	44976.0
2021-12-28 05:00:00	QQQ	ETF	405.31	405.64	405.3	405.43	20000.0
2021-12-28 05:30:00	QQQ	ETF	405.35	405.51	405.29	405.49	10029.0
2021-12-28 06:00:00	QQQ	ETF	405.54	405.54	405.32	405.43	7025.0
2021-12-28 06:30:00	QQQ	ETF	405.42	405.42	405.13	405.25	7879.0
2021-12-28 07:00:00	QQQ	ETF	405.2	405.48	405.0	405.41	51332.0
2021-12-28 07:30:00	QQQ	ETF	405.46	405.71	405.36	405.36	50715.0
2021-12-28 08:00:00	QQQ	ETF	405.0001	405.6296	403.22	405.2	91399.0
2021-12-28 08:30:00	QQQ	ETF	405.16	405.27	404.56	404.57	82636.0
2021-12-28 09:00:00	QQQ	ETF	404.66	404.73	404.0	404.34	138487.0
2021-12-28 09:30:00	QQQ	ETF	404.36	404.58	402.4	403.7499	4599138.0
2021-12-28 10:00:00	QQQ	ETF	403.73	403.98	401.685	403.11	3217798.0
2021-12-28 10:30:00	QQQ	ETF	403.11	403.94	402.67	402.98	1996108.0
2021-12-28 11:00:00	QQQ	ETF	403.0	403.48	402.1	402.54	1397120.0
2021-12-28 11:30:00	QQQ	ETF	402.55	403.3	401.77	403.17	1351619.0
2021-12-28 12:00:00	QQQ	ETF	403.18	403.31	402.03	402.07	1050979.0
2021-12-28 12:30:00	QQQ	ETF	402.04	402.2899	401.08	401.88	1419860.0

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

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