PREVIEW / etf_30min / 2024-02-09

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-09.parquet
  size:    804 KB
  rows:    31,469

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
2024-02-09 04:00:00	SPY	ETF	498.96	498.97	498.67	498.77	4958.0
2024-02-09 04:30:00	SPY	ETF	498.7	498.88	498.7	498.84	7958.0
2024-02-09 05:00:00	SPY	ETF	498.83	499.12	498.83	499.12	4734.0
2024-02-09 05:30:00	SPY	ETF	499.12	499.22	499.03	499.03	11004.0
2024-02-09 06:00:00	SPY	ETF	499.0	499.15	498.91	499.15	3513.0
2024-02-09 06:30:00	SPY	ETF	499.19	499.28	499.09	499.25	16397.0
2024-02-09 07:00:00	SPY	ETF	499.2	499.48	499.2	499.38	28423.0
2024-02-09 07:30:00	SPY	ETF	499.38	499.54	499.35	499.35	47596.0
2024-02-09 08:00:00	SPY	ETF	499.19	499.5	498.28	499.32	83073.0
2024-02-09 08:30:00	SPY	ETF	499.3	501.08	499.14	499.9	659232.0
2024-02-09 09:00:00	SPY	ETF	499.889	499.92	498.7	498.84	330463.0
2024-02-09 09:30:00	SPY	ETF	498.86	499.57	498.49	499.5	4596220.0
2024-02-09 10:00:00	SPY	ETF	499.5	499.79	499.135	499.6488	3530090.0
2024-02-09 10:30:00	SPY	ETF	499.66	500.02	499.52	499.96	3473064.0
2024-02-09 11:00:00	SPY	ETF	499.97	500.21	499.61	499.75	2670516.0
2024-02-09 11:30:00	SPY	ETF	499.76	499.9	499.32	499.58	2439000.0
2024-02-09 12:00:00	SPY	ETF	499.58	500.16	499.38	500.13	2208982.0
2024-02-09 12:30:00	SPY	ETF	500.13	500.485	499.83	500.47	2779201.0
2024-02-09 13:00:00	SPY	ETF	500.465	500.83	500.3	500.735	2606367.0
2024-02-09 13:30:00	SPY	ETF	500.75	500.94	500.48	500.715	2000018.0
2024-02-09 14:00:00	SPY	ETF	500.7188	501.15	500.66	501.06	2511619.0
2024-02-09 14:30:00	SPY	ETF	501.07	501.65	501.07	501.285	3124700.0
2024-02-09 15:00:00	SPY	ETF	501.29	501.33	500.8	501.1	2981391.0
2024-02-09 15:30:00	SPY	ETF	501.1	501.34	500.69	501.18	8440424.0
2024-02-09 16:00:00	SPY	ETF	501.18	501.2748	499.5697	501.09	2814336.0
2024-02-09 16:30:00	SPY	ETF	501.08	501.1	500.92	500.96	233930.0
2024-02-09 17:00:00	SPY	ETF	501.03	501.12	500.95	501.0	43947.0
2024-02-09 17:30:00	SPY	ETF	501.03	501.03	500.97	501.0	12279.0
2024-02-09 18:00:00	SPY	ETF	500.99	501.03	500.95	500.95	40229.0
2024-02-09 18:30:00	SPY	ETF	500.95	500.9982	500.92	500.94	2883.0
2024-02-09 19:00:00	SPY	ETF	500.92	501.03	500.91	501.02	2215.0
2024-02-09 19:30:00	SPY	ETF	501.0	501.03	500.9	501.0	10842.0
2024-02-09 04:00:00	QQQ	ETF	432.8	434.18	432.8	433.65	15840.0
2024-02-09 04:30:00	QQQ	ETF	433.64	433.91	433.63	433.86	12549.0
2024-02-09 05:00:00	QQQ	ETF	433.84	434.19	433.83	434.1	10376.0
2024-02-09 05:30:00	QQQ	ETF	434.19	434.26	434.01	434.05	6677.0
2024-02-09 06:00:00	QQQ	ETF	434.09	434.09	433.76	433.99	10802.0
2024-02-09 06:30:00	QQQ	ETF	434.06	434.28	434.06	434.17	8890.0
2024-02-09 07:00:00	QQQ	ETF	434.19	434.69	434.17	434.55	41152.0
2024-02-09 07:30:00	QQQ	ETF	434.54	434.63	434.11	434.11	32633.0
2024-02-09 08:00:00	QQQ	ETF	434.33	434.68	432.97	434.02	100463.0
2024-02-09 08:30:00	QQQ	ETF	434.0	435.45	433.85	434.49	490221.0
2024-02-09 09:00:00	QQQ	ETF	434.45	434.51	433.81	433.95	161658.0
2024-02-09 09:30:00	QQQ	ETF	433.94	434.77	433.1401	434.71	3018065.0
2024-02-09 10:00:00	QQQ	ETF	434.725	435.43	434.28	435.42	2632893.0
2024-02-09 10:30:00	QQQ	ETF	435.43	436.06	435.24	435.97	2343462.0
2024-02-09 11:00:00	QQQ	ETF	435.99	436.32	435.5562	435.73	1996525.0
2024-02-09 11:30:00	QQQ	ETF	435.74	436.25	435.341	435.95	1408141.0
2024-02-09 12:00:00	QQQ	ETF	435.96	436.195	435.62	436.185	804879.0
2024-02-09 12:30:00	QQQ	ETF	436.2	436.785	435.95	436.72	1325924.0

> showing 50 of 31,469 rows — these rows as CSV

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