PREVIEW / etf_1hour / 2013-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-12.parquet
  size:    208 KB
  rows:    6,502

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
2013-09-12 04:00:00	SPY	ETF	169.35	169.4	169.23	169.26	9500.0
2013-09-12 05:00:00	SPY	ETF	169.24	169.25	169.11	169.17	19130.0
2013-09-12 06:00:00	SPY	ETF	169.17	169.35	169.13	169.35	78250.0
2013-09-12 07:00:00	SPY	ETF	169.35	169.51	169.25	169.51	115933.0
2013-09-12 08:00:00	SPY	ETF	169.48	169.74	169.23	169.44	616389.0
2013-09-12 09:00:00	SPY	ETF	169.43	169.45	169.07	169.35	10967985.0
2013-09-12 10:00:00	SPY	ETF	169.34	169.56	169.27	169.34	9749043.0
2013-09-12 11:00:00	SPY	ETF	169.34	169.45	168.98	169.1	13093706.0
2013-09-12 12:00:00	SPY	ETF	169.105	169.105	168.74	169.02	11681465.0
2013-09-12 13:00:00	SPY	ETF	169.015	169.31	169.0	169.13	7256283.0
2013-09-12 14:00:00	SPY	ETF	169.14	169.25	168.95	169.23	6763717.0
2013-09-12 15:00:00	SPY	ETF	169.2299	169.23	168.72	168.95	16336075.0
2013-09-12 16:00:00	SPY	ETF	168.94	169.4491	168.94	169.11	3951174.0
2013-09-12 17:00:00	SPY	ETF	169.11	169.13	169.05	169.07	388363.0
2013-09-12 18:00:00	SPY	ETF	169.08	169.14	169.05	169.12	56649.0
2013-09-12 19:00:00	SPY	ETF	169.12	169.14	169.08	169.14	25078.0
2013-09-12 04:00:00	QQQ	ETF	78.06	78.06	78.02	78.02	4300.0
2013-09-12 05:00:00	QQQ	ETF	78.0	78.0	77.95	78.0	7100.0
2013-09-12 06:00:00	QQQ	ETF	77.98	78.08	77.98	78.07	11600.0
2013-09-12 07:00:00	QQQ	ETF	78.06	78.14	78.06	78.14	22455.0
2013-09-12 08:00:00	QQQ	ETF	78.18	78.19	78.07	78.15	76812.0
2013-09-12 09:00:00	QQQ	ETF	78.13	78.15	77.85	78.13	2641841.0
2013-09-12 10:00:00	QQQ	ETF	78.1214	78.25	78.07	78.145	2536465.0
2013-09-12 11:00:00	QQQ	ETF	78.14	78.24	77.92	78.0795	2449532.0
2013-09-12 12:00:00	QQQ	ETF	78.07	78.1	77.94	78.05	1898013.0
2013-09-12 13:00:00	QQQ	ETF	78.05	78.21	78.05	78.11	1702958.0
2013-09-12 14:00:00	QQQ	ETF	78.11	78.16	78.02	78.145	1313000.0
2013-09-12 15:00:00	QQQ	ETF	78.14	78.15	77.89	78.01	3764983.0
2013-09-12 16:00:00	QQQ	ETF	78.0	78.08	77.9825	78.06	694293.0
2013-09-12 17:00:00	QQQ	ETF	78.06	78.08	78.06	78.06	147072.0
2013-09-12 18:00:00	QQQ	ETF	78.05	78.07	78.05	78.05	10010.0
2013-09-12 19:00:00	QQQ	ETF	78.08	78.08	78.06	78.08	2300.0
2013-09-12 07:00:00	IWM	ETF	104.9	105.03	104.9	105.03	40590.0
2013-09-12 08:00:00	IWM	ETF	105.03	105.05	104.76	105.02	174324.0
2013-09-12 09:00:00	IWM	ETF	104.99	105.0201	104.66	104.92	2574056.0
2013-09-12 10:00:00	IWM	ETF	104.92	105.01	104.76	104.82	2349982.0
2013-09-12 11:00:00	IWM	ETF	104.82	104.93	104.39	104.49	3367525.0
2013-09-12 12:00:00	IWM	ETF	104.49	104.5	104.25	104.46	2207670.0
2013-09-12 13:00:00	IWM	ETF	104.45	104.68	104.44	104.5886	2209660.0
2013-09-12 14:00:00	IWM	ETF	104.5845	104.65	104.4	104.61	1868047.0
2013-09-12 15:00:00	IWM	ETF	104.61	104.61	104.21	104.28	5252641.0
2013-09-12 16:00:00	IWM	ETF	104.28	104.9324	104.24	104.5	3243529.0
2013-09-12 17:00:00	IWM	ETF	104.5	104.5231	104.36	104.47	744894.0
2013-09-12 19:00:00	IWM	ETF	104.47	104.47	104.47	104.47	100.0
2013-09-12 07:00:00	DIA	ETF	153.23	153.23	153.2	153.2	400.0
2013-09-12 08:00:00	DIA	ETF	153.33	153.33	153.2	153.3	31862.0
2013-09-12 09:00:00	DIA	ETF	153.29	153.39	153.08	153.22	979875.0
2013-09-12 10:00:00	DIA	ETF	153.22	153.41	153.16	153.21	1054952.0
2013-09-12 11:00:00	DIA	ETF	153.21	153.28	152.98	153.06	685862.0
2013-09-12 12:00:00	DIA	ETF	153.07	153.07	152.78	153.05	515953.0

> showing 50 of 6,502 rows — these rows as CSV

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