PREVIEW / etf_1hour / 2008-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-12.parquet
  size:    102 KB
  rows:    3,252

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-05-12 04:00:00	SPY	ETF	139.41	139.41	139.41	139.41	200.0
2008-05-12 06:00:00	SPY	ETF	139.25	139.34	139.16	139.34	11500.0
2008-05-12 07:00:00	SPY	ETF	139.3	139.54	139.3	139.34	333107.0
2008-05-12 08:00:00	SPY	ETF	139.34	139.36	139.06	139.18	1345514.0
2008-05-12 09:00:00	SPY	ETF	139.18	139.4	138.925	139.01	14484110.0
2008-05-12 10:00:00	SPY	ETF	139.01	139.66	138.73	139.54	28747511.0
2008-05-12 11:00:00	SPY	ETF	139.54	139.89	139.43	139.86	17968105.0
2008-05-12 12:00:00	SPY	ETF	139.87	140.13	139.76	139.93	15922997.0
2008-05-12 13:00:00	SPY	ETF	139.94	139.95	139.58	139.76	15363704.0
2008-05-12 14:00:00	SPY	ETF	139.77	140.53	139.69	140.38	19352308.0
2008-05-12 15:00:00	SPY	ETF	140.38	140.51	140.17	140.47	25502862.0
2008-05-12 16:00:00	SPY	ETF	140.47	140.57	140.4	140.49	4399534.0
2008-05-12 17:00:00	SPY	ETF	140.49	140.52	138.93	140.42	4187488.0
2008-05-12 18:00:00	SPY	ETF	140.46	140.47	140.41	140.46	1008100.0
2008-05-12 19:00:00	SPY	ETF	140.49	140.6	140.48	140.57	30147.0
2008-05-12 04:00:00	QQQ	ETF	48.34	48.34	48.34	48.34	200.0
2008-05-12 06:00:00	QQQ	ETF	48.25	48.27	48.25	48.27	500.0
2008-05-12 07:00:00	QQQ	ETF	48.31	48.37	48.29	48.3	35884.0
2008-05-12 08:00:00	QQQ	ETF	48.31	48.31	48.21	48.25	344683.0
2008-05-12 09:00:00	QQQ	ETF	48.26	48.38	48.23	48.31	9471677.0
2008-05-12 10:00:00	QQQ	ETF	48.31	48.64	48.2	48.57	15929209.0
2008-05-12 11:00:00	QQQ	ETF	48.58	48.81	48.51	48.79	10214000.0
2008-05-12 12:00:00	QQQ	ETF	48.79	48.92	48.75	48.88	6889036.0
2008-05-12 13:00:00	QQQ	ETF	48.88	48.89	48.7	48.8	7826227.0
2008-05-12 14:00:00	QQQ	ETF	48.8	49.19	48.78	49.09	11004422.0
2008-05-12 15:00:00	QQQ	ETF	49.1	49.16	49.03	49.1	18870821.0
2008-05-12 16:00:00	QQQ	ETF	49.1001	49.15	48.7545	49.08	7443336.0
2008-05-12 17:00:00	QQQ	ETF	49.08	49.08	49.04	49.06	17045.0
2008-05-12 18:00:00	QQQ	ETF	49.07	49.08	49.06	49.08	13376.0
2008-05-12 19:00:00	QQQ	ETF	49.07	49.12	49.06	49.08	15777.0
2008-05-12 07:00:00	IWM	ETF	72.11	72.21	72.08	72.11	43643.0
2008-05-12 08:00:00	IWM	ETF	72.07	72.07	71.95	72.02	39637.0
2008-05-12 09:00:00	IWM	ETF	72.01	72.2	71.86	71.95	4085294.0
2008-05-12 10:00:00	IWM	ETF	71.95	72.71	71.81	72.53	8562798.0
2008-05-12 11:00:00	IWM	ETF	72.54	72.96	72.31	72.94	7198775.0
2008-05-12 12:00:00	IWM	ETF	72.94	72.96	72.77	72.82	4735549.0
2008-05-12 13:00:00	IWM	ETF	72.81	72.84	72.44	72.63	4389807.0
2008-05-12 14:00:00	IWM	ETF	72.63	73.27	72.59	73.17	7121241.0
2008-05-12 15:00:00	IWM	ETF	73.16	73.21	72.98	73.08	7170913.0
2008-05-12 16:00:00	IWM	ETF	73.06	73.19	72.68	73.12	960557.0
2008-05-12 17:00:00	IWM	ETF	73.06	73.18	71.86	73.18	2005984.0
2008-05-12 18:00:00	IWM	ETF	73.06	73.11	73.06	73.11	1000200.0
2008-05-12 19:00:00	IWM	ETF	73.11	73.17	73.11	73.17	800.0
2008-05-12 07:00:00	DIA	ETF	127.7	128.06	127.7	128.06	900.0
2008-05-12 08:00:00	DIA	ETF	127.86	127.87	127.69	127.77	14536.0
2008-05-12 09:00:00	DIA	ETF	127.77	127.96	127.67	127.75	776194.0
2008-05-12 10:00:00	DIA	ETF	127.75	128.27	127.53	128.22	1345038.0
2008-05-12 11:00:00	DIA	ETF	128.22	128.48	128.13	128.47	1134610.0
2008-05-12 12:00:00	DIA	ETF	128.45	128.7	128.41	128.61	633120.0
2008-05-12 13:00:00	DIA	ETF	128.61	128.64	128.33	128.42	599290.0

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

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