PREVIEW / etf_30min / 2022-12-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-23.parquet
  size:    671 KB
  rows:    26,620

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-23 04:00:00	SPY	ETF	381.07	381.11	380.36	380.6	18877.0
2022-12-23 04:30:00	SPY	ETF	380.59	381.01	380.59	380.9	10836.0
2022-12-23 05:00:00	SPY	ETF	380.97	381.58	380.8	381.58	5116.0
2022-12-23 05:30:00	SPY	ETF	381.64	382.25	381.64	382.03	25730.0
2022-12-23 06:00:00	SPY	ETF	382.04	382.42	381.7	381.71	11039.0
2022-12-23 06:30:00	SPY	ETF	381.7	381.75	381.19	381.34	30052.0
2022-12-23 07:00:00	SPY	ETF	381.37	381.67	381.08	381.5	82866.0
2022-12-23 07:30:00	SPY	ETF	381.67	381.77	381.42	381.63	39163.0
2022-12-23 08:00:00	SPY	ETF	381.56	382.38	380.69	381.26	208356.0
2022-12-23 08:30:00	SPY	ETF	380.87	382.96	378.94	380.79	1199869.0
2022-12-23 09:00:00	SPY	ETF	380.7	380.91	379.6	379.67	323022.0
2022-12-23 09:30:00	SPY	ETF	379.65	381.27	378.03	378.4921	4810986.0
2022-12-23 10:00:00	SPY	ETF	378.485	381.81	378.24	381.4	4788662.0
2022-12-23 10:30:00	SPY	ETF	381.41	382.685	380.58	380.79	3820564.0
2022-12-23 11:00:00	SPY	ETF	380.79	381.45	380.0	380.9299	2780915.0
2022-12-23 11:30:00	SPY	ETF	380.93	382.12	380.8	381.58	1794752.0
2022-12-23 12:00:00	SPY	ETF	381.59	382.67	381.39	382.13	2082441.0
2022-12-23 12:30:00	SPY	ETF	382.13	382.85	381.55	381.86	1851836.0
2022-12-23 13:00:00	SPY	ETF	381.86	382.41	381.57	382.06	1436993.0
2022-12-23 13:30:00	SPY	ETF	382.06	382.4295	381.03	381.47	1313946.0
2022-12-23 14:00:00	SPY	ETF	381.44	382.02	381.065	381.685	1694175.0
2022-12-23 14:30:00	SPY	ETF	381.69	382.6	381.69	382.54	1496512.0
2022-12-23 15:00:00	SPY	ETF	382.53	383.06	381.89	382.05	2956495.0
2022-12-23 15:30:00	SPY	ETF	382.05	382.95	381.56	382.9	6064541.0
2022-12-23 16:00:00	SPY	ETF	382.89	382.97	382.2	382.74	3142377.0
2022-12-23 16:30:00	SPY	ETF	382.75	382.91	382.61	382.63	88965.0
2022-12-23 17:00:00	SPY	ETF	382.76	382.76	382.57	382.66	23225.0
2022-12-23 17:30:00	SPY	ETF	382.69	382.94	382.63	382.94	33873.0
2022-12-23 18:00:00	SPY	ETF	382.93	382.93	382.77	382.85	15244.0
2022-12-23 18:30:00	SPY	ETF	382.89	383.05	382.87	382.97	38577.0
2022-12-23 19:00:00	SPY	ETF	382.95	383.04	382.95	383.04	2691.0
2022-12-23 19:30:00	SPY	ETF	383.0	383.02	382.65	383.0	41733.0
2022-12-23 04:00:00	QQQ	ETF	266.07	266.88	266.07	266.22	17217.0
2022-12-23 04:30:00	QQQ	ETF	266.24	266.61	266.24	266.6	19448.0
2022-12-23 05:00:00	QQQ	ETF	266.65	267.24	266.5	267.24	13806.0
2022-12-23 05:30:00	QQQ	ETF	267.32	268.02	267.29	267.84	44574.0
2022-12-23 06:00:00	QQQ	ETF	267.86	268.23	267.45	267.48	87447.0
2022-12-23 06:30:00	QQQ	ETF	267.52	267.56	267.04	267.13	29934.0
2022-12-23 07:00:00	QQQ	ETF	267.24	267.75	267.06	267.75	92979.0
2022-12-23 07:30:00	QQQ	ETF	267.76	267.89	267.5	267.75	54670.0
2022-12-23 08:00:00	QQQ	ETF	267.4	268.2004	266.68	267.01	198431.0
2022-12-23 08:30:00	QQQ	ETF	266.61	269.0	265.07	266.75	1656013.0
2022-12-23 09:00:00	QQQ	ETF	266.74	266.95	265.4	265.4	611061.0
2022-12-23 09:30:00	QQQ	ETF	265.46	266.72	263.63	264.07	4212992.0
2022-12-23 10:00:00	QQQ	ETF	264.07	266.83	263.53	266.4899	4636285.0
2022-12-23 10:30:00	QQQ	ETF	266.5	268.04	265.7	265.8799	2693655.0
2022-12-23 11:00:00	QQQ	ETF	265.87	266.49	264.94	265.94	2104473.0
2022-12-23 11:30:00	QQQ	ETF	265.94	267.05	265.78	266.3199	1330481.0
2022-12-23 12:00:00	QQQ	ETF	266.32	267.3992	266.13	266.9228	1370631.0
2022-12-23 12:30:00	QQQ	ETF	266.92	267.515	266.33	266.56	1138213.0

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

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