PREVIEW / etf_30min / 2023-01-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-05.parquet
  size:    667 KB
  rows:    26,987

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
2023-01-05 04:00:00	SPY	ETF	383.0	383.42	382.52	383.25	16795.0
2023-01-05 04:30:00	SPY	ETF	383.34	383.6	383.01	383.6	9016.0
2023-01-05 05:00:00	SPY	ETF	383.64	384.1	383.59	383.87	19015.0
2023-01-05 05:30:00	SPY	ETF	383.93	384.32	383.83	384.08	9609.0
2023-01-05 06:00:00	SPY	ETF	384.12	384.6	384.08	384.3	21275.0
2023-01-05 06:30:00	SPY	ETF	384.37	384.71	384.14	384.29	48404.0
2023-01-05 07:00:00	SPY	ETF	384.28	384.56	384.06	384.44	88036.0
2023-01-05 07:30:00	SPY	ETF	384.35	384.92	383.8	383.88	99317.0
2023-01-05 08:00:00	SPY	ETF	384.24	384.9	382.2	382.67	396477.0
2023-01-05 08:30:00	SPY	ETF	382.78	382.78	381.4	381.71	552587.0
2023-01-05 09:00:00	SPY	ETF	381.66	381.74	380.88	381.67	807387.0
2023-01-05 09:30:00	SPY	ETF	381.72	381.76	378.89	380.12	7473489.0
2023-01-05 10:00:00	SPY	ETF	380.13	381.84	379.64	380.23	6505670.0
2023-01-05 10:30:00	SPY	ETF	380.235	380.7	379.28	379.39	3390910.0
2023-01-05 11:00:00	SPY	ETF	379.4	380.34	378.76	379.305	3072475.0
2023-01-05 11:30:00	SPY	ETF	379.2899	380.12	379.13	379.3	1936285.0
2023-01-05 12:00:00	SPY	ETF	379.29	380.19	379.095	379.75	2041598.0
2023-01-05 12:30:00	SPY	ETF	379.7399	380.45	379.335	379.42	1938240.0
2023-01-05 13:00:00	SPY	ETF	379.435	381.43	379.04	380.77	4193371.0
2023-01-05 13:30:00	SPY	ETF	380.77	381.47	380.34	380.57	2948600.0
2023-01-05 14:00:00	SPY	ETF	380.58	381.07	380.06	380.18	2514355.0
2023-01-05 14:30:00	SPY	ETF	380.19	381.71	380.15	380.8009	2356702.0
2023-01-05 15:00:00	SPY	ETF	380.82	380.82	379.39	379.62	3528792.0
2023-01-05 15:30:00	SPY	ETF	379.63	379.955	378.915	379.4	8692053.0
2023-01-05 16:00:00	SPY	ETF	379.4	379.8	379.27	379.76	4612136.0
2023-01-05 16:30:00	SPY	ETF	379.79	379.84	379.65	379.76	191111.0
2023-01-05 17:00:00	SPY	ETF	379.74	379.77	379.4	379.4	37807.0
2023-01-05 17:30:00	SPY	ETF	379.68	379.85	379.64	379.77	28864.0
2023-01-05 18:00:00	SPY	ETF	379.85	380.0	379.7	379.9	82546.0
2023-01-05 18:30:00	SPY	ETF	379.95	380.2	379.38	380.0	264158.0
2023-01-05 19:00:00	SPY	ETF	380.0	380.25	380.0	380.23	16307.0
2023-01-05 19:30:00	SPY	ETF	380.25	380.38	380.18	380.34	20629.0
2023-01-05 04:00:00	QQQ	ETF	265.34	265.54	264.67	265.33	55545.0
2023-01-05 04:30:00	QQQ	ETF	265.45	265.53	265.06	265.53	13542.0
2023-01-05 05:00:00	QQQ	ETF	265.4	266.04	265.4	265.84	22664.0
2023-01-05 05:30:00	QQQ	ETF	265.85	266.29	265.85	266.01	27590.0
2023-01-05 06:00:00	QQQ	ETF	266.05	266.75	266.05	266.5	21678.0
2023-01-05 06:30:00	QQQ	ETF	266.44	266.87	266.33	266.56	40302.0
2023-01-05 07:00:00	QQQ	ETF	266.5	266.78	266.31	266.57	70992.0
2023-01-05 07:30:00	QQQ	ETF	266.56	267.02	266.04	266.1	115457.0
2023-01-05 08:00:00	QQQ	ETF	266.41	266.97	264.72	265.2	386986.0
2023-01-05 08:30:00	QQQ	ETF	264.9	264.9	263.83	264.2	271366.0
2023-01-05 09:00:00	QQQ	ETF	264.19	264.19	263.26	264.03	474971.0
2023-01-05 09:30:00	QQQ	ETF	264.07	264.09	261.5001	262.82	4743030.0
2023-01-05 10:00:00	QQQ	ETF	262.81	264.21	262.26	262.91	3182556.0
2023-01-05 10:30:00	QQQ	ETF	262.91	263.05	261.99	262.16	1788026.0
2023-01-05 11:00:00	QQQ	ETF	262.16	263.12	261.89	262.32	1708890.0
2023-01-05 11:30:00	QQQ	ETF	262.3	263.18	262.15	262.42	1478923.0
2023-01-05 12:00:00	QQQ	ETF	262.44	263.2	261.99	262.485	1190145.0
2023-01-05 12:30:00	QQQ	ETF	262.49	263.04	261.96	262.0	1236339.0

> showing 50 of 26,987 rows — these rows as CSV

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