PREVIEW / etf_30min / 2001-03-16

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-16.parquet
  size:    14 KB
  rows:    350

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
2001-03-16 09:30:00	SPY	ETF	117.13	117.4	116.18	116.7	2151900.0
2001-03-16 10:00:00	SPY	ETF	116.82	117.2	115.25	115.66	1262300.0
2001-03-16 10:30:00	SPY	ETF	115.62	116.0	115.06	115.56	1026800.0
2001-03-16 11:00:00	SPY	ETF	115.56	116.05	115.54	115.92	1324100.0
2001-03-16 11:30:00	SPY	ETF	115.92	116.89	115.72	116.5	1309300.0
2001-03-16 12:00:00	SPY	ETF	116.55	117.0	116.32	116.62	1248000.0
2001-03-16 12:30:00	SPY	ETF	116.61	116.86	116.25	116.38	421200.0
2001-03-16 13:00:00	SPY	ETF	116.38	116.4	115.64	115.99	481100.0
2001-03-16 13:30:00	SPY	ETF	115.89	116.35	115.68	116.32	619400.0
2001-03-16 14:00:00	SPY	ETF	116.36	116.44	115.8	116.0	495700.0
2001-03-16 14:30:00	SPY	ETF	116.04	116.07	115.2	115.34	849200.0
2001-03-16 15:00:00	SPY	ETF	115.25	115.75	115.02	115.04	1119600.0
2001-03-16 15:30:00	SPY	ETF	115.03	115.7	114.81	115.31	1598800.0
2001-03-16 16:00:00	SPY	ETF	115.31	115.9	115.0	115.01	810800.0
2001-03-16 16:30:00	SPY	ETF	115.0	115.35	115.0	115.24	115900.0
2001-03-16 17:00:00	SPY	ETF	115.24	115.24	115.24	115.24	21650000.0
2001-03-16 18:00:00	SPY	ETF	115.5	115.5	115.5	115.5	300.0
2001-03-16 09:30:00	QQQ	ETF	41.88	42.8	41.37	41.55	12887500.0
2001-03-16 10:00:00	QQQ	ETF	41.48	41.84	40.71	40.99	9416400.0
2001-03-16 10:30:00	QQQ	ETF	40.93	41.22	40.56	40.9	5206500.0
2001-03-16 11:00:00	QQQ	ETF	40.92	41.5	40.82	41.45	3845700.0
2001-03-16 11:30:00	QQQ	ETF	41.49	42.3	41.35	41.9	9195600.0
2001-03-16 12:00:00	QQQ	ETF	41.93	42.15	41.57	41.74	4351300.0
2001-03-16 12:30:00	QQQ	ETF	41.7	42.0	41.43	41.44	2700600.0
2001-03-16 13:00:00	QQQ	ETF	41.48	41.59	41.04	41.13	5043900.0
2001-03-16 13:30:00	QQQ	ETF	41.15	41.55	41.0	41.55	2769000.0
2001-03-16 14:00:00	QQQ	ETF	41.53	41.65	41.13	41.26	2218700.0
2001-03-16 14:30:00	QQQ	ETF	41.27	41.31	40.71	40.81	3424500.0
2001-03-16 15:00:00	QQQ	ETF	40.76	41.2	40.7	40.82	3871900.0
2001-03-16 15:30:00	QQQ	ETF	40.82	41.45	40.73	41.1	5668800.0
2001-03-16 16:00:00	QQQ	ETF	41.01	43.5	41.0	41.22	2003100.0
2001-03-16 16:30:00	QQQ	ETF	41.2	41.4	41.09	41.2	199300.0
2001-03-16 17:00:00	QQQ	ETF	41.2	41.23	41.12	41.15	12900.0
2001-03-16 17:30:00	QQQ	ETF	41.2	41.23	41.15	41.2	9000.0
2001-03-16 18:00:00	QQQ	ETF	41.2	41.39	41.19	41.23	24200.0
2001-03-16 09:30:00	IWM	ETF	44.925	45.175	44.8	44.9	50200.0
2001-03-16 10:00:00	IWM	ETF	45.0	45.0	44.225	44.225	19000.0
2001-03-16 10:30:00	IWM	ETF	44.425	44.425	44.2	44.2	6200.0
2001-03-16 11:00:00	IWM	ETF	44.3	44.325	44.125	44.275	24800.0
2001-03-16 11:30:00	IWM	ETF	44.4	44.6	44.3	44.3	4400.0
2001-03-16 12:00:00	IWM	ETF	44.975	45.0	44.25	44.5	4600.0
2001-03-16 12:30:00	IWM	ETF	44.4	44.55	44.35	44.55	16400.0
2001-03-16 13:00:00	IWM	ETF	44.545	44.545	44.4	44.475	1000.0
2001-03-16 13:30:00	IWM	ETF	44.135	44.135	44.13	44.135	3000.0
2001-03-16 14:00:00	IWM	ETF	44.25	44.425	44.25	44.425	47400.0
2001-03-16 14:30:00	IWM	ETF	44.35	44.35	44.125	44.125	1600.0
2001-03-16 15:00:00	IWM	ETF	44.15	44.15	44.0	44.0	22000.0
2001-03-16 15:30:00	IWM	ETF	43.9	44.14	43.825	44.0	26800.0
2001-03-16 09:30:00	DIA	ETF	99.65	100.61	99.26	99.69	517600.0
2001-03-16 10:00:00	DIA	ETF	99.63	100.06	98.6	98.85	516800.0

> showing 50 of 350 rows — these rows as CSV

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