PREVIEW / etf_30min / 2022-07-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-07.parquet
  size:    649 KB
  rows:    25,851

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
2022-07-07 04:00:00	SPY	ETF	384.49	385.06	384.49	384.74	16694.0
2022-07-07 04:30:00	SPY	ETF	384.77	385.16	383.92	384.35	31995.0
2022-07-07 05:00:00	SPY	ETF	384.07	384.81	384.02	384.34	32974.0
2022-07-07 05:30:00	SPY	ETF	384.35	384.65	383.95	383.95	6390.0
2022-07-07 06:00:00	SPY	ETF	383.98	384.14	383.43	384.02	13079.0
2022-07-07 06:30:00	SPY	ETF	384.15	384.44	384.06	384.44	29174.0
2022-07-07 07:00:00	SPY	ETF	384.42	384.44	383.87	383.96	54281.0
2022-07-07 07:30:00	SPY	ETF	383.92	384.95	383.92	384.92	164748.0
2022-07-07 08:00:00	SPY	ETF	384.05	385.07	383.88	384.53	267730.0
2022-07-07 08:30:00	SPY	ETF	384.54	385.25	384.22	384.95	119283.0
2022-07-07 09:00:00	SPY	ETF	384.93	385.36	384.75	385.14	335860.0
2022-07-07 09:30:00	SPY	ETF	385.12	387.6	385.12	387.385	5928020.0
2022-07-07 10:00:00	SPY	ETF	387.39	387.4	386.06	386.8601	4046680.0
2022-07-07 10:30:00	SPY	ETF	386.87	387.83	386.56	387.38	3040858.0
2022-07-07 11:00:00	SPY	ETF	387.37	388.25	387.03	387.13	2763422.0
2022-07-07 11:30:00	SPY	ETF	387.1484	388.02	386.98	387.885	1834193.0
2022-07-07 12:00:00	SPY	ETF	387.885	388.11	387.65	388.0	1805191.0
2022-07-07 12:30:00	SPY	ETF	388.0	388.4	387.68	388.04	2579375.0
2022-07-07 13:00:00	SPY	ETF	388.05	388.22	387.4201	387.49	1789818.0
2022-07-07 13:30:00	SPY	ETF	387.49	388.49	387.34	388.42	1849660.0
2022-07-07 14:00:00	SPY	ETF	388.42	388.97	388.36	388.955	2510864.0
2022-07-07 14:30:00	SPY	ETF	388.96	388.96	388.33	388.8615	2297140.0
2022-07-07 15:00:00	SPY	ETF	388.88	389.83	388.78	389.04	3979273.0
2022-07-07 15:30:00	SPY	ETF	389.05	389.55	388.57	388.94	9198424.0
2022-07-07 16:00:00	SPY	ETF	388.94	388.99	388.3	388.42	3213872.0
2022-07-07 16:30:00	SPY	ETF	388.4	388.5299	388.3	388.38	88397.0
2022-07-07 17:00:00	SPY	ETF	388.31	388.5	388.07	388.5	177567.0
2022-07-07 17:30:00	SPY	ETF	388.45	388.6	388.15	388.15	62026.0
2022-07-07 18:00:00	SPY	ETF	388.15	388.52	388.15	388.45	101622.0
2022-07-07 18:30:00	SPY	ETF	388.47	388.49	388.16	388.49	29462.0
2022-07-07 19:00:00	SPY	ETF	388.45	388.49	388.03	388.24	20679.0
2022-07-07 19:30:00	SPY	ETF	388.17	388.38	387.7	388.16	49673.0
2022-07-07 04:00:00	QQQ	ETF	289.85	290.35	289.84	290.18	53098.0
2022-07-07 04:30:00	QQQ	ETF	290.35	290.73	289.54	290.42	41557.0
2022-07-07 05:00:00	QQQ	ETF	289.8	290.32	289.69	289.86	21356.0
2022-07-07 05:30:00	QQQ	ETF	289.8	290.01	289.45	289.5	11502.0
2022-07-07 06:00:00	QQQ	ETF	289.52	289.58	288.98	289.47	18803.0
2022-07-07 06:30:00	QQQ	ETF	289.51	289.93	289.4	289.93	20713.0
2022-07-07 07:00:00	QQQ	ETF	289.94	289.94	289.46	289.57	57591.0
2022-07-07 07:30:00	QQQ	ETF	289.56	290.34	289.53	290.27	125419.0
2022-07-07 08:00:00	QQQ	ETF	289.88	290.36	289.016	289.9	303215.0
2022-07-07 08:30:00	QQQ	ETF	289.84	290.22	289.43	289.94	248687.0
2022-07-07 09:00:00	QQQ	ETF	289.8901	290.12	289.52	289.66	341803.0
2022-07-07 09:30:00	QQQ	ETF	289.67	292.81	289.63	292.44	5375183.0
2022-07-07 10:00:00	QQQ	ETF	292.45	292.86	291.37	292.4789	3422396.0
2022-07-07 10:30:00	QQQ	ETF	292.48	293.27	291.93	292.83	2513164.0
2022-07-07 11:00:00	QQQ	ETF	292.84	293.39	292.31	292.5	1899353.0
2022-07-07 11:30:00	QQQ	ETF	292.51	293.77	292.28	293.77	2497221.0
2022-07-07 12:00:00	QQQ	ETF	293.78	293.945	293.43	293.83	1530706.0
2022-07-07 12:30:00	QQQ	ETF	293.84	294.24	293.75	294.0943	1795716.0

> showing 50 of 25,851 rows — these rows as CSV

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