PREVIEW / etf_1hour / 2008-10-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	94.13	94.48	93.97	94.05	15970.0
2008-10-13 05:00:00	SPY	ETF	93.88	93.88	93.2	93.45	9400.0
2008-10-13 06:00:00	SPY	ETF	93.6	93.95	93.25	93.3	356200.0
2008-10-13 07:00:00	SPY	ETF	93.31	93.4	92.65	92.93	1792034.0
2008-10-13 08:00:00	SPY	ETF	93.75	93.8	91.65	93.44	4965442.0
2008-10-13 09:00:00	SPY	ETF	93.42	94.67	93.23	93.8	63784661.0
2008-10-13 10:00:00	SPY	ETF	93.8	95.26	89.9484	94.86	63735671.0
2008-10-13 11:00:00	SPY	ETF	94.86	95.71	94.72	95.33	44525018.0
2008-10-13 12:00:00	SPY	ETF	95.33	96.53	95.1	96.28	34067323.0
2008-10-13 13:00:00	SPY	ETF	96.26	96.55	95.74	95.78	33348853.0
2008-10-13 14:00:00	SPY	ETF	95.78	96.83	95.09	96.71	49625760.0
2008-10-13 15:00:00	SPY	ETF	96.71	101.01	96.67	100.86	113568226.0
2008-10-13 16:00:00	SPY	ETF	100.7	101.35	89.9484	101.0	32405861.0
2008-10-13 17:00:00	SPY	ETF	101.0	101.47	89.9479	101.2	9238644.0
2008-10-13 18:00:00	SPY	ETF	101.2	101.49	100.93	101.48	1370261.0
2008-10-13 19:00:00	SPY	ETF	101.45	103.35	101.41	103.34	354192.0
2008-10-13 04:00:00	QQQ	ETF	32.92	33.17	32.92	33.17	11460.0
2008-10-13 05:00:00	QQQ	ETF	33.01	33.01	32.85	32.89	4500.0
2008-10-13 06:00:00	QQQ	ETF	32.94	33.02	32.7	32.7	20555.0
2008-10-13 07:00:00	QQQ	ETF	32.75	32.85	32.58	32.75	383433.0
2008-10-13 08:00:00	QQQ	ETF	32.75	32.93	32.35	32.85	2125632.0
2008-10-13 09:00:00	QQQ	ETF	32.85	33.03	32.47	32.6774	39345519.0
2008-10-13 10:00:00	QQQ	ETF	32.67	33.15	32.4	33.0	46917012.0
2008-10-13 11:00:00	QQQ	ETF	33.0	33.3	32.93	33.221	25416199.0
2008-10-13 12:00:00	QQQ	ETF	33.21	33.67	33.17	33.54	22784368.0
2008-10-13 13:00:00	QQQ	ETF	33.55	33.71	33.33	33.3505	26825788.0
2008-10-13 14:00:00	QQQ	ETF	33.36	33.78	33.14	33.77	31258986.0
2008-10-13 15:00:00	QQQ	ETF	33.76	35.14	33.76	35.14	63418583.0
2008-10-13 16:00:00	QQQ	ETF	35.15	35.73	33.447	35.64	13056119.0
2008-10-13 17:00:00	QQQ	ETF	35.65	35.7	35.56	35.64	420609.0
2008-10-13 18:00:00	QQQ	ETF	35.65	35.77	35.55	35.7	341642.0
2008-10-13 19:00:00	QQQ	ETF	35.69	36.18	35.69	36.13	265093.0
2008-10-13 07:00:00	IWM	ETF	54.34	54.55	53.01	54.34	138592.0
2008-10-13 08:00:00	IWM	ETF	54.75	54.75	53.94	54.27	562474.0
2008-10-13 09:00:00	IWM	ETF	54.3	54.85	54.0	54.41	13891422.0
2008-10-13 10:00:00	IWM	ETF	54.41	54.85	53.72	54.46	18709802.0
2008-10-13 11:00:00	IWM	ETF	54.46	55.09	52.45	54.92	12162832.0
2008-10-13 12:00:00	IWM	ETF	54.93	55.64	54.86	55.32	9330815.0
2008-10-13 13:00:00	IWM	ETF	55.33	55.53	55.07	55.08	15159124.0
2008-10-13 14:00:00	IWM	ETF	55.08	55.5	54.19	55.07	19987750.0
2008-10-13 15:00:00	IWM	ETF	55.07	57.01	55.05	57.01	25024912.0
2008-10-13 16:00:00	IWM	ETF	57.02	58.24	54.66	58.24	5494487.0
2008-10-13 17:00:00	IWM	ETF	57.49	57.5	52.19	52.19	6690315.0
2008-10-13 18:00:00	IWM	ETF	57.22	57.55	52.19	57.52	1003625.0
2008-10-13 19:00:00	IWM	ETF	57.56	57.75	57.22	57.75	1300.0
2008-10-13 04:00:00	DIA	ETF	85.88	85.88	85.88	85.88	100.0
2008-10-13 07:00:00	DIA	ETF	87.0	87.52	86.77	87.14	105463.0
2008-10-13 08:00:00	DIA	ETF	87.11	87.62	86.66	87.46	218238.0
2008-10-13 09:00:00	DIA	ETF	87.47	89.19	87.28	88.0	5925160.0
2008-10-13 10:00:00	DIA	ETF	87.99	89.49	87.46	89.18	6543373.0

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

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