PREVIEW / etf_30min / 2022-12-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-20.parquet
  size:    705 KB
  rows:    28,324

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-12-20 04:00:00	SPY	ETF	379.69	379.97	379.16	379.66	38779.0
2022-12-20 04:30:00	SPY	ETF	379.71	380.25	379.33	379.92	42983.0
2022-12-20 05:00:00	SPY	ETF	379.9	380.14	379.56	379.96	7311.0
2022-12-20 05:30:00	SPY	ETF	380.0	380.0	379.23	379.74	24795.0
2022-12-20 06:00:00	SPY	ETF	379.85	380.4	379.73	380.24	35028.0
2022-12-20 06:30:00	SPY	ETF	380.32	380.32	379.61	379.72	25222.0
2022-12-20 07:00:00	SPY	ETF	379.87	380.43	379.65	380.18	140447.0
2022-12-20 07:30:00	SPY	ETF	380.09	380.09	378.95	378.95	144400.0
2022-12-20 08:00:00	SPY	ETF	378.96	380.3996	376.2	379.11	272757.0
2022-12-20 08:30:00	SPY	ETF	379.09	379.92	378.85	379.23	203288.0
2022-12-20 09:00:00	SPY	ETF	379.27	379.33	378.81	379.22	216197.0
2022-12-20 09:30:00	SPY	ETF	379.23	380.27	377.85	380.04	5757795.0
2022-12-20 10:00:00	SPY	ETF	380.07	381.65	378.43	381.4701	5464146.0
2022-12-20 10:30:00	SPY	ETF	381.48	382.14	381.23	381.29	3998174.0
2022-12-20 11:00:00	SPY	ETF	381.29	381.54	378.85	379.18	3742290.0
2022-12-20 11:30:00	SPY	ETF	379.17	380.71	379.09	380.627	3161035.0
2022-12-20 12:00:00	SPY	ETF	380.63	381.29	380.51	380.67	2748027.0
2022-12-20 12:30:00	SPY	ETF	380.64	381.19	380.01	381.1417	2360801.0
2022-12-20 13:00:00	SPY	ETF	381.16	381.685	380.535	381.5	2313210.0
2022-12-20 13:30:00	SPY	ETF	381.51	382.23	381.16	381.26	2343885.0
2022-12-20 14:00:00	SPY	ETF	381.27	382.02	381.06	381.36	2637327.0
2022-12-20 14:30:00	SPY	ETF	381.37	381.43	380.47	380.7	2700961.0
2022-12-20 15:00:00	SPY	ETF	380.71	381.18	380.06	381.03	3989809.0
2022-12-20 15:30:00	SPY	ETF	381.03	381.58	380.4	380.52	5888287.0
2022-12-20 16:00:00	SPY	ETF	380.51	380.76	380.28	380.6	4216760.0
2022-12-20 16:30:00	SPY	ETF	380.6	380.99	380.504	380.99	129989.0
2022-12-20 17:00:00	SPY	ETF	380.98	381.14	380.54	381.0001	199011.0
2022-12-20 17:30:00	SPY	ETF	381.1	381.25	381.0	381.25	32507.0
2022-12-20 18:00:00	SPY	ETF	381.24	381.78	381.23	381.77	95159.0
2022-12-20 18:30:00	SPY	ETF	381.74	382.0	381.6	381.77	58660.0
2022-12-20 19:00:00	SPY	ETF	381.79	381.85	381.26	381.38	28153.0
2022-12-20 19:30:00	SPY	ETF	381.38	382.4	381.38	382.03	55150.0
2022-12-20 04:00:00	QQQ	ETF	269.24	269.47	268.0	269.25	33745.0
2022-12-20 04:30:00	QQQ	ETF	269.28	269.64	268.98	269.1	24433.0
2022-12-20 05:00:00	QQQ	ETF	269.31	269.53	269.03	269.53	8390.0
2022-12-20 05:30:00	QQQ	ETF	269.45	269.45	268.87	269.22	13491.0
2022-12-20 06:00:00	QQQ	ETF	269.26	269.83	269.16	269.8	20124.0
2022-12-20 06:30:00	QQQ	ETF	269.67	269.67	269.19	269.36	19017.0
2022-12-20 07:00:00	QQQ	ETF	269.38	269.65	269.2	269.45	59224.0
2022-12-20 07:30:00	QQQ	ETF	269.45	269.45	268.28	268.31	88632.0
2022-12-20 08:00:00	QQQ	ETF	268.39	269.952	266.75	268.52	278650.0
2022-12-20 08:30:00	QQQ	ETF	268.57	269.19	268.33	268.66	186098.0
2022-12-20 09:00:00	QQQ	ETF	268.68	268.68	268.19	268.55	329021.0
2022-12-20 09:30:00	QQQ	ETF	268.55	269.63	266.95	269.4	4717796.0
2022-12-20 10:00:00	QQQ	ETF	269.41	270.64	269.15	270.475	3227018.0
2022-12-20 10:30:00	QQQ	ETF	270.48	271.32	269.94	270.0	2222931.0
2022-12-20 11:00:00	QQQ	ETF	269.97	270.47	267.81	268.1068	3013663.0
2022-12-20 11:30:00	QQQ	ETF	268.1	269.66	268.01	269.59	2220190.0
2022-12-20 12:00:00	QQQ	ETF	269.6	270.425	269.49	269.697	1822180.0
2022-12-20 12:30:00	QQQ	ETF	269.71	270.03	269.05	270.02	1058918.0

> showing 50 of 28,324 rows — these rows as CSV

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