PREVIEW / etf_30min / 2006-01-18

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-18.parquet
  size:    61 KB
  rows:    2,200

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-18 06:00:00	SPY	ETF	127.21	127.21	127.2	127.2	11700.0
2006-01-18 06:30:00	SPY	ETF	127.17	127.25	127.17	127.19	88100.0
2006-01-18 07:00:00	SPY	ETF	127.23	127.5	127.21	127.5	89400.0
2006-01-18 07:30:00	SPY	ETF	127.5	127.53	127.45	127.47	81800.0
2006-01-18 08:00:00	SPY	ETF	127.49	127.56	127.16	127.16	1149400.0
2006-01-18 08:30:00	SPY	ETF	127.47	128.33	127.39	127.52	927300.0
2006-01-18 09:00:00	SPY	ETF	127.51	127.67	127.48	127.59	836500.0
2006-01-18 09:30:00	SPY	ETF	127.58	127.9	127.53	127.8	7329100.0
2006-01-18 10:00:00	SPY	ETF	127.8	128.24	127.76	128.11	8704500.0
2006-01-18 10:30:00	SPY	ETF	128.11	128.9	127.81	127.84	3084400.0
2006-01-18 11:00:00	SPY	ETF	127.84	127.93	127.65	127.75	4859700.0
2006-01-18 11:30:00	SPY	ETF	127.73	127.73	127.4	127.53	5451500.0
2006-01-18 12:00:00	SPY	ETF	127.52	127.59	127.31	127.39	3988400.0
2006-01-18 12:30:00	SPY	ETF	127.38	127.53	127.32	127.45	3703900.0
2006-01-18 13:00:00	SPY	ETF	127.45	127.53	127.23	127.24	4109400.0
2006-01-18 13:30:00	SPY	ETF	127.24	127.39	127.16	127.32	6997900.0
2006-01-18 14:00:00	SPY	ETF	127.31	127.79	127.31	127.71	6854900.0
2006-01-18 14:30:00	SPY	ETF	127.71	127.84	127.35	127.48	5089400.0
2006-01-18 15:00:00	SPY	ETF	127.48	127.77	127.36	127.74	2714600.0
2006-01-18 15:30:00	SPY	ETF	127.74	127.91	127.66	127.79	3023100.0
2006-01-18 16:00:00	SPY	ETF	127.79	127.85	127.65	127.68	319100.0
2006-01-18 16:30:00	SPY	ETF	127.65	127.76	127.55	127.61	591100.0
2006-01-18 17:00:00	SPY	ETF	127.6	127.85	127.59	127.85	16900.0
2006-01-18 17:30:00	SPY	ETF	127.86	127.97	127.86	127.95	35400.0
2006-01-18 18:00:00	SPY	ETF	127.91	128.06	127.91	128.0	48600.0
2006-01-18 18:30:00	SPY	ETF	127.99	128.0	127.99	127.99	2400.0
2006-01-18 19:00:00	SPY	ETF	128.0	128.0	128.0	128.0	2300.0
2006-01-18 19:30:00	SPY	ETF	128.01	128.01	127.98	127.98	1300.0
2006-01-18 09:30:00	QQQ	ETF	42.04	42.24	42.02	42.18	22592800.0
2006-01-18 10:00:00	QQQ	ETF	42.18	42.46	42.16	42.36	17048300.0
2006-01-18 10:30:00	QQQ	ETF	42.36	42.37	42.24	42.25	5034100.0
2006-01-18 11:00:00	QQQ	ETF	42.25	42.27	42.17	42.23	7646500.0
2006-01-18 11:30:00	QQQ	ETF	42.23	42.23	42.08	42.15	7479500.0
2006-01-18 12:00:00	QQQ	ETF	42.14	42.2	42.06	42.09	5070800.0
2006-01-18 12:30:00	QQQ	ETF	42.09	42.15	42.06	42.13	3614500.0
2006-01-18 13:00:00	QQQ	ETF	42.13	42.18	42.08	42.12	7094300.0
2006-01-18 13:30:00	QQQ	ETF	42.12	42.2	42.11	42.17	4358600.0
2006-01-18 14:00:00	QQQ	ETF	42.18	42.33	42.17	42.31	8210300.0
2006-01-18 14:30:00	QQQ	ETF	42.3	42.37	42.14	42.2	4875500.0
2006-01-18 15:00:00	QQQ	ETF	42.21	42.28	42.15	42.27	3505300.0
2006-01-18 15:30:00	QQQ	ETF	42.27	42.33	42.2	42.22	6497100.0
2006-01-18 07:00:00	IWM	ETF	69.37	69.38	69.37	69.38	2000.0
2006-01-18 08:00:00	IWM	ETF	69.38	69.38	69.2	69.38	20700.0
2006-01-18 08:30:00	IWM	ETF	69.4	69.41	69.28	69.32	62900.0
2006-01-18 09:00:00	IWM	ETF	69.29	69.41	69.29	69.39	40800.0
2006-01-18 09:30:00	IWM	ETF	69.39	69.8	69.3	69.61	7652500.0
2006-01-18 10:00:00	IWM	ETF	69.6	70.0	69.56	69.95	4390800.0
2006-01-18 10:30:00	IWM	ETF	69.94	69.94	69.77	69.81	2163000.0
2006-01-18 11:00:00	IWM	ETF	69.8	69.88	69.71	69.84	1957400.0
2006-01-18 11:30:00	IWM	ETF	69.8401	69.85	69.67	69.75	1775300.0

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

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