PREVIEW / etf_30min / 2022-01-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-04.parquet
  size:    679 KB
  rows:    26,811

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
2022-01-04 04:00:00	SPY	ETF	478.49	478.71	478.43	478.66	10451.0
2022-01-04 04:30:00	SPY	ETF	478.64	478.72	478.47	478.68	8570.0
2022-01-04 05:00:00	SPY	ETF	478.81	479.5	478.81	479.45	17858.0
2022-01-04 05:30:00	SPY	ETF	479.58	479.61	479.38	479.5	12465.0
2022-01-04 06:00:00	SPY	ETF	479.47	479.84	479.43	479.53	12709.0
2022-01-04 06:30:00	SPY	ETF	479.6	479.63	479.41	479.41	6354.0
2022-01-04 07:00:00	SPY	ETF	479.4	479.45	478.65	478.75	73107.0
2022-01-04 07:30:00	SPY	ETF	478.72	479.08	478.72	479.06	99107.0
2022-01-04 08:00:00	SPY	ETF	479.3601	479.7704	478.068	479.43	219206.0
2022-01-04 08:30:00	SPY	ETF	479.42	479.48	479.1	479.35	121672.0
2022-01-04 09:00:00	SPY	ETF	479.35	479.46	479.1	479.23	200213.0
2022-01-04 09:30:00	SPY	ETF	479.22	479.98	479.055	479.69	5612935.0
2022-01-04 10:00:00	SPY	ETF	479.68	479.72	478.71	479.59	3249617.0
2022-01-04 10:30:00	SPY	ETF	479.58	479.76	477.51	477.62	4208914.0
2022-01-04 11:00:00	SPY	ETF	477.63	477.67	476.42	476.9686	3758270.0
2022-01-04 11:30:00	SPY	ETF	476.95	477.99	476.825	477.49	2474619.0
2022-01-04 12:00:00	SPY	ETF	477.47	477.95	477.11	477.54	1585181.0
2022-01-04 12:30:00	SPY	ETF	477.53	477.61	476.71	476.83	1625212.0
2022-01-04 13:00:00	SPY	ETF	476.81	477.33	476.6	476.77	1329619.0
2022-01-04 13:30:00	SPY	ETF	476.8	476.83	475.58	475.72	2218090.0
2022-01-04 14:00:00	SPY	ETF	475.72	476.66	475.67	476.55	3015820.0
2022-01-04 14:30:00	SPY	ETF	476.54	477.565	476.49	477.415	2620313.0
2022-01-04 15:00:00	SPY	ETF	477.42	478.32	477.38	478.25	3345636.0
2022-01-04 15:30:00	SPY	ETF	478.26	478.96	477.44	477.51	9926563.0
2022-01-04 16:00:00	SPY	ETF	477.51	477.65	477.25	477.41	2927151.0
2022-01-04 16:30:00	SPY	ETF	477.42	477.48	477.28	477.45	60625.0
2022-01-04 17:00:00	SPY	ETF	477.44	477.54	477.35	477.5	47689.0
2022-01-04 17:30:00	SPY	ETF	477.44	477.44	477.34	477.4	9738.0
2022-01-04 18:00:00	SPY	ETF	477.38	477.54	476.95	477.1	155007.0
2022-01-04 18:30:00	SPY	ETF	477.55	477.55	476.9	477.03	55118.0
2022-01-04 19:00:00	SPY	ETF	476.95	477.03	476.65	476.81	30610.0
2022-01-04 19:30:00	SPY	ETF	476.8	476.84	476.63	476.84	23636.0
2022-01-04 04:00:00	QQQ	ETF	401.78	402.23	401.78	402.2	17582.0
2022-01-04 04:30:00	QQQ	ETF	402.22	402.44	402.08	402.44	8021.0
2022-01-04 05:00:00	QQQ	ETF	402.55	403.16	402.53	403.15	7823.0
2022-01-04 05:30:00	QQQ	ETF	403.18	403.18	402.95	403.16	11510.0
2022-01-04 06:00:00	QQQ	ETF	403.0	403.56	402.95	403.17	13436.0
2022-01-04 06:30:00	QQQ	ETF	403.18	403.2	402.99	402.99	12722.0
2022-01-04 07:00:00	QQQ	ETF	402.94	403.02	401.88	401.98	86553.0
2022-01-04 07:30:00	QQQ	ETF	401.93	402.44	401.93	402.4	54147.0
2022-01-04 08:00:00	QQQ	ETF	402.4	403.3404	401.92	402.7	99810.0
2022-01-04 08:30:00	QQQ	ETF	402.59	402.68	402.13	402.58	49959.0
2022-01-04 09:00:00	QQQ	ETF	402.65	402.68	402.11	402.21	99029.0
2022-01-04 09:30:00	QQQ	ETF	402.24	402.29	400.65	401.0701	4107941.0
2022-01-04 10:00:00	QQQ	ETF	401.07	401.16	398.75	399.7	4239239.0
2022-01-04 10:30:00	QQQ	ETF	399.68	399.7318	395.28	395.37	5632606.0
2022-01-04 11:00:00	QQQ	ETF	395.38	395.4293	393.83	394.62	5153829.0
2022-01-04 11:30:00	QQQ	ETF	394.6	395.97	394.4	394.89	3391980.0
2022-01-04 12:00:00	QQQ	ETF	394.86	395.5	394.25	394.99	2211631.0
2022-01-04 12:30:00	QQQ	ETF	394.99	395.22	394.12	394.32	2100629.0

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

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