PREVIEW / etf_30min / 2006-08-01

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-01.parquet
  size:    74 KB
  rows:    2,633

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-08-01 04:30:00	SPY	ETF	127.71	127.71	127.71	127.71	1500.0
2006-08-01 06:30:00	SPY	ETF	127.67	127.67	127.67	127.67	3000.0
2006-08-01 07:00:00	SPY	ETF	127.67	127.67	127.6	127.61	2200.0
2006-08-01 07:30:00	SPY	ETF	127.61	127.68	127.61	127.65	39900.0
2006-08-01 08:00:00	SPY	ETF	127.65	127.71	127.59	127.7	380600.0
2006-08-01 08:30:00	SPY	ETF	127.7	127.89	127.44	127.45	1435000.0
2006-08-01 09:00:00	SPY	ETF	127.43	127.51	127.26	127.33	1436900.0
2006-08-01 09:30:00	SPY	ETF	127.34	127.38	127.02	127.18	6670400.0
2006-08-01 10:00:00	SPY	ETF	127.19	127.21	126.6	126.77	11016000.0
2006-08-01 10:30:00	SPY	ETF	126.78	126.94	126.69	126.7	4165500.0
2006-08-01 11:00:00	SPY	ETF	126.7	126.89	126.67	126.84	2690300.0
2006-08-01 11:30:00	SPY	ETF	126.83	127.01	126.8	126.91	2003000.0
2006-08-01 12:00:00	SPY	ETF	126.91	127.05	126.85	126.92	2671200.0
2006-08-01 12:30:00	SPY	ETF	126.94	127.0	126.82	126.98	1823900.0
2006-08-01 13:00:00	SPY	ETF	127.0	127.01	126.74	126.78	1573400.0
2006-08-01 13:30:00	SPY	ETF	126.78	126.99	126.74	126.92	2199800.0
2006-08-01 14:00:00	SPY	ETF	126.9	127.07	126.76	126.83	3116300.0
2006-08-01 14:30:00	SPY	ETF	126.83	126.93	126.64	126.85	3441700.0
2006-08-01 15:00:00	SPY	ETF	126.84	126.95	126.7	126.9	4444000.0
2006-08-01 15:30:00	SPY	ETF	126.9	127.34	126.88	127.18	10307000.0
2006-08-01 16:00:00	SPY	ETF	127.18	127.27	127.12	127.23	876600.0
2006-08-01 16:30:00	SPY	ETF	127.23	127.28	127.23	127.25	128200.0
2006-08-01 17:00:00	SPY	ETF	127.24	127.25	127.19	127.22	179700.0
2006-08-01 17:30:00	SPY	ETF	127.24	127.24	127.24	127.24	400.0
2006-08-01 18:30:00	SPY	ETF	127.23	127.23	127.23	127.23	4700.0
2006-08-01 09:30:00	QQQ	ETF	36.79	36.8	36.65	36.73	10837100.0
2006-08-01 10:00:00	QQQ	ETF	36.73	36.76	36.42	36.47	17110900.0
2006-08-01 10:30:00	QQQ	ETF	36.48	36.56	36.38	36.38	7194500.0
2006-08-01 11:00:00	QQQ	ETF	36.38	36.5	36.38	36.43	6349100.0
2006-08-01 11:30:00	QQQ	ETF	36.43	36.54	36.43	36.51	4693000.0
2006-08-01 12:00:00	QQQ	ETF	36.51	36.53	36.44	36.49	3149400.0
2006-08-01 12:30:00	QQQ	ETF	36.49	36.52	36.42	36.5	1984300.0
2006-08-01 13:00:00	QQQ	ETF	36.49	36.5	36.35	36.37	4189200.0
2006-08-01 13:30:00	QQQ	ETF	36.38	36.42	36.33	36.41	3913800.0
2006-08-01 14:00:00	QQQ	ETF	36.41	36.47	36.33	36.35	5164800.0
2006-08-01 14:30:00	QQQ	ETF	36.36	36.38	36.26	36.34	7839500.0
2006-08-01 15:00:00	QQQ	ETF	36.35	36.4	36.28	36.37	4264000.0
2006-08-01 15:30:00	QQQ	ETF	36.37	36.55	36.37	36.49	14390100.0
2006-08-01 08:00:00	IWM	ETF	69.46	69.68	69.46	69.68	247800.0
2006-08-01 08:30:00	IWM	ETF	69.61	69.64	69.26	69.26	307300.0
2006-08-01 09:00:00	IWM	ETF	69.27	69.68	68.7467	69.17	201500.0
2006-08-01 09:30:00	IWM	ETF	69.17	69.23	68.59	68.72	9131900.0
2006-08-01 10:00:00	IWM	ETF	68.71	68.74	68.18	68.48	6456500.0
2006-08-01 10:30:00	IWM	ETF	68.48	68.69	68.35	68.35	2839500.0
2006-08-01 11:00:00	IWM	ETF	68.36	68.59	68.35	68.57	2261300.0
2006-08-01 11:30:00	IWM	ETF	68.57	68.7	68.49	68.62	890100.0
2006-08-01 12:00:00	IWM	ETF	68.63	68.76	68.58	68.69	2065400.0
2006-08-01 12:30:00	IWM	ETF	68.7	68.74	68.57	68.69	763700.0
2006-08-01 13:00:00	IWM	ETF	68.7	68.72	68.49	68.51	1639000.0
2006-08-01 13:30:00	IWM	ETF	68.51	68.59	68.44	68.58	988700.0

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

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