PREVIEW / etf_30min / 2023-04-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-05.parquet
  size:    680 KB
  rows:    27,402

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-04-05 04:00:00	SPY	ETF	408.43	408.67	407.94	407.94	20404.0
2023-04-05 04:30:00	SPY	ETF	407.96	408.11	407.76	407.95	36007.0
2023-04-05 05:00:00	SPY	ETF	407.94	408.34	407.86	407.86	50052.0
2023-04-05 05:30:00	SPY	ETF	407.8	408.05	407.78	407.86	5720.0
2023-04-05 06:00:00	SPY	ETF	407.86	408.04	407.74	407.99	4458.0
2023-04-05 06:30:00	SPY	ETF	408.06	408.36	407.89	408.35	8579.0
2023-04-05 07:00:00	SPY	ETF	408.32	408.48	408.2	408.46	61119.0
2023-04-05 07:30:00	SPY	ETF	408.5	408.66	408.27	408.28	65423.0
2023-04-05 08:00:00	SPY	ETF	408.43	409.04	407.8204	408.25	194976.0
2023-04-05 08:30:00	SPY	ETF	408.21	408.31	407.64	407.94	266335.0
2023-04-05 09:00:00	SPY	ETF	407.89	408.12	407.77	407.89	200359.0
2023-04-05 09:30:00	SPY	ETF	407.89	408.62	407.77	408.35	5216493.0
2023-04-05 10:00:00	SPY	ETF	408.37	408.7	407.205	407.2799	5775096.0
2023-04-05 10:30:00	SPY	ETF	407.24	407.8	406.23	406.35	4310218.0
2023-04-05 11:00:00	SPY	ETF	406.35	407.03	406.15	406.568	3540982.0
2023-04-05 11:30:00	SPY	ETF	406.57	407.405	406.48	407.06	3102987.0
2023-04-05 12:00:00	SPY	ETF	407.05	407.125	405.93	406.17	2950509.0
2023-04-05 12:30:00	SPY	ETF	406.17	406.535	405.88	406.1552	2371081.0
2023-04-05 13:00:00	SPY	ETF	406.165	407.09	405.98	406.875	2820455.0
2023-04-05 13:30:00	SPY	ETF	406.87	407.23	406.55	407.16	2870844.0
2023-04-05 14:00:00	SPY	ETF	407.17	407.6821	407.05	407.09	2786707.0
2023-04-05 14:30:00	SPY	ETF	407.085	407.77	407.05	407.5	2498624.0
2023-04-05 15:00:00	SPY	ETF	407.51	407.51	406.84	407.21	2775083.0
2023-04-05 15:30:00	SPY	ETF	407.22	407.86	407.19	407.65	7235794.0
2023-04-05 16:00:00	SPY	ETF	407.65	407.74	407.57	407.6	2084649.0
2023-04-05 16:30:00	SPY	ETF	407.62	407.64	407.42	407.43	154479.0
2023-04-05 17:00:00	SPY	ETF	407.55	407.55	407.34	407.3501	9319.0
2023-04-05 17:30:00	SPY	ETF	407.37	407.37	407.17	407.25	33941.0
2023-04-05 18:00:00	SPY	ETF	407.25	407.35	407.06	407.31	103048.0
2023-04-05 18:30:00	SPY	ETF	407.23	407.41	407.22	407.37	9492.0
2023-04-05 19:00:00	SPY	ETF	407.32	407.4	407.32	407.37	14843.0
2023-04-05 19:30:00	SPY	ETF	407.37	407.37	407.21	407.28	23172.0
2023-04-05 04:00:00	QQQ	ETF	318.78	318.79	318.5	318.56	25642.0
2023-04-05 04:30:00	QQQ	ETF	318.51	318.61	318.22	318.43	7370.0
2023-04-05 05:00:00	QQQ	ETF	318.39	318.74	318.39	318.51	6999.0
2023-04-05 05:30:00	QQQ	ETF	318.55	318.55	318.43	318.43	2591.0
2023-04-05 06:00:00	QQQ	ETF	318.53	318.63	318.43	318.58	5719.0
2023-04-05 06:30:00	QQQ	ETF	318.68	318.84	318.48	318.82	10368.0
2023-04-05 07:00:00	QQQ	ETF	318.84	319.03	318.74	318.96	74585.0
2023-04-05 07:30:00	QQQ	ETF	319.01	319.25	318.92	319.01	148635.0
2023-04-05 08:00:00	QQQ	ETF	319.0704	319.61	318.3204	319.09	281708.0
2023-04-05 08:30:00	QQQ	ETF	319.09	319.2	318.55	318.74	122292.0
2023-04-05 09:00:00	QQQ	ETF	318.75	318.95	318.15	318.16	148009.0
2023-04-05 09:30:00	QQQ	ETF	318.1	318.31	316.795	317.2401	6173034.0
2023-04-05 10:00:00	QQQ	ETF	317.27	317.89	316.04	316.08	5442416.0
2023-04-05 10:30:00	QQQ	ETF	316.07	316.43	314.6	314.62	5971315.0
2023-04-05 11:00:00	QQQ	ETF	314.6294	315.14	314.42	314.84	3480138.0
2023-04-05 11:30:00	QQQ	ETF	314.85	315.48	314.71	315.12	2842065.0
2023-04-05 12:00:00	QQQ	ETF	315.12	315.18	314.12	314.2891	2726291.0
2023-04-05 12:30:00	QQQ	ETF	314.29	314.68	314.07	314.44	2077801.0

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

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