PREVIEW / etf_1hour / 2007-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-26.parquet
  size:    96 KB
  rows:    3,201

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
2007-11-26 04:00:00	SPY	ETF	145.2	145.2	145.13	145.13	1600.0
2007-11-26 05:00:00	SPY	ETF	144.84	145.11	144.84	145.11	3300.0
2007-11-26 06:00:00	SPY	ETF	145.05	145.06	144.79	144.9	53300.0
2007-11-26 07:00:00	SPY	ETF	144.95	144.95	144.45	144.48	1027100.0
2007-11-26 08:00:00	SPY	ETF	144.49	145.15	144.03	144.32	2958500.0
2007-11-26 09:00:00	SPY	ETF	144.32	144.83	143.91	144.82	25283053.0
2007-11-26 10:00:00	SPY	ETF	144.83	144.88	143.39	143.42	38083090.0
2007-11-26 11:00:00	SPY	ETF	143.41	143.76	143.18	143.4	19947941.0
2007-11-26 12:00:00	SPY	ETF	143.4	144.12	143.32	143.98	18552165.0
2007-11-26 13:00:00	SPY	ETF	143.99	144.12	143.0	143.19	17313172.0
2007-11-26 14:00:00	SPY	ETF	143.19	143.5	142.72	142.74	21716470.0
2007-11-26 15:00:00	SPY	ETF	142.74	142.77	140.78	140.8	56457094.0
2007-11-26 16:00:00	SPY	ETF	140.81	144.94	140.66	141.0	3163100.0
2007-11-26 17:00:00	SPY	ETF	140.98	141.0	140.88	140.95	4509300.0
2007-11-26 18:00:00	SPY	ETF	140.9	140.9	140.69	140.9	73800.0
2007-11-26 19:00:00	SPY	ETF	140.9	140.95	140.79	140.89	58900.0
2007-11-26 06:00:00	QQQ	ETF	50.1	50.1	50.1	50.1	100.0
2007-11-26 07:00:00	QQQ	ETF	50.1	50.12	49.98	50.02	461564.0
2007-11-26 08:00:00	QQQ	ETF	50.02	50.3	49.85	49.94	1736027.0
2007-11-26 09:00:00	QQQ	ETF	49.94	50.34	49.84	50.34	12082325.0
2007-11-26 10:00:00	QQQ	ETF	50.33	50.37	49.82	49.86	18797684.0
2007-11-26 11:00:00	QQQ	ETF	49.87	50.01	49.58	49.69	16436657.0
2007-11-26 12:00:00	QQQ	ETF	49.7	50.08	49.69	50.032	11908019.0
2007-11-26 13:00:00	QQQ	ETF	50.0301	50.09	49.71	49.78	13460096.0
2007-11-26 14:00:00	QQQ	ETF	49.78	49.93	49.62	49.62	26846250.0
2007-11-26 15:00:00	QQQ	ETF	49.63	49.65	48.9	48.95	42794645.0
2007-11-26 16:00:00	QQQ	ETF	48.95	49.1	48.92	49.08	4993653.0
2007-11-26 17:00:00	QQQ	ETF	49.08	49.08	49.02	49.05	53007.0
2007-11-26 18:00:00	QQQ	ETF	49.05	49.05	48.97	49.0	629468.0
2007-11-26 19:00:00	QQQ	ETF	48.98	49.01	48.96	49.0	152569.0
2007-11-26 04:00:00	IWM	ETF	75.7	75.7	75.7	75.7	200.0
2007-11-26 05:00:00	IWM	ETF	75.73	75.73	75.73	75.73	600.0
2007-11-26 06:00:00	IWM	ETF	75.56	75.56	75.56	75.56	400.0
2007-11-26 07:00:00	IWM	ETF	75.54	75.54	75.22	75.22	83500.0
2007-11-26 08:00:00	IWM	ETF	75.22	75.39	75.1	75.23	222500.0
2007-11-26 09:00:00	IWM	ETF	75.23	75.62	75.08	75.58	9182146.0
2007-11-26 10:00:00	IWM	ETF	75.59	75.61	74.54	74.55	14983400.0
2007-11-26 11:00:00	IWM	ETF	74.55	74.82	74.32	74.51	8381700.0
2007-11-26 12:00:00	IWM	ETF	74.52	74.95	74.4	74.9	5467700.0
2007-11-26 13:00:00	IWM	ETF	74.89	74.94	74.27	74.38	5566100.0
2007-11-26 14:00:00	IWM	ETF	74.36	74.51	73.95	73.96	16055000.0
2007-11-26 15:00:00	IWM	ETF	73.96	74.0	73.12	73.13	26258400.0
2007-11-26 16:00:00	IWM	ETF	73.13	75.86	72.9	72.98	10781200.0
2007-11-26 17:00:00	IWM	ETF	73.0	73.1	72.92	73.1	2100.0
2007-11-26 18:00:00	IWM	ETF	72.96	73.02	72.88	72.88	22300.0
2007-11-26 19:00:00	IWM	ETF	72.85	72.85	72.85	72.85	3100.0
2007-11-26 07:00:00	DIA	ETF	129.98	130.01	129.81	129.87	7700.0
2007-11-26 08:00:00	DIA	ETF	129.84	129.97	129.49	129.56	18800.0
2007-11-26 09:00:00	DIA	ETF	129.63	130.3	129.49	130.28	1316998.0
2007-11-26 10:00:00	DIA	ETF	130.31	130.32	129.42	129.45	1522600.0

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

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