PREVIEW / etf_1hour / 2013-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-31.parquet
  size:    212 KB
  rows:    6,695

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-31 04:00:00	SPY	ETF	165.18	165.18	164.85	164.85	52116.0
2013-05-31 05:00:00	SPY	ETF	164.81	164.84	164.57	164.77	152805.0
2013-05-31 06:00:00	SPY	ETF	164.72	165.12	164.66	165.01	314774.0
2013-05-31 07:00:00	SPY	ETF	165.02	165.27	164.97	165.12	383804.0
2013-05-31 08:00:00	SPY	ETF	165.12	165.89	164.7025	165.09	1712171.0
2013-05-31 09:00:00	SPY	ETF	165.07	165.93	165.03	165.62	20016165.0
2013-05-31 10:00:00	SPY	ETF	165.62	165.8247	165.19	165.51	20617120.0
2013-05-31 11:00:00	SPY	ETF	165.51	166.31	165.48	165.86	16694303.0
2013-05-31 12:00:00	SPY	ETF	165.86	165.9	165.45	165.59	10945148.0
2013-05-31 13:00:00	SPY	ETF	165.58	165.85	165.42	165.55	6798166.0
2013-05-31 14:00:00	SPY	ETF	165.555	165.57	164.65	164.67	17209177.0
2013-05-31 15:00:00	SPY	ETF	164.67	165.11	163.13	163.44	51562191.0
2013-05-31 16:00:00	SPY	ETF	163.43	165.997	163.22	163.29	24093218.0
2013-05-31 17:00:00	SPY	ETF	163.3	163.36	162.9	162.93	978150.0
2013-05-31 18:00:00	SPY	ETF	162.93	163.23	162.86	163.17	394870.0
2013-05-31 19:00:00	SPY	ETF	163.16	163.27	163.16	163.21	75402.0
2013-05-31 04:00:00	QQQ	ETF	73.65	73.65	73.43	73.43	4400.0
2013-05-31 05:00:00	QQQ	ETF	73.38	73.38	73.32	73.36	2984.0
2013-05-31 06:00:00	QQQ	ETF	73.39	73.52	73.38	73.48	9300.0
2013-05-31 07:00:00	QQQ	ETF	73.48	73.63	73.45	73.58	24753.0
2013-05-31 08:00:00	QQQ	ETF	73.59	73.93	73.5	73.56	120057.0
2013-05-31 09:00:00	QQQ	ETF	73.56	73.99	73.54	73.89	4962302.0
2013-05-31 10:00:00	QQQ	ETF	73.9	73.98	73.78	73.9	4582998.0
2013-05-31 11:00:00	QQQ	ETF	73.9	74.21	73.89	74.07	5365209.0
2013-05-31 12:00:00	QQQ	ETF	74.07	74.08	73.89	74.0	2565837.0
2013-05-31 13:00:00	QQQ	ETF	73.9999	74.11	73.95	73.99	1923698.0
2013-05-31 14:00:00	QQQ	ETF	73.99	73.9999	73.65	73.67	4011791.0
2013-05-31 15:00:00	QQQ	ETF	73.665	73.82	73.18	73.21	9715427.0
2013-05-31 16:00:00	QQQ	ETF	73.21	73.72	73.09	73.09	2319553.0
2013-05-31 17:00:00	QQQ	ETF	73.08	73.14	73.06	73.1	8591.0
2013-05-31 18:00:00	QQQ	ETF	73.06	73.1	73.06	73.07	7950.0
2013-05-31 19:00:00	QQQ	ETF	73.12	73.18	73.12	73.12	4875.0
2013-05-31 04:00:00	IWM	ETF	98.17	98.17	98.17	98.17	100.0
2013-05-31 05:00:00	IWM	ETF	97.89	97.89	97.89	97.89	400.0
2013-05-31 06:00:00	IWM	ETF	97.91	98.15	97.91	98.14	20400.0
2013-05-31 07:00:00	IWM	ETF	98.15	98.25	98.05	98.16	52000.0
2013-05-31 08:00:00	IWM	ETF	98.13	98.8	98.03	98.13	166580.0
2013-05-31 09:00:00	IWM	ETF	98.12	98.94	98.11	98.75	4981858.0
2013-05-31 10:00:00	IWM	ETF	98.76	98.87	98.41	98.575	5464428.0
2013-05-31 11:00:00	IWM	ETF	98.58	99.02	98.57	98.84	4014283.0
2013-05-31 12:00:00	IWM	ETF	98.83	98.89	98.64	98.83	1988114.0
2013-05-31 13:00:00	IWM	ETF	98.83	98.94	98.72	98.83	1188347.0
2013-05-31 14:00:00	IWM	ETF	98.83	98.85	98.0101	98.1	5783736.0
2013-05-31 15:00:00	IWM	ETF	98.1	98.56	97.8	97.82	11879961.0
2013-05-31 16:00:00	IWM	ETF	97.81	98.625	97.6	97.62	2644761.0
2013-05-31 17:00:00	IWM	ETF	97.64	97.65	97.47	97.47	57403.0
2013-05-31 18:00:00	IWM	ETF	97.55	97.59	97.54	97.54	2327.0
2013-05-31 19:00:00	IWM	ETF	97.58	97.6	97.58	97.6	4055.0
2013-05-31 06:00:00	DIA	ETF	152.26	152.26	152.26	152.26	100.0
2013-05-31 07:00:00	DIA	ETF	152.3	152.36	152.3	152.36	2477.0

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

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