PREVIEW / etf_30min / 2022-10-31

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-31.parquet
  size:    670 KB
  rows:    27,131

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-10-31 04:00:00	SPY	ETF	388.8	389.45	387.06	387.06	172048.0
2022-10-31 04:30:00	SPY	ETF	387.0	387.0	386.42	386.9	29956.0
2022-10-31 05:00:00	SPY	ETF	386.83	386.95	386.53	386.92	17985.0
2022-10-31 05:30:00	SPY	ETF	387.0	387.5	387.0	387.1	14495.0
2022-10-31 06:00:00	SPY	ETF	387.01	387.43	386.8	387.1	47056.0
2022-10-31 06:30:00	SPY	ETF	387.1	387.37	386.84	387.33	24204.0
2022-10-31 07:00:00	SPY	ETF	387.35	388.23	387.34	388.23	172817.0
2022-10-31 07:30:00	SPY	ETF	388.15	388.15	387.38	387.57	126330.0
2022-10-31 08:00:00	SPY	ETF	387.84	388.78	386.53	387.01	330572.0
2022-10-31 08:30:00	SPY	ETF	387.0	387.05	386.56	386.97	224011.0
2022-10-31 09:00:00	SPY	ETF	386.94	387.37	386.32	386.43	403665.0
2022-10-31 09:30:00	SPY	ETF	386.44	387.47	385.47	385.4749	6788080.0
2022-10-31 10:00:00	SPY	ETF	385.48	386.915	385.26	385.8257	4613363.0
2022-10-31 10:30:00	SPY	ETF	385.8	386.75	385.37	386.12	3542891.0
2022-10-31 11:00:00	SPY	ETF	386.12	387.61	386.04	387.345	3814914.0
2022-10-31 11:30:00	SPY	ETF	387.345	388.4	386.32	387.08	4104920.0
2022-10-31 12:00:00	SPY	ETF	387.09	388.0	386.425	386.96	3115303.0
2022-10-31 12:30:00	SPY	ETF	386.95	386.97	385.78	386.25	2902566.0
2022-10-31 13:00:00	SPY	ETF	386.25	387.44	385.811	387.3399	2856569.0
2022-10-31 13:30:00	SPY	ETF	387.3399	387.5895	386.53	387.07	2161171.0
2022-10-31 14:00:00	SPY	ETF	387.07	387.4079	386.6249	386.9575	2818028.0
2022-10-31 14:30:00	SPY	ETF	386.96	387.72	386.52	386.845	3682405.0
2022-10-31 15:00:00	SPY	ETF	386.87	386.9	385.52	386.6649	5780185.0
2022-10-31 15:30:00	SPY	ETF	386.66	387.45	386.0	386.21	13530870.0
2022-10-31 16:00:00	SPY	ETF	386.22	386.5	385.91	386.26	6115804.0
2022-10-31 16:30:00	SPY	ETF	386.37	386.63	386.17	386.23	259061.0
2022-10-31 17:00:00	SPY	ETF	386.37	386.37	385.98	386.07	96832.0
2022-10-31 17:30:00	SPY	ETF	386.06	386.35	386.06	386.26	50552.0
2022-10-31 18:00:00	SPY	ETF	386.26	386.6	386.11	386.55	91797.0
2022-10-31 18:30:00	SPY	ETF	386.57	386.7	386.4504	386.46	14102.0
2022-10-31 19:00:00	SPY	ETF	386.56	387.0	386.56	386.92	36556.0
2022-10-31 19:30:00	SPY	ETF	386.9	387.0	386.4	386.79	36572.0
2022-10-31 04:00:00	QQQ	ETF	280.94	280.94	279.3	279.3	68095.0
2022-10-31 04:30:00	QQQ	ETF	279.3	279.3	278.83	279.22	64005.0
2022-10-31 05:00:00	QQQ	ETF	279.14	279.42	278.95	279.27	19159.0
2022-10-31 05:30:00	QQQ	ETF	279.46	279.65	279.27	279.32	34880.0
2022-10-31 06:00:00	QQQ	ETF	279.3	279.59	279.08	279.49	30139.0
2022-10-31 06:30:00	QQQ	ETF	279.37	279.55	279.08	279.51	40040.0
2022-10-31 07:00:00	QQQ	ETF	279.55	280.32	279.55	280.28	132153.0
2022-10-31 07:30:00	QQQ	ETF	280.26	280.32	279.65	279.83	142776.0
2022-10-31 08:00:00	QQQ	ETF	279.94	280.89	279.02	279.44	272903.0
2022-10-31 08:30:00	QQQ	ETF	279.43	279.48	278.98	279.3196	260815.0
2022-10-31 09:00:00	QQQ	ETF	279.33	279.61	278.87	278.92	378477.0
2022-10-31 09:30:00	QQQ	ETF	278.92	279.76	277.13	277.385	6419681.0
2022-10-31 10:00:00	QQQ	ETF	277.37	278.09	276.53	276.68	3798810.0
2022-10-31 10:30:00	QQQ	ETF	276.675	277.67	275.99	277.1	3430772.0
2022-10-31 11:00:00	QQQ	ETF	277.09	278.5099	276.97	278.2257	2607999.0
2022-10-31 11:30:00	QQQ	ETF	278.23	279.24	277.64	278.24	2469534.0
2022-10-31 12:00:00	QQQ	ETF	278.27	279.535	277.87	278.63	1825668.0
2022-10-31 12:30:00	QQQ	ETF	278.63	278.64	277.4	277.9	1329016.0

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

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