PREVIEW / etf_1hour / 2015-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-14.parquet
  size:    232 KB
  rows:    7,367

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
2015-08-14 04:00:00	SPY	ETF	208.92	209.0	208.58	208.66	2276.0
2015-08-14 05:00:00	SPY	ETF	208.55	208.57	208.16	208.23	224967.0
2015-08-14 06:00:00	SPY	ETF	208.21	208.34	208.09	208.17	114668.0
2015-08-14 07:00:00	SPY	ETF	208.23	208.25	208.03	208.17	533779.0
2015-08-14 08:00:00	SPY	ETF	208.19	208.39	208.04	208.35	546074.0
2015-08-14 09:00:00	SPY	ETF	208.35	209.07	208.28	208.97	8060622.0
2015-08-14 10:00:00	SPY	ETF	208.97	209.11	208.56	208.66	8980080.0
2015-08-14 11:00:00	SPY	ETF	208.65	208.94	208.26	208.86	7275181.0
2015-08-14 12:00:00	SPY	ETF	208.86	209.02	208.6	208.81	5714618.0
2015-08-14 13:00:00	SPY	ETF	208.805	209.23	208.72	209.01	7001414.0
2015-08-14 14:00:00	SPY	ETF	209.015	209.21	208.92	209.115	7445289.0
2015-08-14 15:00:00	SPY	ETF	209.11	209.5087	209.11	209.4	19762761.0
2015-08-14 16:00:00	SPY	ETF	209.4	209.7	209.33	209.65	5818764.0
2015-08-14 17:00:00	SPY	ETF	209.65	209.71	209.39	209.66	476563.0
2015-08-14 18:00:00	SPY	ETF	209.64	209.66	209.53	209.66	44444.0
2015-08-14 19:00:00	SPY	ETF	209.67	209.75	209.63	209.75	20397.0
2015-08-14 04:00:00	QQQ	ETF	110.36	110.4	110.32	110.32	12200.0
2015-08-14 05:00:00	QQQ	ETF	110.05	110.05	110.0	110.04	620.0
2015-08-14 06:00:00	QQQ	ETF	110.1	110.1	109.94	110.03	10700.0
2015-08-14 07:00:00	QQQ	ETF	110.03	110.04	109.95	110.0	71784.0
2015-08-14 08:00:00	QQQ	ETF	110.0	110.1	109.93	110.1	115961.0
2015-08-14 09:00:00	QQQ	ETF	110.12	110.46	109.93	110.38	2981681.0
2015-08-14 10:00:00	QQQ	ETF	110.38	110.48	110.01	110.1	2645120.0
2015-08-14 11:00:00	QQQ	ETF	110.1	110.26	109.86	110.2	2094948.0
2015-08-14 12:00:00	QQQ	ETF	110.2	110.28	110.0	110.09	1053993.0
2015-08-14 13:00:00	QQQ	ETF	110.09	110.47	110.04	110.294	1438483.0
2015-08-14 14:00:00	QQQ	ETF	110.285	110.46	110.25	110.4	990709.0
2015-08-14 15:00:00	QQQ	ETF	110.41	110.67	110.41	110.52	3683787.0
2015-08-14 16:00:00	QQQ	ETF	110.53	110.68	110.4	110.67	668423.0
2015-08-14 17:00:00	QQQ	ETF	110.67	110.69	110.56	110.56	155539.0
2015-08-14 18:00:00	QQQ	ETF	110.58	110.59	110.58	110.59	700.0
2015-08-14 19:00:00	QQQ	ETF	110.57	110.66	110.57	110.66	2890.0
2015-08-14 04:00:00	IWM	ETF	119.56	119.56	119.56	119.56	100.0
2015-08-14 05:00:00	IWM	ETF	119.4	119.4	119.24	119.24	200.0
2015-08-14 06:00:00	IWM	ETF	119.32	119.32	119.25	119.25	6000.0
2015-08-14 07:00:00	IWM	ETF	119.19	119.28	119.16	119.28	9100.0
2015-08-14 08:00:00	IWM	ETF	119.29	119.35	119.19	119.31	21689.0
2015-08-14 09:00:00	IWM	ETF	119.42	119.93	119.31	119.91	2467151.0
2015-08-14 10:00:00	IWM	ETF	119.85	119.93	119.35	119.35	2513661.0
2015-08-14 11:00:00	IWM	ETF	119.34	119.69	119.02	119.68	2237980.0
2015-08-14 12:00:00	IWM	ETF	119.67	119.78	119.41	119.64	1308993.0
2015-08-14 13:00:00	IWM	ETF	119.63	120.14	119.575	119.96	1548544.0
2015-08-14 14:00:00	IWM	ETF	119.97	120.33	119.93	120.16	1545063.0
2015-08-14 15:00:00	IWM	ETF	120.17	120.49	120.17	120.38	3580934.0
2015-08-14 16:00:00	IWM	ETF	120.38	120.46	119.655	120.44	3583498.0
2015-08-14 17:00:00	IWM	ETF	120.41	120.48	120.41	120.48	2500.0
2015-08-14 18:00:00	IWM	ETF	120.43	120.43	120.43	120.43	100.0
2015-08-14 19:00:00	IWM	ETF	120.41	120.43	120.41	120.43	200.0
2015-08-14 08:00:00	DIA	ETF	174.02	174.02	173.88	173.947	437.0
2015-08-14 09:00:00	DIA	ETF	174.04	174.74	174.04	174.65	354475.0

> showing 50 of 7,367 rows — these rows as CSV

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