PREVIEW / etf_1hour / 2008-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-28.parquet
  size:    114 KB
  rows:    3,789

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
2008-10-28 04:00:00	SPY	ETF	87.71	87.96	86.5	86.5	8600.0
2008-10-28 05:00:00	SPY	ETF	86.7	87.3	86.7	87.15	98600.0
2008-10-28 06:00:00	SPY	ETF	87.09	87.3	86.7	86.95	474100.0
2008-10-28 07:00:00	SPY	ETF	86.88	88.04	86.84	87.78	2338315.0
2008-10-28 08:00:00	SPY	ETF	87.78	87.91	84.0	87.36	3490489.0
2008-10-28 09:00:00	SPY	ETF	87.36	88.31	86.84	87.7	53648853.0
2008-10-28 10:00:00	SPY	ETF	87.86	87.91	84.53	84.85	89636637.0
2008-10-28 11:00:00	SPY	ETF	84.85	86.68	84.81	85.94	115481258.0
2008-10-28 12:00:00	SPY	ETF	85.93	87.0	85.62	86.83	32884796.0
2008-10-28 13:00:00	SPY	ETF	86.84	87.71	84.95	86.25	57664391.0
2008-10-28 14:00:00	SPY	ETF	86.24	90.06	86.19	89.62	78102804.0
2008-10-28 15:00:00	SPY	ETF	89.62	94.2	86.84	94.0	160246270.0
2008-10-28 16:00:00	SPY	ETF	94.01	94.24	84.8968	93.35	38798341.0
2008-10-28 17:00:00	SPY	ETF	93.35	94.083	87.64	93.68	4959720.0
2008-10-28 18:00:00	SPY	ETF	93.67	93.73	92.95	93.33	417780.0
2008-10-28 19:00:00	SPY	ETF	93.31	93.65	93.24	93.48	110330.0
2008-10-28 04:00:00	QQQ	ETF	29.82	29.9	29.41	29.41	6800.0
2008-10-28 05:00:00	QQQ	ETF	29.38	29.8	29.38	29.75	6000.0
2008-10-28 06:00:00	QQQ	ETF	29.73	29.85	29.57	29.62	8300.0
2008-10-28 07:00:00	QQQ	ETF	29.57	30.0	29.53	29.98	1053236.0
2008-10-28 08:00:00	QQQ	ETF	29.98	29.98	29.2	29.73	1989932.0
2008-10-28 09:00:00	QQQ	ETF	29.74	29.99	29.48	29.82	27924349.0
2008-10-28 10:00:00	QQQ	ETF	29.82	29.84	28.85	28.95	59057709.0
2008-10-28 11:00:00	QQQ	ETF	28.94	29.47	28.94	29.23	34658105.0
2008-10-28 12:00:00	QQQ	ETF	29.22	29.51	29.1	29.4	19422301.0
2008-10-28 13:00:00	QQQ	ETF	29.41	29.72	29.28	29.37	20123947.0
2008-10-28 14:00:00	QQQ	ETF	29.37	30.48	29.33	30.37	43243325.0
2008-10-28 15:00:00	QQQ	ETF	30.37	31.87	30.17	31.86	99024605.0
2008-10-28 16:00:00	QQQ	ETF	31.86	32.05	29.41	31.79	14365104.0
2008-10-28 17:00:00	QQQ	ETF	31.76	31.92	28.7586	31.81	3080067.0
2008-10-28 18:00:00	QQQ	ETF	31.81	31.81	31.53	31.72	155937.0
2008-10-28 19:00:00	QQQ	ETF	31.73	31.75	31.66	31.7	94577.0
2008-10-28 06:00:00	IWM	ETF	46.0	46.0	45.8	45.8	1000.0
2008-10-28 07:00:00	IWM	ETF	45.8	46.45	45.8	46.31	143274.0
2008-10-28 08:00:00	IWM	ETF	46.32	46.32	45.84	46.0	414157.0
2008-10-28 09:00:00	IWM	ETF	46.0	46.3	45.68	45.89	12883640.0
2008-10-28 10:00:00	IWM	ETF	45.91	45.91	44.13	44.34	17604887.0
2008-10-28 11:00:00	IWM	ETF	44.34	44.72	44.17	44.32	11198121.0
2008-10-28 12:00:00	IWM	ETF	44.33	44.98	44.08	44.88	8359376.0
2008-10-28 13:00:00	IWM	ETF	44.87	45.43	44.61	44.69	7844168.0
2008-10-28 14:00:00	IWM	ETF	44.69	46.56	44.67	46.37	15841728.0
2008-10-28 15:00:00	IWM	ETF	46.37	48.49	45.97	48.49	32374331.0
2008-10-28 16:00:00	IWM	ETF	48.43	48.92	44.83	48.1	6246542.0
2008-10-28 17:00:00	IWM	ETF	48.1	48.2	48.1	48.2	500.0
2008-10-28 18:00:00	IWM	ETF	48.2	48.2	48.2	48.2	600.0
2008-10-28 19:00:00	IWM	ETF	48.2	48.2	48.2	48.2	401.0
2008-10-28 07:00:00	DIA	ETF	83.0	84.45	83.0	84.23	11543.0
2008-10-28 08:00:00	DIA	ETF	83.7	84.1	83.45	83.69	158317.0
2008-10-28 09:00:00	DIA	ETF	83.76	85.06	83.33	84.48	4504389.0
2008-10-28 10:00:00	DIA	ETF	84.69	84.69	81.7	82.03	9589089.0

> showing 50 of 3,789 rows — these rows as CSV

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