PREVIEW / etf_30min / 2006-07-07

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-07.parquet
  size:    74 KB
  rows:    2,606

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-07-07 06:30:00	SPY	ETF	127.51	127.56	127.51	127.51	121700.0
2006-07-07 07:00:00	SPY	ETF	127.5	127.54	127.49	127.49	6100.0
2006-07-07 07:30:00	SPY	ETF	127.45	127.46	127.42	127.45	238100.0
2006-07-07 08:00:00	SPY	ETF	127.21	127.65	127.21	127.64	1404400.0
2006-07-07 08:30:00	SPY	ETF	127.76	128.13	127.58	127.58	9090800.0
2006-07-07 09:00:00	SPY	ETF	127.59	127.59	127.04	127.2	5823800.0
2006-07-07 09:30:00	SPY	ETF	127.19	127.33	126.84	127.05	11230500.0
2006-07-07 10:00:00	SPY	ETF	127.05	127.41	126.93	127.25	8155200.0
2006-07-07 10:30:00	SPY	ETF	127.24	127.3	127.02	127.151	3429200.0
2006-07-07 11:00:00	SPY	ETF	127.12	127.23	127.01	127.11	2272500.0
2006-07-07 11:30:00	SPY	ETF	127.11	127.54	127.06	127.33	4844500.0
2006-07-07 12:00:00	SPY	ETF	127.33	127.47	127.21	127.44	1677500.0
2006-07-07 12:30:00	SPY	ETF	127.45	127.56	127.26	127.3	2590200.0
2006-07-07 13:00:00	SPY	ETF	127.28	127.55	126.89	127.04	4049500.0
2006-07-07 13:30:00	SPY	ETF	127.04	127.12	126.95	127.02	1847300.0
2006-07-07 14:00:00	SPY	ETF	127.02	127.18	126.98	127.03	1782300.0
2006-07-07 14:30:00	SPY	ETF	127.04	127.06	126.37	126.41	7678200.0
2006-07-07 15:00:00	SPY	ETF	126.41	126.5	126.29	126.37	5955500.0
2006-07-07 15:30:00	SPY	ETF	126.36	126.61	126.3	126.53	6488800.0
2006-07-07 16:00:00	SPY	ETF	126.53	126.67	126.51	126.64	795500.0
2006-07-07 16:30:00	SPY	ETF	126.62	126.65	126.58	126.58	10500.0
2006-07-07 17:00:00	SPY	ETF	126.6	126.61	126.6	126.6	7300.0
2006-07-07 17:30:00	SPY	ETF	126.6	126.62	126.58	126.6	2100.0
2006-07-07 18:00:00	SPY	ETF	126.59	126.59	126.58	126.58	1300.0
2006-07-07 18:30:00	SPY	ETF	126.63	126.63	126.63	126.63	500.0
2006-07-07 19:00:00	SPY	ETF	126.59	126.59	126.59	126.59	100.0
2006-07-07 09:30:00	QQQ	ETF	37.89	37.9	37.71	37.8	13151200.0
2006-07-07 10:00:00	QQQ	ETF	37.8	37.91	37.76	37.82	7022200.0
2006-07-07 10:30:00	QQQ	ETF	37.82	37.89	37.78	37.83	4374500.0
2006-07-07 11:00:00	QQQ	ETF	37.83	37.86	37.78	37.86	1911800.0
2006-07-07 11:30:00	QQQ	ETF	37.85	38.02	37.82	37.93	8100400.0
2006-07-07 12:00:00	QQQ	ETF	37.94	38.03	37.91	38.02	3131600.0
2006-07-07 12:30:00	QQQ	ETF	38.02	38.17	38.0	38.02	7094300.0
2006-07-07 13:00:00	QQQ	ETF	38.03	38.05	37.87	37.91	5274100.0
2006-07-07 13:30:00	QQQ	ETF	37.92	37.95	37.87	37.93	2318300.0
2006-07-07 14:00:00	QQQ	ETF	37.92	38.0	37.91	37.95	2472000.0
2006-07-07 14:30:00	QQQ	ETF	37.95	37.96	37.61	37.65	15667200.0
2006-07-07 15:00:00	QQQ	ETF	37.65	37.67	37.57	37.62	9898600.0
2006-07-07 15:30:00	QQQ	ETF	37.62	37.7	37.6	37.68	9882600.0
2006-07-07 08:00:00	IWM	ETF	71.38	71.68	71.38	71.68	72300.0
2006-07-07 08:30:00	IWM	ETF	71.79	72.23	71.78	71.84	827300.0
2006-07-07 09:00:00	IWM	ETF	71.83	71.86	71.3	71.45	864900.0
2006-07-07 09:30:00	IWM	ETF	71.45	71.46	70.9	71.11	6337600.0
2006-07-07 10:00:00	IWM	ETF	71.11	71.48	71.03	71.3	3819500.0
2006-07-07 10:30:00	IWM	ETF	71.31	71.38	71.12	71.19	1801600.0
2006-07-07 11:00:00	IWM	ETF	71.19	71.27	71.11	71.26	1882700.0
2006-07-07 11:30:00	IWM	ETF	71.27	71.6	71.2	71.44	3485000.0
2006-07-07 12:00:00	IWM	ETF	71.44	71.57	71.37	71.55	1675000.0
2006-07-07 12:30:00	IWM	ETF	71.56	71.64	71.32	71.36	4070800.0
2006-07-07 13:00:00	IWM	ETF	71.36	71.44	71.06	71.15	2708700.0

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

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