PREVIEW / etf_1hour / 2008-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-05.parquet
  size:    115 KB
  rows:    3,753

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-11-05 04:00:00	SPY	ETF	98.64	99.02	98.56	98.66	5926.0
2008-11-05 05:00:00	SPY	ETF	98.77	99.02	98.41	98.88	39900.0
2008-11-05 06:00:00	SPY	ETF	99.04	99.84	98.99	99.75	202600.0
2008-11-05 07:00:00	SPY	ETF	99.68	99.83	98.97	99.35	1265008.0
2008-11-05 08:00:00	SPY	ETF	99.35	100.5	98.738	99.32	4933701.0
2008-11-05 09:00:00	SPY	ETF	99.32	99.4	98.55	98.97	43368370.0
2008-11-05 10:00:00	SPY	ETF	98.97	100.2	98.78	99.5001	58953173.0
2008-11-05 11:00:00	SPY	ETF	99.51	99.75	98.44	98.87	43009967.0
2008-11-05 12:00:00	SPY	ETF	98.87	100.41	97.14	97.66	44854323.0
2008-11-05 13:00:00	SPY	ETF	97.66	97.95	97.09	97.36	32534557.0
2008-11-05 14:00:00	SPY	ETF	97.35	97.91	96.87	97.37	43300493.0
2008-11-05 15:00:00	SPY	ETF	97.36	100.7114	95.0	95.44	94588131.0
2008-11-05 16:00:00	SPY	ETF	95.5	100.7114	94.89	94.97	19403729.0
2008-11-05 17:00:00	SPY	ETF	94.99	95.04	94.75	94.8	612759.0
2008-11-05 18:00:00	SPY	ETF	94.85	100.711	94.63	95.04	2376371.0
2008-11-05 19:00:00	SPY	ETF	95.0	95.05	94.76	94.78	100548.0
2008-11-05 04:00:00	QQQ	ETF	33.42	33.48	33.41	33.43	6800.0
2008-11-05 05:00:00	QQQ	ETF	33.42	33.42	33.42	33.42	500.0
2008-11-05 06:00:00	QQQ	ETF	33.53	33.75	33.52	33.75	6000.0
2008-11-05 07:00:00	QQQ	ETF	33.68	33.74	33.48	33.52	252875.0
2008-11-05 08:00:00	QQQ	ETF	33.51	33.56	33.33	33.47	1653616.0
2008-11-05 09:00:00	QQQ	ETF	33.47	33.6	33.28	33.3401	20614540.0
2008-11-05 10:00:00	QQQ	ETF	33.35	33.6	33.29	33.348	26441453.0
2008-11-05 11:00:00	QQQ	ETF	33.36	33.5	33.05	33.14	20364168.0
2008-11-05 12:00:00	QQQ	ETF	33.15	33.1801	32.53	32.8	22467903.0
2008-11-05 13:00:00	QQQ	ETF	32.81	32.84	32.54	32.57	13392895.0
2008-11-05 14:00:00	QQQ	ETF	32.57	32.74	32.38	32.63	19949628.0
2008-11-05 15:00:00	QQQ	ETF	32.63	32.76	31.92	31.98	44092447.0
2008-11-05 16:00:00	QQQ	ETF	31.98	32.6347	31.39	31.44	10688328.0
2008-11-05 17:00:00	QQQ	ETF	31.42	31.99	31.28	31.34	1684695.0
2008-11-05 18:00:00	QQQ	ETF	31.35	31.51	31.34	31.5	103642.0
2008-11-05 19:00:00	QQQ	ETF	31.5	31.52	31.44	31.49	80379.0
2008-11-05 04:00:00	IWM	ETF	53.83	53.83	53.83	53.83	1000.0
2008-11-05 06:00:00	IWM	ETF	54.05	54.05	54.05	54.05	100.0
2008-11-05 07:00:00	IWM	ETF	53.95	54.03	53.8	54.02	31700.0
2008-11-05 08:00:00	IWM	ETF	54.0	54.15	53.73	54.0	1216583.0
2008-11-05 09:00:00	IWM	ETF	53.98	54.07	53.3	53.6	10473489.0
2008-11-05 10:00:00	IWM	ETF	53.6	54.29	53.48	53.84	11658052.0
2008-11-05 11:00:00	IWM	ETF	53.84	54.0	53.37	53.56	8198843.0
2008-11-05 12:00:00	IWM	ETF	53.56	54.44	52.67	53.04	8752174.0
2008-11-05 13:00:00	IWM	ETF	53.04	53.19	52.77	52.93	4728040.0
2008-11-05 14:00:00	IWM	ETF	52.9	53.12	52.56	52.86	5904064.0
2008-11-05 15:00:00	IWM	ETF	52.86	53.17	51.31	51.57	18733657.0
2008-11-05 16:00:00	IWM	ETF	51.56	52.05	51.11	51.11	3387315.0
2008-11-05 17:00:00	IWM	ETF	51.11	51.59	51.0	51.0	65180.0
2008-11-05 18:00:00	IWM	ETF	51.0	51.1	51.0	51.1	800.0
2008-11-05 19:00:00	IWM	ETF	51.1	51.33	51.1	51.32	1200.0
2008-11-05 07:00:00	DIA	ETF	95.62	95.64	94.88	95.19	20752.0
2008-11-05 08:00:00	DIA	ETF	95.2	95.34	94.75	95.26	46816.0
2008-11-05 09:00:00	DIA	ETF	95.16	95.19	94.26	94.52	3481931.0

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

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