PREVIEW / etf_1hour / 2006-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-12.parquet
  size:    52 KB
  rows:    1,623

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
2006-09-12 05:00:00	SPY	ETF	130.33	130.34	130.33	130.34	200.0
2006-09-12 06:00:00	SPY	ETF	130.21	130.23	130.17	130.17	2400.0
2006-09-12 07:00:00	SPY	ETF	130.19	130.26	130.19	130.25	58600.0
2006-09-12 08:00:00	SPY	ETF	130.17	130.46	130.17	130.39	438800.0
2006-09-12 09:00:00	SPY	ETF	130.33	130.73	130.32	130.61	5898500.0
2006-09-12 10:00:00	SPY	ETF	130.62	131.03	130.6	131.0	13279500.0
2006-09-12 11:00:00	SPY	ETF	131.01	131.26	131.0	131.13	7915500.0
2006-09-12 12:00:00	SPY	ETF	131.13	131.18	130.99	131.15	3681800.0
2006-09-12 13:00:00	SPY	ETF	131.17	131.39	130.97	131.31	8220700.0
2006-09-12 14:00:00	SPY	ETF	131.3	131.84	130.3681	131.78	9756700.0
2006-09-12 15:00:00	SPY	ETF	131.78	131.8	131.6	131.64	12846800.0
2006-09-12 16:00:00	SPY	ETF	131.64	131.8	131.59	131.64	4708600.0
2006-09-12 17:00:00	SPY	ETF	131.64	131.71	131.63	131.67	43500.0
2006-09-12 18:00:00	SPY	ETF	131.69	131.71	131.65	131.71	23100.0
2006-09-12 19:00:00	SPY	ETF	131.72	131.72	131.72	131.72	800.0
2006-09-12 09:00:00	QQQ	ETF	38.95	39.11	38.95	39.05	14626200.0
2006-09-12 10:00:00	QQQ	ETF	39.05	39.3	39.04	39.29	18237000.0
2006-09-12 11:00:00	QQQ	ETF	39.29	39.37	39.25	39.32	12805200.0
2006-09-12 12:00:00	QQQ	ETF	39.32	39.34	39.21	39.33	8590500.0
2006-09-12 13:00:00	QQQ	ETF	39.33	39.41	39.2	39.38	10451500.0
2006-09-12 14:00:00	QQQ	ETF	39.38	39.8	39.34	39.78	25182300.0
2006-09-12 15:00:00	QQQ	ETF	39.78	39.79	39.66	39.69	24512600.0
2006-09-12 08:00:00	IWM	ETF	70.46	70.53	70.4	70.47	264300.0
2006-09-12 09:00:00	IWM	ETF	70.49	70.85	70.46	70.81	3588600.0
2006-09-12 10:00:00	IWM	ETF	70.81	71.12	70.75	71.1	5318600.0
2006-09-12 11:00:00	IWM	ETF	71.11	71.46	71.1	71.41	5343600.0
2006-09-12 12:00:00	IWM	ETF	71.41	71.56	71.29	71.52	3127000.0
2006-09-12 13:00:00	IWM	ETF	71.53	71.82	71.37	71.71	5959300.0
2006-09-12 14:00:00	IWM	ETF	71.72	72.29	71.62	72.27	8462700.0
2006-09-12 15:00:00	IWM	ETF	72.26	72.28	71.99	72.11	9433900.0
2006-09-12 16:00:00	IWM	ETF	72.13	72.21	72.09	72.09	543200.0
2006-09-12 17:00:00	IWM	ETF	72.08	72.08	72.08	72.08	16000.0
2006-09-12 18:00:00	IWM	ETF	72.12	72.12	72.12	72.12	1000.0
2006-09-12 08:00:00	DIA	ETF	113.92	114.04	113.88	113.95	9600.0
2006-09-12 09:00:00	DIA	ETF	113.97	114.24	113.97	114.16	362500.0
2006-09-12 10:00:00	DIA	ETF	114.15	114.5	114.15	114.5	882300.0
2006-09-12 11:00:00	DIA	ETF	114.5	114.71	114.5	114.65	925900.0
2006-09-12 12:00:00	DIA	ETF	114.65	114.67	114.46	114.67	784900.0
2006-09-12 13:00:00	DIA	ETF	114.66	114.86	114.51	114.77	1439600.0
2006-09-12 14:00:00	DIA	ETF	114.77	115.18	114.71	115.08	2191300.0
2006-09-12 15:00:00	DIA	ETF	115.09	115.1	114.9	114.96	2463200.0
2006-09-12 16:00:00	DIA	ETF	114.96	115.02	114.92	114.94	27300.0
2006-09-12 17:00:00	DIA	ETF	114.93	114.93	114.93	114.93	100.0
2006-09-12 18:00:00	DIA	ETF	115.02	115.1	115.02	115.08	400.0
2006-09-12 07:00:00	GLD	ETF	59.1	59.25	58.99	59.05	30500.0
2006-09-12 08:00:00	GLD	ETF	59.1	59.25	58.84	59.1	129400.0
2006-09-12 09:00:00	GLD	ETF	59.03	59.15	58.63	58.7102	1028300.0
2006-09-12 10:00:00	GLD	ETF	58.7126	59.07	58.54	58.81	1204300.0
2006-09-12 11:00:00	GLD	ETF	58.82	59.09	58.7426	58.93	763200.0
2006-09-12 12:00:00	GLD	ETF	58.91	58.94	58.5612	58.5612	361400.0

> showing 50 of 1,623 rows — these rows as CSV

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