PREVIEW / etf_30min / 2006-03-06

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-03-06.parquet
  size:    62 KB
  rows:    2,179

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-03-06 04:00:00	SPY	ETF	129.17	129.17	129.17	129.17	14000.0
2006-03-06 05:30:00	SPY	ETF	129.25	129.25	129.25	129.25	100.0
2006-03-06 06:00:00	SPY	ETF	129.14	129.14	129.08	129.12	240500.0
2006-03-06 06:30:00	SPY	ETF	129.14	129.14	129.09	129.09	31500.0
2006-03-06 07:00:00	SPY	ETF	129.09	129.17	129.09	129.14	18400.0
2006-03-06 07:30:00	SPY	ETF	129.15	129.15	129.05	129.07	92200.0
2006-03-06 08:00:00	SPY	ETF	129.1	129.19	128.81	129.08	1132500.0
2006-03-06 08:30:00	SPY	ETF	129.09	129.34	128.99	129.1	398000.0
2006-03-06 09:00:00	SPY	ETF	129.1	129.15	129.08	129.15	288700.0
2006-03-06 09:30:00	SPY	ETF	129.14	129.18	128.68	128.86	7055500.0
2006-03-06 10:00:00	SPY	ETF	128.86	129.07	128.76	128.9	3886700.0
2006-03-06 10:30:00	SPY	ETF	128.9	129.03	128.74	129.01	2786700.0
2006-03-06 11:00:00	SPY	ETF	129.0	129.07	128.86	129.01	2512800.0
2006-03-06 11:30:00	SPY	ETF	129.01	129.13	128.86	128.98	1470700.0
2006-03-06 12:00:00	SPY	ETF	128.981	129.02	128.74	128.85	2241000.0
2006-03-06 12:30:00	SPY	ETF	128.85	128.9	128.69	128.7805	1566000.0
2006-03-06 13:00:00	SPY	ETF	128.78	128.96	128.58	128.6	1661000.0
2006-03-06 13:30:00	SPY	ETF	128.6	128.77	128.24	128.36	7875500.0
2006-03-06 14:00:00	SPY	ETF	128.35	128.36	127.85	127.97	6723700.0
2006-03-06 14:30:00	SPY	ETF	127.97	128.09	127.91	128.01	3540600.0
2006-03-06 15:00:00	SPY	ETF	128.01	129.04	127.96	128.18	4020100.0
2006-03-06 15:30:00	SPY	ETF	128.18	128.25	128.05	128.14	5730500.0
2006-03-06 16:00:00	SPY	ETF	128.15	128.503	128.12	128.14	659700.0
2006-03-06 16:30:00	SPY	ETF	128.14	128.21	128.03	128.08	555900.0
2006-03-06 17:00:00	SPY	ETF	128.06	128.09	128.06	128.06	7200.0
2006-03-06 18:00:00	SPY	ETF	128.09	128.09	128.07	128.07	700.0
2006-03-06 19:30:00	SPY	ETF	128.1	128.1	128.1	128.1	300.0
2006-03-06 09:30:00	QQQ	ETF	41.53	41.54	41.35	41.48	16615000.0
2006-03-06 10:00:00	QQQ	ETF	41.47	41.57	41.42	41.51	6737000.0
2006-03-06 10:30:00	QQQ	ETF	41.5	41.55	41.41	41.55	4781800.0
2006-03-06 11:00:00	QQQ	ETF	41.54	41.58	41.48	41.53	2706800.0
2006-03-06 11:30:00	QQQ	ETF	41.54	41.63	41.5	41.58	5584800.0
2006-03-06 12:00:00	QQQ	ETF	41.57	41.59	41.47	41.52	2198000.0
2006-03-06 12:30:00	QQQ	ETF	41.53	41.54	41.45	41.47	1859800.0
2006-03-06 13:00:00	QQQ	ETF	41.47	41.55	41.37	41.38	3248000.0
2006-03-06 13:30:00	QQQ	ETF	41.39	41.39	41.08	41.14	12626300.0
2006-03-06 14:00:00	QQQ	ETF	41.14	41.15	40.96	41.06	8402800.0
2006-03-06 14:30:00	QQQ	ETF	41.07	41.45	40.98	41.06	6113300.0
2006-03-06 15:00:00	QQQ	ETF	41.06	41.15	41.03	41.13	5084900.0
2006-03-06 15:30:00	QQQ	ETF	41.12	41.45	41.05	41.09	9983300.0
2006-03-06 07:00:00	IWM	ETF	73.25	73.25	73.25	73.25	100.0
2006-03-06 08:00:00	IWM	ETF	73.32	73.36	73.32	73.36	1200.0
2006-03-06 08:30:00	IWM	ETF	73.36	73.37	73.34	73.37	62200.0
2006-03-06 09:00:00	IWM	ETF	73.39	73.43	73.29	73.4	241300.0
2006-03-06 09:30:00	IWM	ETF	73.4	73.4	72.79	73.0	3521900.0
2006-03-06 10:00:00	IWM	ETF	73.0	73.29	72.95	73.09	2858200.0
2006-03-06 10:30:00	IWM	ETF	73.1	73.23	73.01	73.23	2123500.0
2006-03-06 11:00:00	IWM	ETF	73.23	73.39	73.18	73.26	1826200.0
2006-03-06 11:30:00	IWM	ETF	73.27	73.46	73.18	73.26	1459100.0
2006-03-06 12:00:00	IWM	ETF	73.26	73.3351	73.05	73.18	1060100.0

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

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