PREVIEW / etf_30min / 2006-10-27

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-10-27.parquet
  size:    85 KB
  rows:    2,980

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-10-27 06:30:00	SPY	ETF	138.61	138.61	138.59	138.59	25000.0
2006-10-27 07:00:00	SPY	ETF	138.57	138.59	138.53	138.59	49600.0
2006-10-27 07:30:00	SPY	ETF	138.6	138.63	138.59	138.59	55600.0
2006-10-27 08:00:00	SPY	ETF	138.65	138.65	138.53	138.59	838000.0
2006-10-27 08:30:00	SPY	ETF	138.59	138.62	138.42	138.58	2255800.0
2006-10-27 09:00:00	SPY	ETF	138.58	138.59	138.48	138.59	670000.0
2006-10-27 09:30:00	SPY	ETF	138.61	138.63	138.2	138.36	9729100.0
2006-10-27 10:00:00	SPY	ETF	138.36	138.5	138.26	138.37	6918100.0
2006-10-27 10:30:00	SPY	ETF	138.37	138.56	138.27	138.47	2982500.0
2006-10-27 11:00:00	SPY	ETF	138.46	138.68	138.4	138.57	3729300.0
2006-10-27 11:30:00	SPY	ETF	138.58	138.68	138.48	138.57	2129300.0
2006-10-27 12:00:00	SPY	ETF	138.56	138.67	138.49	138.61	1448900.0
2006-10-27 12:30:00	SPY	ETF	138.61	138.75	138.55	138.57	2049000.0
2006-10-27 13:00:00	SPY	ETF	138.58	138.68	138.38	138.44	2012000.0
2006-10-27 13:30:00	SPY	ETF	138.43	138.45	138.04	138.21	7298100.0
2006-10-27 14:00:00	SPY	ETF	138.21	138.31	137.77	137.87	5563800.0
2006-10-27 14:30:00	SPY	ETF	137.88	137.92	137.67	137.91	7833000.0
2006-10-27 15:00:00	SPY	ETF	137.91	138.01	137.77	137.82	3202200.0
2006-10-27 15:30:00	SPY	ETF	137.83	137.93	137.63	137.93	7709100.0
2006-10-27 16:00:00	SPY	ETF	137.94	138.9692	137.78	137.87	2239800.0
2006-10-27 16:30:00	SPY	ETF	137.9	137.9	137.77	137.9	2415100.0
2006-10-27 17:00:00	SPY	ETF	137.84	137.87	137.84	137.87	500.0
2006-10-27 17:30:00	SPY	ETF	137.87	137.87	136.7802	137.87	2052800.0
2006-10-27 18:00:00	SPY	ETF	137.87	137.87	137.81	137.81	2000.0
2006-10-27 18:30:00	SPY	ETF	137.82	137.82	137.82	137.82	100.0
2006-10-27 19:00:00	SPY	ETF	137.82	137.82	137.81	137.81	1000.0
2006-10-27 19:30:00	SPY	ETF	137.81	137.81	137.81	137.81	400.0
2006-10-27 09:30:00	QQQ	ETF	42.73	42.78	42.59	42.69	13753300.0
2006-10-27 10:00:00	QQQ	ETF	42.7	42.78	42.63	42.67	7394100.0
2006-10-27 10:30:00	QQQ	ETF	42.66	42.73	42.63	42.71	5556800.0
2006-10-27 11:00:00	QQQ	ETF	42.71	42.79	42.65	42.74	6453000.0
2006-10-27 11:30:00	QQQ	ETF	42.73	42.77	42.71	42.76	3897300.0
2006-10-27 12:00:00	QQQ	ETF	42.77	42.79	42.73	42.76	1989900.0
2006-10-27 12:30:00	QQQ	ETF	42.77	42.82	42.71	42.73	5790700.0
2006-10-27 13:00:00	QQQ	ETF	42.74	42.76	42.61	42.61	4207700.0
2006-10-27 13:30:00	QQQ	ETF	42.62	42.62	42.28	42.38	17124400.0
2006-10-27 14:00:00	QQQ	ETF	42.38	42.44	42.16	42.22	14899000.0
2006-10-27 14:30:00	QQQ	ETF	42.23	42.32	42.08	42.22	12987400.0
2006-10-27 15:00:00	QQQ	ETF	42.22	42.3	42.16	42.2	12895400.0
2006-10-27 15:30:00	QQQ	ETF	42.19	42.25	42.13	42.22	13669100.0
2006-10-27 07:30:00	IWM	ETF	76.9	76.9	76.9	76.9	100.0
2006-10-27 08:00:00	IWM	ETF	76.9	76.97	76.89	76.9	23500.0
2006-10-27 08:30:00	IWM	ETF	76.89	76.92	76.78	76.9	387400.0
2006-10-27 09:00:00	IWM	ETF	76.92	76.95	76.86	76.89	464000.0
2006-10-27 09:30:00	IWM	ETF	76.89	76.95	76.43	76.86	6396900.0
2006-10-27 10:00:00	IWM	ETF	76.86	77.11	76.79	76.98	7033400.0
2006-10-27 10:30:00	IWM	ETF	76.98	77.07	76.84	76.93	2257000.0
2006-10-27 11:00:00	IWM	ETF	76.93	77.02	76.75	76.92	4629900.0
2006-10-27 11:30:00	IWM	ETF	76.93	76.97	76.81	76.91	1033600.0
2006-10-27 12:00:00	IWM	ETF	76.91	76.99	76.84	76.92	1281100.0

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

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