PREVIEW / etf_1hour / 2009-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-02.parquet
  size:    124 KB
  rows:    3,817

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-02-02 04:00:00	SPY	ETF	81.54	81.57	81.17	81.24	3139.0
2009-02-02 05:00:00	SPY	ETF	81.46	81.51	81.14	81.14	1918.0
2009-02-02 06:00:00	SPY	ETF	81.24	81.7	81.24	81.68	15088.0
2009-02-02 07:00:00	SPY	ETF	81.69	81.81	81.28	81.46	694888.0
2009-02-02 08:00:00	SPY	ETF	81.43	83.0	81.15	81.31	2964799.0
2009-02-02 09:00:00	SPY	ETF	81.31	82.9	81.18	81.67	28434278.0
2009-02-02 10:00:00	SPY	ETF	81.67	82.6	81.63	82.19	56523946.0
2009-02-02 11:00:00	SPY	ETF	82.19	82.47	81.83	82.31	30417274.0
2009-02-02 12:00:00	SPY	ETF	82.33	83.14	82.32	82.97	32237820.0
2009-02-02 13:00:00	SPY	ETF	82.97	83.03	81.94	82.01	29061208.0
2009-02-02 14:00:00	SPY	ETF	82.02	82.2	81.71	81.81	30049602.0
2009-02-02 15:00:00	SPY	ETF	81.81	83.18	81.71	82.59	57440709.0
2009-02-02 16:00:00	SPY	ETF	82.56	82.6747	82.44	82.55	15597564.0
2009-02-02 17:00:00	SPY	ETF	82.54	82.6	82.51	82.54	158893.0
2009-02-02 18:00:00	SPY	ETF	82.53	82.55	82.29	82.52	410573.0
2009-02-02 19:00:00	SPY	ETF	82.54	82.76	82.53	82.76	75279.0
2009-02-02 04:00:00	QQQ	ETF	28.63	28.63	28.48	28.5	5346.0
2009-02-02 05:00:00	QQQ	ETF	28.6	28.6	28.45	28.45	1822.0
2009-02-02 06:00:00	QQQ	ETF	28.53	28.55	28.5	28.5	16000.0
2009-02-02 07:00:00	QQQ	ETF	28.6	28.65	28.51	28.58	345752.0
2009-02-02 08:00:00	QQQ	ETF	28.58	28.73	28.58	28.62	1240226.0
2009-02-02 09:00:00	QQQ	ETF	28.63	29.01	28.62	28.9501	15472077.0
2009-02-02 10:00:00	QQQ	ETF	28.95	29.43	28.95	29.22	25599344.0
2009-02-02 11:00:00	QQQ	ETF	29.21	29.32	29.13	29.25	11734180.0
2009-02-02 12:00:00	QQQ	ETF	29.25	29.5	29.25	29.4497	16602524.0
2009-02-02 13:00:00	QQQ	ETF	29.45	29.46	29.09	29.14	12820011.0
2009-02-02 14:00:00	QQQ	ETF	29.14	29.19	29.02	29.09	9585676.0
2009-02-02 15:00:00	QQQ	ETF	29.09	29.61	29.04	29.4	29147903.0
2009-02-02 16:00:00	QQQ	ETF	29.41	29.4208	29.25	29.31	3537952.0
2009-02-02 17:00:00	QQQ	ETF	29.31	29.33	29.29	29.3	29558.0
2009-02-02 18:00:00	QQQ	ETF	29.29	29.29	29.23	29.24	45368.0
2009-02-02 19:00:00	QQQ	ETF	29.25	29.33	29.25	29.33	57919.0
2009-02-02 05:00:00	IWM	ETF	43.64	43.64	43.63	43.63	2000.0
2009-02-02 06:00:00	IWM	ETF	43.7	43.7	43.7	43.7	155.0
2009-02-02 07:00:00	IWM	ETF	43.82	43.83	43.59	43.65	32942.0
2009-02-02 08:00:00	IWM	ETF	43.67	43.78	43.53	43.57	175954.0
2009-02-02 09:00:00	IWM	ETF	43.57	44.08	43.55	43.83	5187514.0
2009-02-02 10:00:00	IWM	ETF	43.83	44.63	43.7713	44.2578	11855315.0
2009-02-02 11:00:00	IWM	ETF	44.25	44.55	43.95	44.38	5711904.0
2009-02-02 12:00:00	IWM	ETF	44.39	44.76	44.29	44.67	7210554.0
2009-02-02 13:00:00	IWM	ETF	44.67	44.69	44.19	44.26	4979797.0
2009-02-02 14:00:00	IWM	ETF	44.26	44.38	44.123	44.21	4225996.0
2009-02-02 15:00:00	IWM	ETF	44.22	45.14	44.18	44.84	16484537.0
2009-02-02 16:00:00	IWM	ETF	44.85	44.9935	44.2945	44.9	1883019.0
2009-02-02 18:00:00	IWM	ETF	44.81	44.81	44.81	44.81	100.0
2009-02-02 06:00:00	DIA	ETF	79.08	79.08	79.08	79.08	2000.0
2009-02-02 07:00:00	DIA	ETF	79.17	79.2	78.85	78.98	13810.0
2009-02-02 08:00:00	DIA	ETF	79.0	79.14	78.77	78.92	99011.0
2009-02-02 09:00:00	DIA	ETF	78.95	79.21	78.78	78.9822	3084189.0
2009-02-02 10:00:00	DIA	ETF	78.98	79.665	78.98	79.23	4168290.0

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

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