PREVIEW / etf_30min / 2022-12-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-27.parquet
  size:    712 KB
  rows:    28,407

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-27 04:00:00	SPY	ETF	384.17	385.2	384.17	384.9	25459.0
2022-12-27 04:30:00	SPY	ETF	385.13	385.52	385.08	385.46	13033.0
2022-12-27 05:00:00	SPY	ETF	385.46	385.66	385.4	385.66	6993.0
2022-12-27 05:30:00	SPY	ETF	385.71	385.71	385.38	385.38	13906.0
2022-12-27 06:00:00	SPY	ETF	385.45	385.47	385.16	385.41	11446.0
2022-12-27 06:30:00	SPY	ETF	385.35	385.39	385.26	385.33	4445.0
2022-12-27 07:00:00	SPY	ETF	385.27	385.27	384.72	384.75	99651.0
2022-12-27 07:30:00	SPY	ETF	384.71	384.79	384.13	384.37	88584.0
2022-12-27 08:00:00	SPY	ETF	385.11	385.55	384.0	384.6	130768.0
2022-12-27 08:30:00	SPY	ETF	384.61	384.63	382.96	382.96	284909.0
2022-12-27 09:00:00	SPY	ETF	382.94	383.35	382.76	382.79	160503.0
2022-12-27 09:30:00	SPY	ETF	382.79	383.01	380.03	380.5114	4826513.0
2022-12-27 10:00:00	SPY	ETF	380.52	382.97	379.65	382.41	4341558.0
2022-12-27 10:30:00	SPY	ETF	382.4	383.15	381.81	381.925	3168917.0
2022-12-27 11:00:00	SPY	ETF	381.93	382.44	381.61	382.3499	2354644.0
2022-12-27 11:30:00	SPY	ETF	382.35	382.9	381.951	382.29	1601067.0
2022-12-27 12:00:00	SPY	ETF	382.32	383.12	382.07	382.13	1579612.0
2022-12-27 12:30:00	SPY	ETF	382.1299	382.42	381.465	382.105	1520723.0
2022-12-27 13:00:00	SPY	ETF	382.11	382.61	381.91	381.9699	1125298.0
2022-12-27 13:30:00	SPY	ETF	381.97	382.04	381.01	381.18	1916013.0
2022-12-27 14:00:00	SPY	ETF	381.15	381.69	380.635	380.73	2565608.0
2022-12-27 14:30:00	SPY	ETF	380.73	381.5	380.5	381.3399	1918203.0
2022-12-27 15:00:00	SPY	ETF	381.34	382.12	381.1379	381.97	2111678.0
2022-12-27 15:30:00	SPY	ETF	381.98	382.36	380.71	381.39	6462542.0
2022-12-27 16:00:00	SPY	ETF	381.39	381.76	381.37	381.61	1319098.0
2022-12-27 16:30:00	SPY	ETF	381.59	381.61	381.44	381.5	53464.0
2022-12-27 17:00:00	SPY	ETF	381.45	381.54	381.4	381.5	4685.0
2022-12-27 17:30:00	SPY	ETF	381.5	381.55	381.45	381.55	6185.0
2022-12-27 18:00:00	SPY	ETF	381.55	381.78	381.42	381.71	40058.0
2022-12-27 18:30:00	SPY	ETF	381.71	381.75	381.29	381.31	18475.0
2022-12-27 19:00:00	SPY	ETF	381.4	381.7	381.14	381.16	44936.0
2022-12-27 19:30:00	SPY	ETF	381.26	381.4	381.0	381.09	22936.0
2022-12-27 04:00:00	QQQ	ETF	269.29	269.44	268.31	268.7	57928.0
2022-12-27 04:30:00	QQQ	ETF	268.68	269.11	268.68	268.99	15392.0
2022-12-27 05:00:00	QQQ	ETF	268.98	269.24	268.97	269.11	11313.0
2022-12-27 05:30:00	QQQ	ETF	269.17	269.17	268.85	268.85	12842.0
2022-12-27 06:00:00	QQQ	ETF	268.85	269.06	268.72	268.89	12212.0
2022-12-27 06:30:00	QQQ	ETF	268.89	268.91	268.6	268.73	16266.0
2022-12-27 07:00:00	QQQ	ETF	268.73	268.75	268.06	268.09	103652.0
2022-12-27 07:30:00	QQQ	ETF	268.01	268.15	267.43	267.63	82857.0
2022-12-27 08:00:00	QQQ	ETF	268.6603	269.45	267.43	267.98	116371.0
2022-12-27 08:30:00	QQQ	ETF	267.95	267.98	266.52	266.86	249378.0
2022-12-27 09:00:00	QQQ	ETF	266.83	267.36	266.72	266.7204	216751.0
2022-12-27 09:30:00	QQQ	ETF	266.74	266.85	263.23	263.85	3918691.0
2022-12-27 10:00:00	QQQ	ETF	263.82	265.65	263.03	265.24	3202096.0
2022-12-27 10:30:00	QQQ	ETF	265.21	265.98	264.5399	264.87	2333644.0
2022-12-27 11:00:00	QQQ	ETF	264.9	265.15	264.34	265.09	1447092.0
2022-12-27 11:30:00	QQQ	ETF	265.075	265.5	264.66	264.745	1619987.0
2022-12-27 12:00:00	QQQ	ETF	264.74	265.48	264.48	264.5006	1198513.0
2022-12-27 12:30:00	QQQ	ETF	264.51	265.1	263.86	264.425	1848457.0

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

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