PREVIEW / etf_1hour / 2013-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-08.parquet
  size:    210 KB
  rows:    6,515

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-10-08 04:00:00	SPY	ETF	167.42	167.54	167.26	167.32	13978.0
2013-10-08 05:00:00	SPY	ETF	167.29	167.29	167.13	167.23	24152.0
2013-10-08 06:00:00	SPY	ETF	167.24	167.39	167.19	167.25	93000.0
2013-10-08 07:00:00	SPY	ETF	167.29	167.39	167.17	167.39	184667.0
2013-10-08 08:00:00	SPY	ETF	167.38	167.64	167.24	167.52	948637.0
2013-10-08 09:00:00	SPY	ETF	167.52	167.62	167.05	167.54	17424858.0
2013-10-08 10:00:00	SPY	ETF	167.54	167.58	166.67	166.76	22598783.0
2013-10-08 11:00:00	SPY	ETF	166.758	166.83	166.06	166.35	25909510.0
2013-10-08 12:00:00	SPY	ETF	166.35	166.37	165.84	166.27	16365862.0
2013-10-08 13:00:00	SPY	ETF	166.27	166.4	165.87	165.9201	16149298.0
2013-10-08 14:00:00	SPY	ETF	165.925	166.12	165.6	165.92	20267600.0
2013-10-08 15:00:00	SPY	ETF	165.92	167.5129	165.36	165.48	37991585.0
2013-10-08 16:00:00	SPY	ETF	165.47	167.5129	165.16	165.2	14526588.0
2013-10-08 17:00:00	SPY	ETF	165.2	165.45	165.16	165.41	1606533.0
2013-10-08 18:00:00	SPY	ETF	165.41	165.96	165.4	165.93	639468.0
2013-10-08 19:00:00	SPY	ETF	165.92	166.22	165.91	165.95	376961.0
2013-10-08 04:00:00	QQQ	ETF	78.76	78.82	78.69	78.72	36400.0
2013-10-08 05:00:00	QQQ	ETF	78.71	78.71	78.63	78.69	22700.0
2013-10-08 06:00:00	QQQ	ETF	78.7	78.75	78.66	78.7	13360.0
2013-10-08 07:00:00	QQQ	ETF	78.72	78.75	78.65	78.73	84915.0
2013-10-08 08:00:00	QQQ	ETF	78.7	78.89	78.7	78.81	172445.0
2013-10-08 09:00:00	QQQ	ETF	78.81	78.82	78.43	78.63	3651383.0
2013-10-08 10:00:00	QQQ	ETF	78.64	78.65	77.87	77.91	7208875.0
2013-10-08 11:00:00	QQQ	ETF	77.91	77.95	77.46	77.66	6287666.0
2013-10-08 12:00:00	QQQ	ETF	77.66	77.67	77.3	77.56	5877716.0
2013-10-08 13:00:00	QQQ	ETF	77.56	77.63	77.36	77.37	3037532.0
2013-10-08 14:00:00	QQQ	ETF	77.37	77.48	77.19	77.375	4851290.0
2013-10-08 15:00:00	QQQ	ETF	77.37	77.61	77.2	77.26	8508760.0
2013-10-08 16:00:00	QQQ	ETF	77.22	78.539	77.2107	77.26	3105721.0
2013-10-08 17:00:00	QQQ	ETF	77.22	77.39	77.19	77.39	77550.0
2013-10-08 18:00:00	QQQ	ETF	77.31	77.49	77.31	77.48	110844.0
2013-10-08 19:00:00	QQQ	ETF	77.5	77.63	77.5	77.51	53883.0
2013-10-08 04:00:00	IWM	ETF	105.77	105.87	105.73	105.73	300.0
2013-10-08 05:00:00	IWM	ETF	105.72	105.72	105.72	105.72	100.0
2013-10-08 07:00:00	IWM	ETF	105.68	105.8	105.63	105.8	29300.0
2013-10-08 08:00:00	IWM	ETF	105.74	105.9	105.74	105.82	289037.0
2013-10-08 09:00:00	IWM	ETF	105.84	106.03	105.56	105.96	4942408.0
2013-10-08 10:00:00	IWM	ETF	105.96	105.98	105.01	105.15	8892568.0
2013-10-08 11:00:00	IWM	ETF	105.15	105.2	104.4	104.62	9531019.0
2013-10-08 12:00:00	IWM	ETF	104.62	104.62	104.04	104.4001	7088449.0
2013-10-08 13:00:00	IWM	ETF	104.4	104.58	104.1585	104.17	3923204.0
2013-10-08 14:00:00	IWM	ETF	104.17	104.24	103.92	104.11	5891364.0
2013-10-08 15:00:00	IWM	ETF	104.11	104.37	103.95	104.06	10501621.0
2013-10-08 16:00:00	IWM	ETF	104.05	105.82	103.87	103.88	2325407.0
2013-10-08 17:00:00	IWM	ETF	103.92	104.0	103.87	104.0	23285.0
2013-10-08 18:00:00	IWM	ETF	103.9	104.37	103.89	104.37	13056.0
2013-10-08 19:00:00	IWM	ETF	104.48	104.5	104.32	104.46	12785.0
2013-10-08 05:00:00	DIA	ETF	148.9	148.9	148.9	148.9	100.0
2013-10-08 08:00:00	DIA	ETF	149.18	149.18	149.1	149.12	1700.0
2013-10-08 09:00:00	DIA	ETF	149.13	149.14	148.65	149.08	1149852.0

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

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