PREVIEW / etf_1hour / 2009-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-25.parquet
  size:    144 KB
  rows:    4,471

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
2009-11-25 04:00:00	SPY	ETF	111.18	111.44	111.16	111.44	9200.0
2009-11-25 05:00:00	SPY	ETF	111.34	111.37	111.14	111.18	8850.0
2009-11-25 06:00:00	SPY	ETF	111.14	111.37	111.14	111.34	1850.0
2009-11-25 07:00:00	SPY	ETF	111.31	111.39	111.18	111.35	284826.0
2009-11-25 08:00:00	SPY	ETF	111.34	111.61	111.19	111.33	3451196.0
2009-11-25 09:00:00	SPY	ETF	111.33	111.36	110.82	111.015	16218459.0
2009-11-25 10:00:00	SPY	ETF	111.04	111.32	110.95	111.16	19320919.0
2009-11-25 11:00:00	SPY	ETF	111.16	111.48	111.145	111.37	11672867.0
2009-11-25 12:00:00	SPY	ETF	111.38	111.41	111.14	111.24	12658547.0
2009-11-25 13:00:00	SPY	ETF	111.24	111.32	111.2	111.31	5172555.0
2009-11-25 14:00:00	SPY	ETF	111.31	111.5	111.13	111.42	12694740.0
2009-11-25 15:00:00	SPY	ETF	111.425	111.47	111.28	111.37	15010678.0
2009-11-25 16:00:00	SPY	ETF	111.37	111.44	110.9354	111.38	12447215.0
2009-11-25 17:00:00	SPY	ETF	111.36	111.47	111.32	111.37	339540.0
2009-11-25 18:00:00	SPY	ETF	111.37	111.42	111.3	111.33	42833.0
2009-11-25 19:00:00	SPY	ETF	111.33	111.35	111.32	111.35	48968.0
2009-11-25 04:00:00	QQQ	ETF	44.15	44.2	44.14	44.2	670.0
2009-11-25 05:00:00	QQQ	ETF	44.19	44.19	44.19	44.19	3000.0
2009-11-25 06:00:00	QQQ	ETF	44.24	44.24	44.24	44.24	100.0
2009-11-25 07:00:00	QQQ	ETF	44.18	44.22	44.18	44.22	15300.0
2009-11-25 08:00:00	QQQ	ETF	44.21	44.31	44.17	44.22	929674.0
2009-11-25 09:00:00	QQQ	ETF	44.23	44.23	44.01	44.09	7137050.0
2009-11-25 10:00:00	QQQ	ETF	44.09	44.2	44.0617	44.1326	7968186.0
2009-11-25 11:00:00	QQQ	ETF	44.13	44.22	44.13	44.18	3774477.0
2009-11-25 12:00:00	QQQ	ETF	44.18	44.19	44.07	44.11	2964000.0
2009-11-25 13:00:00	QQQ	ETF	44.1	44.17	44.09	44.1675	1855651.0
2009-11-25 14:00:00	QQQ	ETF	44.16	44.21	44.11	44.1895	2553660.0
2009-11-25 15:00:00	QQQ	ETF	44.18	44.194	44.11	44.17	5195165.0
2009-11-25 16:00:00	QQQ	ETF	44.18	44.2103	44.16	44.19	2733892.0
2009-11-25 17:00:00	QQQ	ETF	44.19	44.2	44.18	44.18	37295.0
2009-11-25 18:00:00	QQQ	ETF	44.2	44.2	44.18	44.18	4300.0
2009-11-25 19:00:00	QQQ	ETF	44.18	44.19	44.17	44.19	8990.0
2009-11-25 06:00:00	IWM	ETF	59.81	59.81	59.69	59.69	3579.0
2009-11-25 07:00:00	IWM	ETF	59.67	59.74	59.67	59.74	9079.0
2009-11-25 08:00:00	IWM	ETF	59.74	59.92	59.63	59.77	584284.0
2009-11-25 09:00:00	IWM	ETF	59.79	59.82	59.31	59.47	5517456.0
2009-11-25 10:00:00	IWM	ETF	59.48	59.65	59.36	59.55	7117365.0
2009-11-25 11:00:00	IWM	ETF	59.545	59.679	59.53	59.54	4437627.0
2009-11-25 12:00:00	IWM	ETF	59.55	59.57	59.35	59.45	3306352.0
2009-11-25 13:00:00	IWM	ETF	59.45	59.52	59.35	59.432	4200886.0
2009-11-25 14:00:00	IWM	ETF	59.44	59.59	59.37	59.42	3640762.0
2009-11-25 15:00:00	IWM	ETF	59.42	59.42	59.26	59.32	9419099.0
2009-11-25 16:00:00	IWM	ETF	59.33	59.38	59.25	59.34	7823782.0
2009-11-25 17:00:00	IWM	ETF	59.33	59.35	59.33	59.34	10961.0
2009-11-25 18:00:00	IWM	ETF	59.33	59.35	59.33	59.35	594.0
2009-11-25 07:00:00	DIA	ETF	104.7	104.7	104.7	104.7	100.0
2009-11-25 08:00:00	DIA	ETF	104.56	104.88	104.56	104.65	133800.0
2009-11-25 09:00:00	DIA	ETF	104.62	104.68	104.2	104.37	1559733.0
2009-11-25 10:00:00	DIA	ETF	104.39	104.69	104.34	104.57	1757040.0
2009-11-25 11:00:00	DIA	ETF	104.58	104.84	104.57	104.7	804367.0

> showing 50 of 4,471 rows — these rows as CSV

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