PREVIEW / etf_30min / 2006-01-10

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-10.parquet
  size:    58 KB
  rows:    2,136

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
2006-01-10 07:00:00	SPY	ETF	128.43	128.47	128.42	128.42	57700.0
2006-01-10 07:30:00	SPY	ETF	128.44	128.44	128.4	128.41	6100.0
2006-01-10 08:00:00	SPY	ETF	128.4	128.44	128.34	128.35	135900.0
2006-01-10 08:30:00	SPY	ETF	128.38	128.42	128.3	128.34	713600.0
2006-01-10 09:00:00	SPY	ETF	128.35	128.41	128.24	128.4	677200.0
2006-01-10 09:30:00	SPY	ETF	128.39	128.54	128.26	128.4	6261000.0
2006-01-10 10:00:00	SPY	ETF	128.3901	128.6	128.38	128.49	3777100.0
2006-01-10 10:30:00	SPY	ETF	128.51	128.66	128.44	128.51	2589600.0
2006-01-10 11:00:00	SPY	ETF	128.48	128.51	128.31	128.43	2290600.0
2006-01-10 11:30:00	SPY	ETF	128.42	128.67	128.4	128.56	2832500.0
2006-01-10 12:00:00	SPY	ETF	128.55	128.75	128.54	128.65	2481600.0
2006-01-10 12:30:00	SPY	ETF	128.65	128.72	128.54	128.64	1238500.0
2006-01-10 13:00:00	SPY	ETF	128.64	128.95	128.63	128.9	4546100.0
2006-01-10 13:30:00	SPY	ETF	128.9	128.97	128.66	128.69	1856300.0
2006-01-10 14:00:00	SPY	ETF	128.69	128.79	128.52	128.55	2512300.0
2006-01-10 14:30:00	SPY	ETF	128.54	128.65	128.43	128.55	2349700.0
2006-01-10 15:00:00	SPY	ETF	128.55	128.74	128.48	128.69	1704300.0
2006-01-10 15:30:00	SPY	ETF	128.71	128.92	128.69	128.88	4802200.0
2006-01-10 16:00:00	SPY	ETF	128.9	128.95	128.85	128.88	517800.0
2006-01-10 16:30:00	SPY	ETF	128.88	128.91	128.84	128.9	82200.0
2006-01-10 17:00:00	SPY	ETF	128.9	128.91	128.86	128.91	12500.0
2006-01-10 17:30:00	SPY	ETF	128.92	128.92	128.92	128.92	400.0
2006-01-10 18:00:00	SPY	ETF	128.9	128.9	128.85	128.85	600.0
2006-01-10 18:30:00	SPY	ETF	128.84	128.84	128.84	128.84	3000.0
2006-01-10 19:30:00	SPY	ETF	128.85	128.85	128.83	128.83	1000.0
2006-01-10 09:30:00	QQQ	ETF	42.63	42.7	42.55	42.59	13562500.0
2006-01-10 10:00:00	QQQ	ETF	42.59	42.75	42.59	42.7	7671300.0
2006-01-10 10:30:00	QQQ	ETF	42.7	42.76	42.64	42.65	4593900.0
2006-01-10 11:00:00	QQQ	ETF	42.64	42.66	42.55	42.65	3965900.0
2006-01-10 11:30:00	QQQ	ETF	42.65	42.74	42.6	42.69	4387100.0
2006-01-10 12:00:00	QQQ	ETF	42.69	42.83	42.69	42.76	4473100.0
2006-01-10 12:30:00	QQQ	ETF	42.75	42.79	42.71	42.77	3008300.0
2006-01-10 13:00:00	QQQ	ETF	42.77	42.92	42.74	42.86	5995300.0
2006-01-10 13:30:00	QQQ	ETF	42.86	42.9	42.71	42.71	3373600.0
2006-01-10 14:00:00	QQQ	ETF	42.72	42.76	42.66	42.67	4686100.0
2006-01-10 14:30:00	QQQ	ETF	42.67	42.69	42.6	42.64	4999500.0
2006-01-10 15:00:00	QQQ	ETF	42.65	42.76	42.59	42.75	5649800.0
2006-01-10 15:30:00	QQQ	ETF	42.75	42.88	42.74	42.88	8779000.0
2006-01-10 07:30:00	IWM	ETF	69.76	69.76	69.76	69.76	2500.0
2006-01-10 08:00:00	IWM	ETF	69.81	69.81	69.67	69.68	29500.0
2006-01-10 08:30:00	IWM	ETF	69.68	69.74	69.67	69.74	19500.0
2006-01-10 09:00:00	IWM	ETF	69.7	69.71	69.67	69.71	55300.0
2006-01-10 09:30:00	IWM	ETF	69.73	69.97	69.68	69.94	2762800.0
2006-01-10 10:00:00	IWM	ETF	69.95	70.25	69.93	70.18	3297600.0
2006-01-10 10:30:00	IWM	ETF	70.19	70.39	70.13	70.1601	2361700.0
2006-01-10 11:00:00	IWM	ETF	70.18	70.22	69.99	70.2	1148700.0
2006-01-10 11:30:00	IWM	ETF	70.2	70.42	70.17	70.34	1560300.0
2006-01-10 12:00:00	IWM	ETF	70.33	70.55	70.33	70.42	1475000.0
2006-01-10 12:30:00	IWM	ETF	70.42	70.46	70.34	70.43	642200.0
2006-01-10 13:00:00	IWM	ETF	70.43	70.63	70.39	70.59	1038500.0

> showing 50 of 2,136 rows — these rows as CSV

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