PREVIEW / etf_30min / 2022-11-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-08.parquet
  size:    684 KB
  rows:    27,653

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-11-08 04:00:00	SPY	ETF	379.39	380.17	379.03	380.17	24108.0
2022-11-08 04:30:00	SPY	ETF	380.1	380.68	380.1	380.64	26089.0
2022-11-08 05:00:00	SPY	ETF	380.64	381.08	380.35	380.45	11314.0
2022-11-08 05:30:00	SPY	ETF	380.45	380.51	380.07	380.07	4583.0
2022-11-08 06:00:00	SPY	ETF	380.24	380.81	380.17	380.61	10704.0
2022-11-08 06:30:00	SPY	ETF	380.7	381.54	380.7	381.54	54936.0
2022-11-08 07:00:00	SPY	ETF	381.43	381.46	380.5	380.6	102071.0
2022-11-08 07:30:00	SPY	ETF	380.55	380.96	380.29	380.88	85079.0
2022-11-08 08:00:00	SPY	ETF	381.21	381.49	378.86	380.67	190474.0
2022-11-08 08:30:00	SPY	ETF	380.72	381.41	379.6	381.14	193597.0
2022-11-08 09:00:00	SPY	ETF	381.1101	381.81	381.02	381.07	194828.0
2022-11-08 09:30:00	SPY	ETF	381.11	381.23	379.53	380.39	5126693.0
2022-11-08 10:00:00	SPY	ETF	380.38	382.2881	380.32	381.9631	4872860.0
2022-11-08 10:30:00	SPY	ETF	381.96	383.32	381.8899	383.06	4099900.0
2022-11-08 11:00:00	SPY	ETF	383.11	384.14	382.51	384.0	3991021.0
2022-11-08 11:30:00	SPY	ETF	384.01	385.12	384.01	384.54	3979579.0
2022-11-08 12:00:00	SPY	ETF	384.54	384.76	383.93	384.33	2497135.0
2022-11-08 12:30:00	SPY	ETF	384.32	384.775	383.955	384.47	2068959.0
2022-11-08 13:00:00	SPY	ETF	384.48	385.0	381.57	381.74	3809181.0
2022-11-08 13:30:00	SPY	ETF	381.73	382.54	380.46	380.75	5239263.0
2022-11-08 14:00:00	SPY	ETF	380.74	381.3067	378.08	378.13	5032804.0
2022-11-08 14:30:00	SPY	ETF	378.13	381.34	377.72	380.6	5987568.0
2022-11-08 15:00:00	SPY	ETF	380.61	382.9394	380.52	382.9	4552971.0
2022-11-08 15:30:00	SPY	ETF	382.9	384.05	381.76	381.97	10374518.0
2022-11-08 16:00:00	SPY	ETF	381.98	382.548	380.98	381.53	5521850.0
2022-11-08 16:30:00	SPY	ETF	381.56	382.0	381.53	381.71	904760.0
2022-11-08 17:00:00	SPY	ETF	381.73	381.85	381.58	381.82	66809.0
2022-11-08 17:30:00	SPY	ETF	381.75	381.83	381.63	381.7	47944.0
2022-11-08 18:00:00	SPY	ETF	381.7	382.5	381.48	382.39	99067.0
2022-11-08 18:30:00	SPY	ETF	382.44	382.81	382.26	382.7	37688.0
2022-11-08 19:00:00	SPY	ETF	382.54	382.54	381.7	381.88	59002.0
2022-11-08 19:30:00	SPY	ETF	381.96	382.27	381.55	381.8	46441.0
2022-11-08 04:00:00	QQQ	ETF	267.49	268.11	267.09	268.11	20428.0
2022-11-08 04:30:00	QQQ	ETF	268.18	268.62	268.18	268.55	20465.0
2022-11-08 05:00:00	QQQ	ETF	268.59	269.03	268.51	268.51	23048.0
2022-11-08 05:30:00	QQQ	ETF	268.56	268.59	268.1	268.22	7969.0
2022-11-08 06:00:00	QQQ	ETF	268.15	268.83	268.15	268.7	12521.0
2022-11-08 06:30:00	QQQ	ETF	268.7	269.49	268.7	269.39	45585.0
2022-11-08 07:00:00	QQQ	ETF	269.29	269.35	268.55	268.89	122092.0
2022-11-08 07:30:00	QQQ	ETF	268.83	269.09	268.6	269.02	123490.0
2022-11-08 08:00:00	QQQ	ETF	269.08	269.3499	266.8	268.672	223676.0
2022-11-08 08:30:00	QQQ	ETF	268.76	269.49	268.76	269.23	182887.0
2022-11-08 09:00:00	QQQ	ETF	269.23	269.77	269.07	269.09	288857.0
2022-11-08 09:30:00	QQQ	ETF	269.1	269.33	267.4183	268.68	5221184.0
2022-11-08 10:00:00	QQQ	ETF	268.7	269.94	268.24	269.48	4010101.0
2022-11-08 10:30:00	QQQ	ETF	269.52	270.59	269.385	270.365	3017930.0
2022-11-08 11:00:00	QQQ	ETF	270.37	271.86	269.942	271.8	2624163.0
2022-11-08 11:30:00	QQQ	ETF	271.8	272.85	271.61	272.06	2867998.0
2022-11-08 12:00:00	QQQ	ETF	272.07	272.49	271.54	272.0299	2091630.0
2022-11-08 12:30:00	QQQ	ETF	272.02	272.35	271.66	272.11	1671820.0

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

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