PREVIEW / etf_1hour / 2013-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-08.parquet
  size:    202 KB
  rows:    6,323

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-05-08 04:00:00	SPY	ETF	162.4	162.54	162.4	162.54	2000.0
2013-05-08 05:00:00	SPY	ETF	162.51	162.6	162.49	162.6	23400.0
2013-05-08 06:00:00	SPY	ETF	162.6	162.68	162.57	162.63	27800.0
2013-05-08 07:00:00	SPY	ETF	162.63	162.66	162.57	162.57	360080.0
2013-05-08 08:00:00	SPY	ETF	162.57	162.63	162.19	162.22	842731.0
2013-05-08 09:00:00	SPY	ETF	162.24	162.78	162.22	162.78	12100609.0
2013-05-08 10:00:00	SPY	ETF	162.775	163.08	162.71	162.95	16122905.0
2013-05-08 11:00:00	SPY	ETF	162.94	163.2	162.94	163.18	9074226.0
2013-05-08 12:00:00	SPY	ETF	163.175	163.24	162.98	163.1	7654840.0
2013-05-08 13:00:00	SPY	ETF	163.11	163.23	163.02	163.05	7592791.0
2013-05-08 14:00:00	SPY	ETF	163.06	163.15	162.73	162.931	12250323.0
2013-05-08 15:00:00	SPY	ETF	162.94	163.39	162.91	163.34	19978473.0
2013-05-08 16:00:00	SPY	ETF	163.35	163.43	163.0009	163.36	6025033.0
2013-05-08 17:00:00	SPY	ETF	163.36	163.37	163.33	163.34	728452.0
2013-05-08 18:00:00	SPY	ETF	163.34	163.35	163.27	163.27	344806.0
2013-05-08 19:00:00	SPY	ETF	163.27	163.31	163.27	163.31	59818.0
2013-05-08 07:00:00	QQQ	ETF	72.4	72.42	72.4	72.4	1395.0
2013-05-08 08:00:00	QQQ	ETF	72.4	72.4	72.27	72.27	73760.0
2013-05-08 09:00:00	QQQ	ETF	72.28	72.5	72.2	72.5	3338922.0
2013-05-08 10:00:00	QQQ	ETF	72.5098	72.71	72.45	72.65	3186237.0
2013-05-08 11:00:00	QQQ	ETF	72.65	72.72	72.63	72.692	1951072.0
2013-05-08 12:00:00	QQQ	ETF	72.7	72.73	72.62	72.67	2119897.0
2013-05-08 13:00:00	QQQ	ETF	72.685	72.74	72.64	72.67	1837345.0
2013-05-08 14:00:00	QQQ	ETF	72.66	72.7001	72.46	72.57	2851004.0
2013-05-08 15:00:00	QQQ	ETF	72.57	72.77	72.55	72.7	3884093.0
2013-05-08 16:00:00	QQQ	ETF	72.71	72.76	72.3466	72.69	4905944.0
2013-05-08 17:00:00	QQQ	ETF	72.68	72.73	72.68	72.72	7915.0
2013-05-08 18:00:00	QQQ	ETF	72.71	72.71	72.65	72.65	19309.0
2013-05-08 19:00:00	QQQ	ETF	72.67	72.68	72.67	72.68	1900.0
2013-05-08 06:00:00	IWM	ETF	96.05	96.05	96.05	96.05	100.0
2013-05-08 07:00:00	IWM	ETF	96.09	96.1	96.09	96.1	1560.0
2013-05-08 08:00:00	IWM	ETF	96.09	96.09	95.78	95.81	162068.0
2013-05-08 09:00:00	IWM	ETF	95.81	96.19	95.79	96.14	3288420.0
2013-05-08 10:00:00	IWM	ETF	96.16	96.25	95.93	96.14	4181351.0
2013-05-08 11:00:00	IWM	ETF	96.14	96.35	96.14	96.35	2078282.0
2013-05-08 12:00:00	IWM	ETF	96.36	96.37	96.15	96.329	1953928.0
2013-05-08 13:00:00	IWM	ETF	96.33	96.4	96.11	96.13	2120879.0
2013-05-08 14:00:00	IWM	ETF	96.13	96.21	95.68	95.9299	7243799.0
2013-05-08 15:00:00	IWM	ETF	95.93	96.45	95.85	96.45	7825415.0
2013-05-08 16:00:00	IWM	ETF	96.45	96.52	95.9198	96.48	2660648.0
2013-05-08 17:00:00	IWM	ETF	96.1075	96.56	96.1075	96.55	531533.0
2013-05-08 19:00:00	IWM	ETF	96.45	96.5	96.45	96.5	300.0
2013-05-08 08:00:00	DIA	ETF	150.17	150.17	149.95	149.95	6345.0
2013-05-08 09:00:00	DIA	ETF	150.26	150.3399	150.0	150.33	264329.0
2013-05-08 10:00:00	DIA	ETF	150.35	150.5	150.28	150.41	701249.0
2013-05-08 11:00:00	DIA	ETF	150.41	150.61	150.4	150.57	630124.0
2013-05-08 12:00:00	DIA	ETF	150.58	150.62	150.49	150.54	489224.0
2013-05-08 13:00:00	DIA	ETF	150.54	150.68	150.53	150.58	443825.0
2013-05-08 14:00:00	DIA	ETF	150.56	150.73	150.45	150.59	360981.0
2013-05-08 15:00:00	DIA	ETF	150.59	150.95	150.55	150.91	947927.0

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

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