PREVIEW / etf_30min / 2006-07-13

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-13.parquet
  size:    80 KB
  rows:    2,722

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-13 06:00:00	SPY	ETF	125.78	125.78	125.78	125.78	25000.0
2006-07-13 06:30:00	SPY	ETF	125.71	125.75	125.71	125.75	25000.0
2006-07-13 07:00:00	SPY	ETF	125.71	125.72	125.56	125.6	52700.0
2006-07-13 07:30:00	SPY	ETF	125.6	125.64	125.42	125.5	62400.0
2006-07-13 08:00:00	SPY	ETF	125.52	125.64	125.22	125.37	3069400.0
2006-07-13 08:30:00	SPY	ETF	125.38	125.44	125.3322	125.39	692800.0
2006-07-13 09:00:00	SPY	ETF	125.39	125.6	125.21	125.48	1219900.0
2006-07-13 09:30:00	SPY	ETF	125.5	125.55	124.94	125.01	9634600.0
2006-07-13 10:00:00	SPY	ETF	125.01	125.17	124.87	125.16	8620100.0
2006-07-13 10:30:00	SPY	ETF	125.16	125.48	125.01	125.08	8638400.0
2006-07-13 11:00:00	SPY	ETF	125.08	125.23	124.83	125.21	5741100.0
2006-07-13 11:30:00	SPY	ETF	125.22	125.4	125.01	125.27	4467600.0
2006-07-13 12:00:00	SPY	ETF	125.28	125.68	125.18	125.4	5845500.0
2006-07-13 12:30:00	SPY	ETF	125.4	125.62	125.26	125.33	3112200.0
2006-07-13 13:00:00	SPY	ETF	125.3	125.45	124.88	124.97	4648800.0
2006-07-13 13:30:00	SPY	ETF	124.96	125.03	124.61	124.63	7489500.0
2006-07-13 14:00:00	SPY	ETF	124.62	124.88	124.56	124.76	6502000.0
2006-07-13 14:30:00	SPY	ETF	124.76	124.76	124.27	124.41	7527200.0
2006-07-13 15:00:00	SPY	ETF	124.41	124.42	124.12	124.35	7019900.0
2006-07-13 15:30:00	SPY	ETF	124.34	124.48	124.16	124.19	9748000.0
2006-07-13 16:00:00	SPY	ETF	124.19	124.19	123.93	124.05	1948800.0
2006-07-13 16:30:00	SPY	ETF	124.05	124.09	123.99	123.99	1279300.0
2006-07-13 17:00:00	SPY	ETF	123.99	124.04	123.96	124.0	1060200.0
2006-07-13 17:30:00	SPY	ETF	123.99	123.99	123.92	123.92	86000.0
2006-07-13 18:00:00	SPY	ETF	123.94	123.94	123.65	123.65	515500.0
2006-07-13 18:30:00	SPY	ETF	123.67	123.76	123.66	123.76	35100.0
2006-07-13 19:00:00	SPY	ETF	123.73	123.73	123.66	123.73	127100.0
2006-07-13 19:30:00	SPY	ETF	123.73	123.74	123.71	123.73	13700.0
2006-07-13 09:30:00	QQQ	ETF	36.66	36.67	36.39	36.41	20206200.0
2006-07-13 10:00:00	QQQ	ETF	36.41	36.58	36.36	36.56	14706400.0
2006-07-13 10:30:00	QQQ	ETF	36.56	36.78	36.5	36.62	22799200.0
2006-07-13 11:00:00	QQQ	ETF	36.62	36.73	36.55	36.71	9673900.0
2006-07-13 11:30:00	QQQ	ETF	36.71	36.85	36.64	36.77	11509800.0
2006-07-13 12:00:00	QQQ	ETF	36.77	37.04	36.77	36.86	14852400.0
2006-07-13 12:30:00	QQQ	ETF	36.85	36.94	36.78	36.8	5977800.0
2006-07-13 13:00:00	QQQ	ETF	36.8	36.84	36.64	36.66	7275800.0
2006-07-13 13:30:00	QQQ	ETF	36.66	36.67	36.46	36.47	10567800.0
2006-07-13 14:00:00	QQQ	ETF	36.47	36.63	36.44	36.58	11642800.0
2006-07-13 14:30:00	QQQ	ETF	36.58	36.59	36.4	36.44	9842900.0
2006-07-13 15:00:00	QQQ	ETF	36.43	36.46	36.32	36.45	11648300.0
2006-07-13 15:30:00	QQQ	ETF	36.45	36.5	36.31	36.32	13745100.0
2006-07-13 07:30:00	IWM	ETF	69.55	69.63	69.55	69.63	2500.0
2006-07-13 08:00:00	IWM	ETF	68.59	69.63	68.59	69.02	171200.0
2006-07-13 08:30:00	IWM	ETF	69.06	69.1	68.94	69.04	100800.0
2006-07-13 09:00:00	IWM	ETF	69.01	69.17	68.93	69.17	304600.0
2006-07-13 09:30:00	IWM	ETF	69.18	69.21	68.6	68.62	9248700.0
2006-07-13 10:00:00	IWM	ETF	68.64	68.89	68.55	68.87	6131800.0
2006-07-13 10:30:00	IWM	ETF	68.87	69.5	68.83	68.87	9332200.0
2006-07-13 11:00:00	IWM	ETF	68.86	69.08	68.75	69.05	5035000.0
2006-07-13 11:30:00	IWM	ETF	69.04	69.22	68.85	69.03	3701700.0

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

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