PREVIEW / etf_1hour / 2013-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-19.parquet
  size:    196 KB
  rows:    6,161

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-04-19 04:00:00	SPY	ETF	154.75	154.94	154.71	154.94	28175.0
2013-04-19 05:00:00	SPY	ETF	154.85	154.99	154.74	154.92	21900.0
2013-04-19 06:00:00	SPY	ETF	154.89	155.03	154.86	154.92	81300.0
2013-04-19 07:00:00	SPY	ETF	154.92	154.95	154.68	154.8	445386.0
2013-04-19 08:00:00	SPY	ETF	154.79	154.92	154.36	154.54	2791507.0
2013-04-19 09:00:00	SPY	ETF	154.51	154.75	154.12	154.45	27592981.0
2013-04-19 10:00:00	SPY	ETF	154.45	154.94	154.43	154.86	26557944.0
2013-04-19 11:00:00	SPY	ETF	154.87	155.46	154.78	155.309	17863055.0
2013-04-19 12:00:00	SPY	ETF	155.3	155.39	154.92	155.01	12585839.0
2013-04-19 13:00:00	SPY	ETF	155.0	155.23	154.881	155.1	8310771.0
2013-04-19 14:00:00	SPY	ETF	155.11	155.4	155.04	155.12	9619351.0
2013-04-19 15:00:00	SPY	ETF	155.13	155.55	154.99	155.45	23867463.0
2013-04-19 16:00:00	SPY	ETF	155.41	155.49	154.7499	155.31	14332843.0
2013-04-19 17:00:00	SPY	ETF	155.31	155.4	155.27	155.34	1113985.0
2013-04-19 18:00:00	SPY	ETF	155.33	155.33	155.2	155.29	76159.0
2013-04-19 19:00:00	SPY	ETF	155.3	155.31	155.18	155.19	34056.0
2013-04-19 04:00:00	QQQ	ETF	67.63	67.7	67.63	67.7	4300.0
2013-04-19 05:00:00	QQQ	ETF	67.65	67.71	67.59	67.7	26998.0
2013-04-19 06:00:00	QQQ	ETF	67.67	67.7	67.65	67.7	60100.0
2013-04-19 07:00:00	QQQ	ETF	67.7	67.7	67.62	67.65	162610.0
2013-04-19 08:00:00	QQQ	ETF	67.64	67.76	67.5	67.55	1377594.0
2013-04-19 09:00:00	QQQ	ETF	67.54	67.62	67.2	67.59	8623996.0
2013-04-19 10:00:00	QQQ	ETF	67.59	67.9399	67.58	67.91	7513594.0
2013-04-19 11:00:00	QQQ	ETF	67.91	68.231	67.86	68.11	4850429.0
2013-04-19 12:00:00	QQQ	ETF	68.11	68.17	67.95	68.0	2674386.0
2013-04-19 13:00:00	QQQ	ETF	68.0	68.07	67.89	67.992	2093304.0
2013-04-19 14:00:00	QQQ	ETF	68.0	68.22	67.99	68.0	3341058.0
2013-04-19 15:00:00	QQQ	ETF	68.0	68.18	67.94	68.08	7825729.0
2013-04-19 16:00:00	QQQ	ETF	68.08	68.15	67.1536	68.04	3025280.0
2013-04-19 17:00:00	QQQ	ETF	68.04	68.06	68.0	68.06	22311.0
2013-04-19 18:00:00	QQQ	ETF	68.01	68.02	67.95	67.95	4425.0
2013-04-19 19:00:00	QQQ	ETF	68.03	68.06	68.02	68.06	1647.0
2013-04-19 04:00:00	IWM	ETF	90.01	90.05	90.01	90.05	1260.0
2013-04-19 06:00:00	IWM	ETF	90.25	90.27	90.25	90.25	7907.0
2013-04-19 07:00:00	IWM	ETF	90.21	90.22	90.05	90.12	155956.0
2013-04-19 08:00:00	IWM	ETF	90.07	90.22	89.93	89.99	1572145.0
2013-04-19 09:00:00	IWM	ETF	90.0	90.07	89.21	89.6	7627680.0
2013-04-19 10:00:00	IWM	ETF	89.6	90.33	89.56	90.3	9871285.0
2013-04-19 11:00:00	IWM	ETF	90.29	90.68	90.115	90.625	4153078.0
2013-04-19 12:00:00	IWM	ETF	90.63	90.69	90.23	90.3	2801618.0
2013-04-19 13:00:00	IWM	ETF	90.31	90.45	90.12	90.36	2633206.0
2013-04-19 14:00:00	IWM	ETF	90.36	90.55	90.23	90.34	2550422.0
2013-04-19 15:00:00	IWM	ETF	90.3463	90.69	90.27	90.6099	6126629.0
2013-04-19 16:00:00	IWM	ETF	90.6	90.61	89.539	90.36	2692642.0
2013-04-19 17:00:00	IWM	ETF	90.37	90.64	90.36	90.64	195814.0
2013-04-19 18:00:00	IWM	ETF	90.4	90.4	90.4	90.4	500.0
2013-04-19 19:00:00	IWM	ETF	90.48	90.48	90.4	90.4	1500.0
2013-04-19 05:00:00	DIA	ETF	145.19	145.19	145.19	145.19	100.0
2013-04-19 06:00:00	DIA	ETF	145.3	145.3	145.19	145.3	300.0
2013-04-19 07:00:00	DIA	ETF	145.25	145.25	145.01	145.08	28800.0

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

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