PREVIEW / etf_1hour / 2008-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-08.parquet
  size:    119 KB
  rows:    3,873

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-08 04:00:00	SPY	ETF	96.86	98.07	96.4	98.07	14900.0
2008-10-08 05:00:00	SPY	ETF	98.1	98.1	96.86	97.6	43700.0
2008-10-08 06:00:00	SPY	ETF	97.7	99.56	97.52	98.96	646538.0
2008-10-08 07:00:00	SPY	ETF	99.12	104.98	99.12	103.15	9734082.0
2008-10-08 08:00:00	SPY	ETF	103.14	104.0	97.65	98.63	30262955.0
2008-10-08 09:00:00	SPY	ETF	98.66	101.92	96.41	101.17	112992008.0
2008-10-08 10:00:00	SPY	ETF	101.05	102.12	97.88	98.81	106817226.0
2008-10-08 11:00:00	SPY	ETF	98.81	100.07	97.39	98.57	80651478.0
2008-10-08 12:00:00	SPY	ETF	98.56	99.6272	96.98	97.97	62941699.0
2008-10-08 13:00:00	SPY	ETF	97.97	101.64	97.94	101.42	94499394.0
2008-10-08 14:00:00	SPY	ETF	101.42	102.18	100.28	101.21	75611597.0
2008-10-08 15:00:00	SPY	ETF	101.2	102.17	98.15	98.4	108771889.0
2008-10-08 16:00:00	SPY	ETF	98.35	101.2333	96.75	96.9	39570618.0
2008-10-08 17:00:00	SPY	ETF	96.9	99.1	96.75	97.19	1026474.0
2008-10-08 18:00:00	SPY	ETF	97.11	97.54	97.06	97.5	393684.0
2008-10-08 19:00:00	SPY	ETF	97.49	97.83	97.15	97.24	123252.0
2008-10-08 04:00:00	QQQ	ETF	31.88	32.0	31.75	32.0	1890.0
2008-10-08 05:00:00	QQQ	ETF	31.89	31.92	31.6	31.89	18700.0
2008-10-08 06:00:00	QQQ	ETF	31.84	32.45	31.84	32.24	19900.0
2008-10-08 07:00:00	QQQ	ETF	32.31	34.2	32.31	33.39	5202765.0
2008-10-08 08:00:00	QQQ	ETF	33.5729	33.7	31.84	32.15	13621870.0
2008-10-08 09:00:00	QQQ	ETF	32.15	33.77	31.35	33.46	76777084.0
2008-10-08 10:00:00	QQQ	ETF	33.47	33.89	32.38	32.8	83857580.0
2008-10-08 11:00:00	QQQ	ETF	32.81	33.4	32.45	32.84	52213795.0
2008-10-08 12:00:00	QQQ	ETF	32.84	32.86	31.99	32.64	43264412.0
2008-10-08 13:00:00	QQQ	ETF	32.64	33.89	32.63	33.83	51247277.0
2008-10-08 14:00:00	QQQ	ETF	33.83	34.12	33.34	33.6	45271299.0
2008-10-08 15:00:00	QQQ	ETF	33.6	33.98	32.63	32.67	65931841.0
2008-10-08 16:00:00	QQQ	ETF	32.62	33.0	32.05	32.17	7317554.0
2008-10-08 17:00:00	QQQ	ETF	32.15	32.3	32.1	32.28	83668.0
2008-10-08 18:00:00	QQQ	ETF	32.23	32.54	32.22	32.44	545836.0
2008-10-08 19:00:00	QQQ	ETF	32.44	32.62	32.4	32.5	131715.0
2008-10-08 07:00:00	IWM	ETF	56.0	57.6	56.0	57.12	598972.0
2008-10-08 08:00:00	IWM	ETF	57.12	57.34	53.97	54.72	1380421.0
2008-10-08 09:00:00	IWM	ETF	54.71	56.5	53.03	56.19	27416032.0
2008-10-08 10:00:00	IWM	ETF	56.13	56.66	54.53	55.08	24335293.0
2008-10-08 11:00:00	IWM	ETF	55.07	56.02	54.38	55.0	21312873.0
2008-10-08 12:00:00	IWM	ETF	55.0	55.01	53.51	54.41	18827085.0
2008-10-08 13:00:00	IWM	ETF	54.4	56.66	54.4	56.57	23326407.0
2008-10-08 14:00:00	IWM	ETF	56.55	56.95	55.98	56.57	16575084.0
2008-10-08 15:00:00	IWM	ETF	56.56	56.81	54.37	54.42	29064360.0
2008-10-08 16:00:00	IWM	ETF	54.42	55.82	53.8	55.82	5075116.0
2008-10-08 17:00:00	IWM	ETF	55.82	55.82	53.65	54.05	1013227.0
2008-10-08 18:00:00	IWM	ETF	54.0	54.0	54.0	54.0	2000.0
2008-10-08 19:00:00	IWM	ETF	54.35	54.35	53.8	53.8	12800.0
2008-10-08 07:00:00	DIA	ETF	95.9	97.0	95.26	97.0	82494.0
2008-10-08 08:00:00	DIA	ETF	97.0	97.39	93.1	93.8	741445.0
2008-10-08 09:00:00	DIA	ETF	93.77	96.28	92.3	95.66	5720980.0
2008-10-08 10:00:00	DIA	ETF	95.56	96.39	92.63	93.43	8832917.0
2008-10-08 11:00:00	DIA	ETF	93.43	94.48	92.46	93.43	6331119.0

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

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