PREVIEW / etf_1hour / 2007-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-08.parquet
  size:    71 KB
  rows:    2,341

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-05-08 05:00:00	SPY	ETF	150.65	150.65	150.53	150.53	1000.0
2007-05-08 06:00:00	SPY	ETF	150.55	150.55	150.5	150.54	19200.0
2007-05-08 07:00:00	SPY	ETF	150.54	150.57	150.39	150.5	236700.0
2007-05-08 08:00:00	SPY	ETF	150.49	150.64	150.47	150.56	2577800.0
2007-05-08 09:00:00	SPY	ETF	150.56	150.62	150.32	150.39	12774513.0
2007-05-08 10:00:00	SPY	ETF	150.39	150.43	150.13	150.39	17752469.0
2007-05-08 11:00:00	SPY	ETF	150.4	150.45	150.24	150.31	6019602.0
2007-05-08 12:00:00	SPY	ETF	150.32	150.75	150.24	150.69	10060242.0
2007-05-08 13:00:00	SPY	ETF	150.69	150.79	150.61	150.66	8133243.0
2007-05-08 14:00:00	SPY	ETF	150.66	150.88	150.58	150.66	9196862.0
2007-05-08 15:00:00	SPY	ETF	150.67	150.92	150.64	150.86	10172705.0
2007-05-08 16:00:00	SPY	ETF	150.87	150.92	150.64	150.67	2206800.0
2007-05-08 17:00:00	SPY	ETF	150.66	150.68	150.57	150.59	940300.0
2007-05-08 18:00:00	SPY	ETF	150.59	150.72	150.57	150.67	215100.0
2007-05-08 19:00:00	SPY	ETF	150.65	150.65	150.61	150.65	4900.0
2007-05-08 06:00:00	QQQ	ETF	46.49	46.49	46.49	46.49	5000.0
2007-05-08 07:00:00	QQQ	ETF	46.48	46.49	46.4	46.43	1461892.0
2007-05-08 08:00:00	QQQ	ETF	46.44	46.56	46.42	46.53	2399558.0
2007-05-08 09:00:00	QQQ	ETF	46.52	46.53	46.36	46.42	13727105.0
2007-05-08 10:00:00	QQQ	ETF	46.42	46.56	46.3	46.52	18301512.0
2007-05-08 11:00:00	QQQ	ETF	46.52	46.55	46.46	46.47	7214751.0
2007-05-08 12:00:00	QQQ	ETF	46.48	46.63	46.44	46.6	9432288.0
2007-05-08 13:00:00	QQQ	ETF	46.61	46.71	46.57	46.61	10880415.0
2007-05-08 14:00:00	QQQ	ETF	46.61	46.77	46.59	46.62	10403783.0
2007-05-08 15:00:00	QQQ	ETF	46.62	46.74	46.62	46.73	9706446.0
2007-05-08 16:00:00	QQQ	ETF	46.72	46.78	46.5	46.53	7019154.0
2007-05-08 17:00:00	QQQ	ETF	46.53	46.55	46.5	46.52	365814.0
2007-05-08 18:00:00	QQQ	ETF	46.52	46.54	46.51	46.53	9054.0
2007-05-08 19:00:00	QQQ	ETF	46.53	46.54	46.51	46.54	13337.0
2007-05-08 07:00:00	IWM	ETF	82.1	82.2	82.1	82.15	28900.0
2007-05-08 08:00:00	IWM	ETF	82.18	82.27	82.14	82.19	226000.0
2007-05-08 09:00:00	IWM	ETF	82.2	82.21	81.84	81.91	8323100.0
2007-05-08 10:00:00	IWM	ETF	81.91	81.98	81.54	81.92	16465186.0
2007-05-08 11:00:00	IWM	ETF	81.92	81.95	81.78	81.86	4085350.0
2007-05-08 12:00:00	IWM	ETF	81.86	82.43	81.83	82.31	8138600.0
2007-05-08 13:00:00	IWM	ETF	82.32	82.62	82.15	82.17	6506666.0
2007-05-08 14:00:00	IWM	ETF	82.17	82.44	82.11	82.27	5006407.0
2007-05-08 15:00:00	IWM	ETF	82.27	82.55	82.26	82.47	5666146.0
2007-05-08 16:00:00	IWM	ETF	82.48	82.516	82.14	82.16	2227300.0
2007-05-08 17:00:00	IWM	ETF	82.16	82.3	82.14	82.18	146200.0
2007-05-08 07:00:00	DIA	ETF	132.64	132.67	132.4	132.57	110500.0
2007-05-08 08:00:00	DIA	ETF	132.6	132.69	132.55	132.66	650500.0
2007-05-08 09:00:00	DIA	ETF	132.66	132.75	132.42	132.51	1353550.0
2007-05-08 10:00:00	DIA	ETF	132.49	132.62	132.35	132.59	2522189.0
2007-05-08 11:00:00	DIA	ETF	132.59	132.6	132.44	132.52	824600.0
2007-05-08 12:00:00	DIA	ETF	132.53	132.91	132.48	132.84	985600.0
2007-05-08 13:00:00	DIA	ETF	132.84	132.93	132.81	132.85	501450.0
2007-05-08 14:00:00	DIA	ETF	132.86	133.06	132.82	132.91	893250.0
2007-05-08 15:00:00	DIA	ETF	132.91	133.17	132.91	133.15	1452000.0
2007-05-08 16:00:00	DIA	ETF	133.15	133.22	133.06	133.06	119600.0

> showing 50 of 2,341 rows — these rows as CSV

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