PREVIEW / etf_30min / 2024-02-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-08.parquet
  size:    803 KB
  rows:    31,453

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-08 04:00:00	SPY	ETF	497.98	498.07	497.88	497.88	8674.0
2024-02-08 04:30:00	SPY	ETF	497.95	498.05	497.93	498.02	5910.0
2024-02-08 05:00:00	SPY	ETF	497.96	498.0	497.93	497.98	6588.0
2024-02-08 05:30:00	SPY	ETF	497.97	497.97	497.69	497.76	7079.0
2024-02-08 06:00:00	SPY	ETF	497.77	497.79	497.2	497.2	11614.0
2024-02-08 06:30:00	SPY	ETF	497.23	497.55	497.2	497.44	18855.0
2024-02-08 07:00:00	SPY	ETF	497.51	497.68	497.39	497.65	46739.0
2024-02-08 07:30:00	SPY	ETF	497.64	497.66	497.37	497.44	87622.0
2024-02-08 08:00:00	SPY	ETF	497.5097	498.34	497.2426	497.4	105399.0
2024-02-08 08:30:00	SPY	ETF	497.4	498.02	497.23	497.85	180590.0
2024-02-08 09:00:00	SPY	ETF	497.85	498.12	497.69	498.12	285205.0
2024-02-08 09:30:00	SPY	ETF	498.1	498.35	497.66	497.9975	3158263.0
2024-02-08 10:00:00	SPY	ETF	498.0	498.23	497.63	497.85	2200316.0
2024-02-08 10:30:00	SPY	ETF	497.835	498.2	497.33	498.17	3110545.0
2024-02-08 11:00:00	SPY	ETF	498.1621	498.21	497.31	497.35	2483813.0
2024-02-08 11:30:00	SPY	ETF	497.35	497.89	497.26	497.82	1921788.0
2024-02-08 12:00:00	SPY	ETF	497.81	498.14	497.52	498.035	1482877.0
2024-02-08 12:30:00	SPY	ETF	498.035	498.11	497.42	497.58	1882136.0
2024-02-08 13:00:00	SPY	ETF	497.59	498.28	497.53	498.045	2601176.0
2024-02-08 13:30:00	SPY	ETF	498.04	498.34	497.91	498.13	2127915.0
2024-02-08 14:00:00	SPY	ETF	498.14	498.29	497.78	497.8311	2017889.0
2024-02-08 14:30:00	SPY	ETF	497.83	498.34	497.5801	498.25	2330548.0
2024-02-08 15:00:00	SPY	ETF	498.24	498.585	498.2	498.415	2793486.0
2024-02-08 15:30:00	SPY	ETF	498.42	498.71	497.86	498.4	8175453.0
2024-02-08 16:00:00	SPY	ETF	498.42	498.42	497.6882	498.3201	3987497.0
2024-02-08 16:30:00	SPY	ETF	498.31	498.39	498.22	498.22	118068.0
2024-02-08 17:00:00	SPY	ETF	498.21	498.39	498.21	498.21	110744.0
2024-02-08 17:30:00	SPY	ETF	498.22	498.33	498.22	498.25	13284.0
2024-02-08 18:00:00	SPY	ETF	498.25	498.25	498.12	498.2204	70861.0
2024-02-08 18:30:00	SPY	ETF	498.25	498.32	498.23	498.29	8168.0
2024-02-08 19:00:00	SPY	ETF	498.32	498.45	498.28	498.31	6547.0
2024-02-08 19:30:00	SPY	ETF	498.36	498.43	498.06	498.06	56072.0
2024-02-08 04:00:00	QQQ	ETF	432.14	432.55	432.14	432.39	34795.0
2024-02-08 04:30:00	QQQ	ETF	432.41	432.52	432.38	432.4	19042.0
2024-02-08 05:00:00	QQQ	ETF	432.48	432.48	432.25	432.3	20142.0
2024-02-08 05:30:00	QQQ	ETF	432.3	432.3	432.03	432.19	30155.0
2024-02-08 06:00:00	QQQ	ETF	432.19	432.19	431.34	431.34	13081.0
2024-02-08 06:30:00	QQQ	ETF	431.42	431.65	431.31	431.5	18176.0
2024-02-08 07:00:00	QQQ	ETF	431.54	431.78	431.4	431.65	30250.0
2024-02-08 07:30:00	QQQ	ETF	431.66	431.77	431.37	431.42	48100.0
2024-02-08 08:00:00	QQQ	ETF	431.61	432.63	431.11	431.38	115789.0
2024-02-08 08:30:00	QQQ	ETF	431.29	431.91	431.1	431.84	72284.0
2024-02-08 09:00:00	QQQ	ETF	431.78	432.09	431.69	432.09	98681.0
2024-02-08 09:30:00	QQQ	ETF	432.11	432.5	431.42	432.475	2856870.0
2024-02-08 10:00:00	QQQ	ETF	432.49	432.81	432.06	432.2001	1609541.0
2024-02-08 10:30:00	QQQ	ETF	432.2	433.46	431.84	433.39	1795307.0
2024-02-08 11:00:00	QQQ	ETF	433.39	433.5	432.74	432.77	1172088.0
2024-02-08 11:30:00	QQQ	ETF	432.75	433.39	432.66	433.32	1236298.0
2024-02-08 12:00:00	QQQ	ETF	433.31	433.56	432.76	433.39	1130833.0
2024-02-08 12:30:00	QQQ	ETF	433.39	433.4563	432.43	432.6	1072963.0

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

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