PREVIEW / etf_1hour / 2008-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-03.parquet
  size:    109 KB
  rows:    3,498

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-06-03 04:00:00	SPY	ETF	138.8	138.8	138.8	138.8	100.0
2008-06-03 05:00:00	SPY	ETF	138.99	139.07	138.99	139.07	400.0
2008-06-03 06:00:00	SPY	ETF	139.12	139.12	138.73	138.89	82500.0
2008-06-03 07:00:00	SPY	ETF	138.76	139.18	138.76	139.18	590674.0
2008-06-03 08:00:00	SPY	ETF	139.16	139.37	138.45	139.15	1314674.0
2008-06-03 09:00:00	SPY	ETF	139.15	139.41	138.77	138.96	17526478.0
2008-06-03 10:00:00	SPY	ETF	138.96	139.6	138.94	139.31	33352344.0
2008-06-03 11:00:00	SPY	ETF	139.31	139.6	139.18	139.57	20466666.0
2008-06-03 12:00:00	SPY	ETF	139.575	139.62	138.98	139.06	15146493.0
2008-06-03 13:00:00	SPY	ETF	139.06	139.17	137.54	137.8895	48948783.0
2008-06-03 14:00:00	SPY	ETF	137.89	137.97	137.23	137.77	49048514.0
2008-06-03 15:00:00	SPY	ETF	137.77	138.63	137.58	138.05	71869004.0
2008-06-03 16:00:00	SPY	ETF	138.0299	138.85	137.0	138.06	11941486.0
2008-06-03 17:00:00	SPY	ETF	138.05	138.12	138.02	138.11	36182.0
2008-06-03 18:00:00	SPY	ETF	138.1	138.1	137.91	137.91	49443.0
2008-06-03 19:00:00	SPY	ETF	137.91	138.04	137.85	138.04	26941.0
2008-06-03 04:00:00	QQQ	ETF	49.4	49.4	49.4	49.4	100.0
2008-06-03 05:00:00	QQQ	ETF	49.44	49.5	49.44	49.5	1050.0
2008-06-03 06:00:00	QQQ	ETF	49.54	49.56	49.46	49.49	2100.0
2008-06-03 07:00:00	QQQ	ETF	49.41	49.54	49.41	49.54	109114.0
2008-06-03 08:00:00	QQQ	ETF	49.54	49.62	49.5	49.5	659416.0
2008-06-03 09:00:00	QQQ	ETF	49.51	49.61	49.44	49.56	12666479.0
2008-06-03 10:00:00	QQQ	ETF	49.57	49.9	49.57	49.72	19921940.0
2008-06-03 11:00:00	QQQ	ETF	49.73	49.88	49.71	49.82	10207896.0
2008-06-03 12:00:00	QQQ	ETF	49.82	49.83	49.54	49.58	9239398.0
2008-06-03 13:00:00	QQQ	ETF	49.58	49.64	48.87	49.0101	31470895.0
2008-06-03 14:00:00	QQQ	ETF	49.0199	49.08	48.67	48.91	36566447.0
2008-06-03 15:00:00	QQQ	ETF	48.91	49.37	48.8	49.15	41449060.0
2008-06-03 16:00:00	QQQ	ETF	49.15	49.2696	48.96	49.12	3869989.0
2008-06-03 17:00:00	QQQ	ETF	49.12	49.12	49.07	49.1	198865.0
2008-06-03 18:00:00	QQQ	ETF	49.12	49.14	49.09	49.09	56500.0
2008-06-03 19:00:00	QQQ	ETF	49.09	49.13	49.06	49.11	9550.0
2008-06-03 05:00:00	IWM	ETF	74.11	74.11	74.11	74.11	100.0
2008-06-03 07:00:00	IWM	ETF	74.08	74.25	74.08	74.25	22514.0
2008-06-03 08:00:00	IWM	ETF	74.22	74.33	74.05	74.26	137470.0
2008-06-03 09:00:00	IWM	ETF	74.25	74.37	74.08	74.21	5044976.0
2008-06-03 10:00:00	IWM	ETF	74.22	74.65	74.15	74.29	11922314.0
2008-06-03 11:00:00	IWM	ETF	74.3	74.48	74.25	74.45	4312827.0
2008-06-03 12:00:00	IWM	ETF	74.46	74.47	74.2	74.26	4704711.0
2008-06-03 13:00:00	IWM	ETF	74.27	74.32	73.46	73.61	13051973.0
2008-06-03 14:00:00	IWM	ETF	73.61	73.61	73.06	73.38	17851661.0
2008-06-03 15:00:00	IWM	ETF	73.38	73.93	73.28	73.77	16523769.0
2008-06-03 16:00:00	IWM	ETF	73.77	74.01	73.75	73.81	8072402.0
2008-06-03 17:00:00	IWM	ETF	73.8	73.81	73.67	73.67	3005993.0
2008-06-03 18:00:00	IWM	ETF	73.74	73.74	73.74	73.74	458.0
2008-06-03 19:00:00	IWM	ETF	73.71	73.8	73.71	73.8	1148.0
2008-06-03 07:00:00	DIA	ETF	125.16	125.2	125.16	125.18	1550.0
2008-06-03 08:00:00	DIA	ETF	125.25	125.39	125.23	125.27	50025.0
2008-06-03 09:00:00	DIA	ETF	125.3	125.45	124.81	124.93	1105963.0
2008-06-03 10:00:00	DIA	ETF	124.94	125.53	124.81	125.17	2666498.0

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

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