PREVIEW / etf_30min / 2006-06-22

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-22.parquet
  size:    70 KB
  rows:    2,484

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-06-22 04:00:00	SPY	ETF	125.45	125.45	125.45	125.45	3000.0
2006-06-22 05:30:00	SPY	ETF	125.32	125.32	125.32	125.32	10000.0
2006-06-22 06:30:00	SPY	ETF	125.27	125.27	125.27	125.27	1000.0
2006-06-22 07:00:00	SPY	ETF	125.23	125.26	125.06	125.06	17500.0
2006-06-22 07:30:00	SPY	ETF	125.07	125.11	125.07	125.09	6900.0
2006-06-22 08:00:00	SPY	ETF	125.1	125.21	125.04	125.08	454700.0
2006-06-22 08:30:00	SPY	ETF	125.1	125.1	124.97	125.05	578700.0
2006-06-22 09:00:00	SPY	ETF	125.01	125.01	124.88	124.94	150000.0
2006-06-22 09:30:00	SPY	ETF	124.95	125.06	124.74	124.96	6356600.0
2006-06-22 10:00:00	SPY	ETF	124.96	125.03	124.38	124.49	11523800.0
2006-06-22 10:30:00	SPY	ETF	124.48	124.99	124.37	124.61	5893700.0
2006-06-22 11:00:00	SPY	ETF	124.62	124.77	124.46	124.68	3476000.0
2006-06-22 11:30:00	SPY	ETF	124.69	124.84	124.63	124.7	3706700.0
2006-06-22 12:00:00	SPY	ETF	124.71	124.84	124.56	124.62	1934300.0
2006-06-22 12:30:00	SPY	ETF	124.61	124.61	124.22	124.43	4176600.0
2006-06-22 13:00:00	SPY	ETF	124.42	124.51	124.37	124.41	2779800.0
2006-06-22 13:30:00	SPY	ETF	124.42	124.42	124.04	124.31	6164100.0
2006-06-22 14:00:00	SPY	ETF	124.31	124.38	124.04	124.26	3047400.0
2006-06-22 14:30:00	SPY	ETF	124.26	124.48	124.15	124.4	3744400.0
2006-06-22 15:00:00	SPY	ETF	124.4	124.62	124.25	124.57	4374000.0
2006-06-22 15:30:00	SPY	ETF	124.57	124.69	124.36	124.45	12913100.0
2006-06-22 16:00:00	SPY	ETF	124.46	124.5	124.34	124.35	2003900.0
2006-06-22 16:30:00	SPY	ETF	124.39	124.45	124.34	124.45	303600.0
2006-06-22 17:00:00	SPY	ETF	124.48	124.48	124.43	124.43	30700.0
2006-06-22 18:00:00	SPY	ETF	124.46	124.46	124.42	124.43	11200.0
2006-06-22 18:30:00	SPY	ETF	124.43	124.47	124.43	124.47	2400.0
2006-06-22 19:00:00	SPY	ETF	124.47	124.48	124.45	124.45	1100.0
2006-06-22 19:30:00	SPY	ETF	124.46	124.46	124.46	124.46	400.0
2006-06-22 09:30:00	QQQ	ETF	38.6	38.68	38.49	38.56	13319000.0
2006-06-22 10:00:00	QQQ	ETF	38.56	38.59	38.15	38.2	21715800.0
2006-06-22 10:30:00	QQQ	ETF	38.19	38.27	38.1	38.22	16226700.0
2006-06-22 11:00:00	QQQ	ETF	38.23	38.33	38.16	38.27	8601900.0
2006-06-22 11:30:00	QQQ	ETF	38.27	38.35	38.22	38.25	5656900.0
2006-06-22 12:00:00	QQQ	ETF	38.25	38.32	38.17	38.21	5464100.0
2006-06-22 12:30:00	QQQ	ETF	38.21	38.21	38.08	38.17	8146800.0
2006-06-22 13:00:00	QQQ	ETF	38.17	38.22	38.14	38.2	4209000.0
2006-06-22 13:30:00	QQQ	ETF	38.2	38.21	37.99	38.14	10941300.0
2006-06-22 14:00:00	QQQ	ETF	38.14	38.2	38.03	38.15	9175100.0
2006-06-22 14:30:00	QQQ	ETF	38.14	38.23	38.05	38.17	6921300.0
2006-06-22 15:00:00	QQQ	ETF	38.17	38.27	38.09	38.22	9408200.0
2006-06-22 15:30:00	QQQ	ETF	38.21	38.27	38.14	38.19	11429900.0
2006-06-22 08:00:00	IWM	ETF	68.58	68.66	68.39	68.39	314400.0
2006-06-22 08:30:00	IWM	ETF	68.4	68.41	68.31	68.36	125300.0
2006-06-22 09:00:00	IWM	ETF	68.36	68.41	68.32	68.39	264900.0
2006-06-22 09:30:00	IWM	ETF	68.39	68.54	68.1	68.49	7963800.0
2006-06-22 10:00:00	IWM	ETF	68.5	68.57	68.02	68.11	5327600.0
2006-06-22 10:30:00	IWM	ETF	68.1	68.36	67.96	68.21	4049600.0
2006-06-22 11:00:00	IWM	ETF	68.22	68.47	68.14	68.41	2179700.0
2006-06-22 11:30:00	IWM	ETF	68.41	68.59	68.39	68.49	2053800.0
2006-06-22 12:00:00	IWM	ETF	68.5	68.61	68.3	68.33	1770000.0

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

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