PREVIEW / etf_30min / 2023-01-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-06.parquet
  size:    687 KB
  rows:    27,351

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-06 04:00:00	SPY	ETF	380.0	380.0	379.18	379.25	21669.0
2023-01-06 04:30:00	SPY	ETF	379.2	379.49	378.99	379.48	17001.0
2023-01-06 05:00:00	SPY	ETF	379.38	379.92	379.17	379.52	8116.0
2023-01-06 05:30:00	SPY	ETF	379.62	379.93	379.38	379.38	13771.0
2023-01-06 06:00:00	SPY	ETF	379.38	380.04	379.31	379.7	61883.0
2023-01-06 06:30:00	SPY	ETF	379.85	379.85	379.3	379.66	12074.0
2023-01-06 07:00:00	SPY	ETF	379.55	379.66	379.26	379.47	109053.0
2023-01-06 07:30:00	SPY	ETF	379.55	379.62	379.13	379.44	126204.0
2023-01-06 08:00:00	SPY	ETF	379.43	380.89	378.43	379.0	241507.0
2023-01-06 08:30:00	SPY	ETF	379.0	384.04	378.49	383.73	2971323.0
2023-01-06 09:00:00	SPY	ETF	383.77	383.89	382.2	382.6	801068.0
2023-01-06 09:30:00	SPY	ETF	382.61	383.96	379.45	380.737	7788146.0
2023-01-06 10:00:00	SPY	ETF	380.76	383.94	380.75	382.93	6968591.0
2023-01-06 10:30:00	SPY	ETF	382.93	385.57	382.895	385.27	6222029.0
2023-01-06 11:00:00	SPY	ETF	385.3	386.11	385.0801	385.34	4615792.0
2023-01-06 11:30:00	SPY	ETF	385.35	386.72	385.0	386.26	3976576.0
2023-01-06 12:00:00	SPY	ETF	386.26	386.51	385.38	385.5711	2795328.0
2023-01-06 12:30:00	SPY	ETF	385.59	385.8699	385.06	385.46	2159426.0
2023-01-06 13:00:00	SPY	ETF	385.45	386.2301	385.215	386.13	1921328.0
2023-01-06 13:30:00	SPY	ETF	386.1379	386.85	386.1035	386.72	2776871.0
2023-01-06 14:00:00	SPY	ETF	386.72	388.14	386.72	387.75	5366457.0
2023-01-06 14:30:00	SPY	ETF	387.75	388.79	387.715	388.52	3958887.0
2023-01-06 15:00:00	SPY	ETF	388.51	389.25	388.265	388.37	4967450.0
2023-01-06 15:30:00	SPY	ETF	388.375	389.07	387.73	388.03	14273923.0
2023-01-06 16:00:00	SPY	ETF	388.03	390.0	387.58	387.85	5900026.0
2023-01-06 16:30:00	SPY	ETF	387.81	388.08	387.76	387.78	224461.0
2023-01-06 17:00:00	SPY	ETF	387.79	388.0	387.75	387.81	127861.0
2023-01-06 17:30:00	SPY	ETF	387.85	387.89	387.6	387.83	90741.0
2023-01-06 18:00:00	SPY	ETF	387.83	387.88	387.81	387.86	47480.0
2023-01-06 18:30:00	SPY	ETF	387.81	387.85	387.75	387.78	25775.0
2023-01-06 19:00:00	SPY	ETF	387.79	387.83	386.38	387.7	62507.0
2023-01-06 19:30:00	SPY	ETF	387.62	387.68	387.51	387.58	13218.0
2023-01-06 04:00:00	QQQ	ETF	262.0	262.0	260.8	260.99	39532.0
2023-01-06 04:30:00	QQQ	ETF	260.87	261.23	260.7	261.17	14569.0
2023-01-06 05:00:00	QQQ	ETF	261.1	261.66	261.01	261.45	15334.0
2023-01-06 05:30:00	QQQ	ETF	261.42	261.68	260.96	260.96	14602.0
2023-01-06 06:00:00	QQQ	ETF	261.0	261.42	260.93	261.19	11871.0
2023-01-06 06:30:00	QQQ	ETF	261.22	261.23	260.77	261.03	13450.0
2023-01-06 07:00:00	QQQ	ETF	261.0	261.07	260.69	261.0	106271.0
2023-01-06 07:30:00	QQQ	ETF	261.07	261.3	260.81	261.01	92109.0
2023-01-06 08:00:00	QQQ	ETF	261.04	262.35	260.01	260.24	343909.0
2023-01-06 08:30:00	QQQ	ETF	260.2	265.22	260.17	264.61	2652092.0
2023-01-06 09:00:00	QQQ	ETF	264.62	264.75	262.84	263.29	805337.0
2023-01-06 09:30:00	QQQ	ETF	263.33	264.63	260.34	261.47	5893335.0
2023-01-06 10:00:00	QQQ	ETF	261.5	264.56	261.5	263.35	4434440.0
2023-01-06 10:30:00	QQQ	ETF	263.39	265.9	263.2512	265.62	3624677.0
2023-01-06 11:00:00	QQQ	ETF	265.65	266.48	265.23	265.62	2945128.0
2023-01-06 11:30:00	QQQ	ETF	265.64	267.0	265.25	266.51	2739111.0
2023-01-06 12:00:00	QQQ	ETF	266.52	266.89	266.14	266.44	1840819.0
2023-01-06 12:30:00	QQQ	ETF	266.45	266.6399	265.88	266.24	1082403.0

> showing 50 of 27,351 rows — these rows as CSV

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