PREVIEW / etf_1hour / 2008-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-07.parquet
  size:    112 KB
  rows:    3,665

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-07 04:00:00	SPY	ETF	92.56	92.59	92.21	92.21	11500.0
2008-11-07 05:00:00	SPY	ETF	92.26	92.69	92.23	92.64	9300.0
2008-11-07 06:00:00	SPY	ETF	92.6	92.6	91.73	91.91	297907.0
2008-11-07 07:00:00	SPY	ETF	91.91	92.05	91.45	91.65	1507198.0
2008-11-07 08:00:00	SPY	ETF	91.76	92.75	90.6	90.68	17099156.0
2008-11-07 09:00:00	SPY	ETF	90.69	92.0	90.5	91.29	42975007.0
2008-11-07 10:00:00	SPY	ETF	91.3	93.39	91.29	92.54	65363455.0
2008-11-07 11:00:00	SPY	ETF	92.54	92.69	91.45	92.55	52832632.0
2008-11-07 12:00:00	SPY	ETF	92.56	92.91	91.96	92.6	25707142.0
2008-11-07 13:00:00	SPY	ETF	92.6	92.84	92.12	92.68	22525584.0
2008-11-07 14:00:00	SPY	ETF	92.68	93.28	91.65	91.76	47330454.0
2008-11-07 15:00:00	SPY	ETF	91.76	93.41	91.13	93.21	82124559.0
2008-11-07 16:00:00	SPY	ETF	93.19	94.04	92.7	93.8	19863896.0
2008-11-07 17:00:00	SPY	ETF	93.78	94.11	90.7	93.77	2319154.0
2008-11-07 18:00:00	SPY	ETF	93.77	94.74	93.77	94.6	139416.0
2008-11-07 19:00:00	SPY	ETF	94.44	94.51	94.16	94.16	42879.0
2008-11-07 04:00:00	QQQ	ETF	31.07	31.09	31.04	31.04	4400.0
2008-11-07 05:00:00	QQQ	ETF	31.07	31.26	31.06	31.26	11500.0
2008-11-07 06:00:00	QQQ	ETF	31.22	31.28	31.15	31.15	2600.0
2008-11-07 07:00:00	QQQ	ETF	31.15	31.15	31.02	31.06	486277.0
2008-11-07 08:00:00	QQQ	ETF	31.05	31.15	30.69	30.71	6052290.0
2008-11-07 09:00:00	QQQ	ETF	30.71	31.07	30.59	30.8	25720363.0
2008-11-07 10:00:00	QQQ	ETF	30.8	31.48	30.8	31.23	32812848.0
2008-11-07 11:00:00	QQQ	ETF	31.24	31.27	30.86	31.2299	24109868.0
2008-11-07 12:00:00	QQQ	ETF	31.22	31.34	31.07	31.25	11526882.0
2008-11-07 13:00:00	QQQ	ETF	31.25	31.34	31.07	31.2505	8580119.0
2008-11-07 14:00:00	QQQ	ETF	31.26	31.44	30.91	30.92	19660489.0
2008-11-07 15:00:00	QQQ	ETF	30.93	31.27	30.71	31.24	40296132.0
2008-11-07 16:00:00	QQQ	ETF	31.23	31.69	30.9049	31.46	5871467.0
2008-11-07 17:00:00	QQQ	ETF	31.19	31.48	31.19	31.45	103902.0
2008-11-07 18:00:00	QQQ	ETF	31.46	31.59	31.45	31.59	26603.0
2008-11-07 19:00:00	QQQ	ETF	31.58	31.58	31.49	31.53	12535.0
2008-11-07 07:00:00	IWM	ETF	50.13	50.31	50.13	50.31	28200.0
2008-11-07 08:00:00	IWM	ETF	50.32	50.8	49.75	49.8	997090.0
2008-11-07 09:00:00	IWM	ETF	49.8	50.46	49.58	49.94	7289854.0
2008-11-07 10:00:00	IWM	ETF	49.94	51.07	49.93	50.52	11894587.0
2008-11-07 11:00:00	IWM	ETF	50.54	50.58	49.81	50.36	7936641.0
2008-11-07 12:00:00	IWM	ETF	50.35	50.52	49.97	50.23	3545116.0
2008-11-07 13:00:00	IWM	ETF	50.23	50.36	50.0	50.34	4067991.0
2008-11-07 14:00:00	IWM	ETF	50.34	50.62	49.72	49.75	7861393.0
2008-11-07 15:00:00	IWM	ETF	49.76	50.68	49.31	50.6	15434684.0
2008-11-07 16:00:00	IWM	ETF	50.59	51.33	50.55	50.9	1577507.0
2008-11-07 17:00:00	IWM	ETF	51.02	51.09	50.97	50.97	4104.0
2008-11-07 19:00:00	IWM	ETF	51.1	51.1	51.1	51.1	100.0
2008-11-07 06:00:00	DIA	ETF	88.28	88.47	88.28	88.35	1550.0
2008-11-07 07:00:00	DIA	ETF	88.33	88.39	87.99	88.0	12650.0
2008-11-07 08:00:00	DIA	ETF	88.07	88.25	87.09	87.13	121086.0
2008-11-07 09:00:00	DIA	ETF	87.19	88.45	86.99	87.79	3877313.0
2008-11-07 10:00:00	DIA	ETF	87.79	89.47	87.73	88.89	6098988.0
2008-11-07 11:00:00	DIA	ETF	88.89	89.0	87.87	88.93	4707237.0

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

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