PREVIEW / etf_30min / 2023-03-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-15.parquet
  size:    727 KB
  rows:    29,885

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-03-15 04:00:00	SPY	ETF	391.63	392.38	391.39	391.71	40948.0
2023-03-15 04:30:00	SPY	ETF	391.65	391.99	391.18	391.18	24367.0
2023-03-15 05:00:00	SPY	ETF	391.23	391.31	389.84	389.96	49075.0
2023-03-15 05:30:00	SPY	ETF	390.0	390.2	388.65	388.67	79712.0
2023-03-15 06:00:00	SPY	ETF	388.63	388.99	386.46	386.46	89913.0
2023-03-15 06:30:00	SPY	ETF	386.6	387.1	383.77	384.75	432687.0
2023-03-15 07:00:00	SPY	ETF	384.69	386.13	384.69	385.81	750521.0
2023-03-15 07:30:00	SPY	ETF	385.73	385.86	384.89	385.26	423670.0
2023-03-15 08:00:00	SPY	ETF	385.931	392.59	383.77	385.05	968727.0
2023-03-15 08:30:00	SPY	ETF	385.24	386.73	383.31	384.52	1581082.0
2023-03-15 09:00:00	SPY	ETF	384.5	385.97	384.07	385.9	1204803.0
2023-03-15 09:30:00	SPY	ETF	385.87	387.72	385.17	385.57	13254703.0
2023-03-15 10:00:00	SPY	ETF	385.6	387.44	385.05	385.67	9960717.0
2023-03-15 10:30:00	SPY	ETF	385.66	386.51	384.3106	386.165	8575334.0
2023-03-15 11:00:00	SPY	ETF	386.18	387.36	385.655	386.25	6141110.0
2023-03-15 11:30:00	SPY	ETF	386.26	387.37	385.55	385.72	5941681.0
2023-03-15 12:00:00	SPY	ETF	385.7	386.25	384.24	384.9	6887483.0
2023-03-15 12:30:00	SPY	ETF	384.895	385.58	383.71	384.14	6788109.0
2023-03-15 13:00:00	SPY	ETF	384.14	386.52	383.82	386.37	7204698.0
2023-03-15 13:30:00	SPY	ETF	386.37	386.97	385.09	386.49	5326986.0
2023-03-15 14:00:00	SPY	ETF	386.51	389.49	385.44	388.42	9652438.0
2023-03-15 14:30:00	SPY	ETF	388.44	389.22	387.31	388.66	9795985.0
2023-03-15 15:00:00	SPY	ETF	388.66	389.38	387.25	388.74	9940110.0
2023-03-15 15:30:00	SPY	ETF	388.73	389.36	386.77	389.35	17637801.0
2023-03-15 16:00:00	SPY	ETF	389.35	389.63	388.71	388.98	4659416.0
2023-03-15 16:30:00	SPY	ETF	388.95	389.29	388.84	389.1	208955.0
2023-03-15 17:00:00	SPY	ETF	389.01	389.28	389.01	389.1	60769.0
2023-03-15 17:30:00	SPY	ETF	389.14	389.14	388.66	388.88	91303.0
2023-03-15 18:00:00	SPY	ETF	388.94	389.38	388.71	389.3	440967.0
2023-03-15 18:30:00	SPY	ETF	389.24	389.56	389.24	389.39	57365.0
2023-03-15 19:00:00	SPY	ETF	389.48	389.62	389.4	389.41	40851.0
2023-03-15 19:30:00	SPY	ETF	389.39	389.66	388.58	388.78	89395.0
2023-03-15 04:00:00	QQQ	ETF	297.68	298.24	297.4	297.74	28736.0
2023-03-15 04:30:00	QQQ	ETF	297.69	298.06	297.37	297.39	18074.0
2023-03-15 05:00:00	QQQ	ETF	297.46	297.46	296.23	296.29	31267.0
2023-03-15 05:30:00	QQQ	ETF	296.28	296.53	295.37	295.49	46288.0
2023-03-15 06:00:00	QQQ	ETF	295.48	295.76	294.31	294.32	89096.0
2023-03-15 06:30:00	QQQ	ETF	294.36	294.85	292.05	292.99	242656.0
2023-03-15 07:00:00	QQQ	ETF	292.84	294.0	292.82	293.74	384944.0
2023-03-15 07:30:00	QQQ	ETF	293.73	293.9	293.15	293.44	291826.0
2023-03-15 08:00:00	QQQ	ETF	293.35	298.0	292.0896	293.53	628413.0
2023-03-15 08:30:00	QQQ	ETF	293.55	294.84	292.21	293.27	946980.0
2023-03-15 09:00:00	QQQ	ETF	293.34	295.0	292.77	294.75	813576.0
2023-03-15 09:30:00	QQQ	ETF	294.71	296.17	294.27	294.65	7543928.0
2023-03-15 10:00:00	QQQ	ETF	294.61	296.05	294.0	294.42	5129279.0
2023-03-15 10:30:00	QQQ	ETF	294.4	295.31	293.24	295.14	4420424.0
2023-03-15 11:00:00	QQQ	ETF	295.16	295.93	294.67	295.33	3349687.0
2023-03-15 11:30:00	QQQ	ETF	295.33	297.04	295.17	295.79	3142681.0
2023-03-15 12:00:00	QQQ	ETF	295.78	296.165	294.41	294.92	2800303.0
2023-03-15 12:30:00	QQQ	ETF	294.9	295.52	293.96	294.34	2758569.0

> showing 50 of 29,885 rows — these rows as CSV

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