PREVIEW / etf_1hour / 2008-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-24.parquet
  size:    106 KB
  rows:    3,396

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-04-24 06:00:00	SPY	ETF	137.14	137.29	136.75	136.75	430000.0
2008-04-24 07:00:00	SPY	ETF	136.73	137.17	136.72	137.0	1099733.0
2008-04-24 08:00:00	SPY	ETF	137.01	137.72	136.84	137.54	7689046.0
2008-04-24 09:00:00	SPY	ETF	137.54	138.38	137.2	137.84	24287960.0
2008-04-24 10:00:00	SPY	ETF	137.84	137.88	137.04	137.35	31984883.0
2008-04-24 11:00:00	SPY	ETF	137.349	138.71	137.32	138.44	38140961.0
2008-04-24 12:00:00	SPY	ETF	138.44	139.36	138.43	139.091	30260842.0
2008-04-24 13:00:00	SPY	ETF	139.1	139.41	138.74	139.24	22089996.0
2008-04-24 14:00:00	SPY	ETF	139.25	139.74	139.14	139.46	25127247.0
2008-04-24 15:00:00	SPY	ETF	139.45	139.73	138.7	138.75	37665221.0
2008-04-24 16:00:00	SPY	ETF	138.77	139.41	138.16	138.21	8190280.0
2008-04-24 17:00:00	SPY	ETF	138.22	138.39	138.17	138.3	268617.0
2008-04-24 18:00:00	SPY	ETF	138.3	138.4	138.29	138.29	55150.0
2008-04-24 19:00:00	SPY	ETF	138.34	138.34	138.24	138.28	21671.0
2008-04-24 04:00:00	QQQ	ETF	46.45	46.48	46.45	46.48	200.0
2008-04-24 05:00:00	QQQ	ETF	46.5	46.5	46.5	46.5	100.0
2008-04-24 06:00:00	QQQ	ETF	46.45	46.49	46.42	46.42	100500.0
2008-04-24 07:00:00	QQQ	ETF	46.36	46.51	46.36	46.49	326171.0
2008-04-24 08:00:00	QQQ	ETF	46.49	46.75	46.49	46.67	6720195.0
2008-04-24 09:00:00	QQQ	ETF	46.67	46.96	46.515	46.66	17658411.0
2008-04-24 10:00:00	QQQ	ETF	46.66	46.66	46.39	46.5599	18016081.0
2008-04-24 11:00:00	QQQ	ETF	46.5505	47.33	46.55	47.2	28322154.0
2008-04-24 12:00:00	QQQ	ETF	47.192	47.5	47.192	47.369	19108656.0
2008-04-24 13:00:00	QQQ	ETF	47.37	47.55	47.26	47.52	13128417.0
2008-04-24 14:00:00	QQQ	ETF	47.5201	47.75	47.49	47.6901	17798025.0
2008-04-24 15:00:00	QQQ	ETF	47.69	47.79	47.26	47.3	28898608.0
2008-04-24 16:00:00	QQQ	ETF	47.3	47.4935	46.84	46.93	14285984.0
2008-04-24 17:00:00	QQQ	ETF	46.93	47.06	46.9	47.06	790888.0
2008-04-24 18:00:00	QQQ	ETF	47.06	47.06	47.0	47.0	95287.0
2008-04-24 19:00:00	QQQ	ETF	46.99	47.02	46.95	47.02	42148.0
2008-04-24 07:00:00	IWM	ETF	69.98	69.98	69.87	69.9	6428.0
2008-04-24 08:00:00	IWM	ETF	69.93	70.42	69.75	70.33	945623.0
2008-04-24 09:00:00	IWM	ETF	70.1	70.73	69.9	70.22	6255159.0
2008-04-24 10:00:00	IWM	ETF	70.22	70.23	69.64	70.16	11284432.0
2008-04-24 11:00:00	IWM	ETF	70.17	71.3	70.14	71.08	12493629.0
2008-04-24 12:00:00	IWM	ETF	71.08	71.62	71.07	71.37	10301644.0
2008-04-24 13:00:00	IWM	ETF	71.38	71.52	71.2	71.44	6826160.0
2008-04-24 14:00:00	IWM	ETF	71.44	71.94	71.4	71.73	10189469.0
2008-04-24 15:00:00	IWM	ETF	71.73	71.86	71.24	71.42	9923890.0
2008-04-24 16:00:00	IWM	ETF	71.41	71.47	70.62	70.91	4385487.0
2008-04-24 17:00:00	IWM	ETF	70.91	71.0	70.81	70.92	229502.0
2008-04-24 18:00:00	IWM	ETF	71.0	71.03	70.93	70.97	2300.0
2008-04-24 19:00:00	IWM	ETF	70.93	70.95	70.9	70.9	15850.0
2008-04-24 07:00:00	DIA	ETF	126.89	126.96	126.89	126.96	3100.0
2008-04-24 08:00:00	DIA	ETF	126.85	127.47	126.75	127.33	60229.0
2008-04-24 09:00:00	DIA	ETF	127.31	127.92	127.28	127.64	1100601.0
2008-04-24 10:00:00	DIA	ETF	127.64	127.64	126.94	127.15	1702447.0
2008-04-24 11:00:00	DIA	ETF	127.15	128.28	127.13	128.02	2063370.0
2008-04-24 12:00:00	DIA	ETF	128.01	128.91	128.01	128.73	1961518.0
2008-04-24 13:00:00	DIA	ETF	128.73	129.04	128.42	128.97	2447864.0

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

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