PREVIEW / etf_1hour / 2014-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-28.parquet
  size:    219 KB
  rows:    6,985

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
2014-08-28 04:00:00	SPY	ETF	200.0	200.01	199.93	199.99	24423.0
2014-08-28 05:00:00	SPY	ETF	200.02	200.04	199.45	199.62	155272.0
2014-08-28 06:00:00	SPY	ETF	199.56	199.65	199.35	199.52	224371.0
2014-08-28 07:00:00	SPY	ETF	199.53	199.89	199.5	199.57	345678.0
2014-08-28 08:00:00	SPY	ETF	199.93	199.96	199.36	199.6	1253192.0
2014-08-28 09:00:00	SPY	ETF	199.59	199.87	199.39	199.819	10490960.0
2014-08-28 10:00:00	SPY	ETF	199.82	200.02	199.51	199.96	10752706.0
2014-08-28 11:00:00	SPY	ETF	199.97	200.04	199.81	199.99	6670320.0
2014-08-28 12:00:00	SPY	ETF	199.985	200.27	199.93	200.19	3979607.0
2014-08-28 13:00:00	SPY	ETF	200.19	200.24	200.08	200.175	2859689.0
2014-08-28 14:00:00	SPY	ETF	200.17	200.24	200.07	200.08	3959173.0
2014-08-28 15:00:00	SPY	ETF	200.08	200.205	199.96	200.14	8348122.0
2014-08-28 16:00:00	SPY	ETF	200.14	200.45	200.0504	200.43	2932473.0
2014-08-28 17:00:00	SPY	ETF	200.44	200.51	200.14	200.46	4806031.0
2014-08-28 18:00:00	SPY	ETF	200.46	200.47	200.38	200.4	55768.0
2014-08-28 19:00:00	SPY	ETF	200.41	200.44	200.4	200.42	97636.0
2014-08-28 04:00:00	QQQ	ETF	99.37	99.37	99.34	99.34	5000.0
2014-08-28 05:00:00	QQQ	ETF	99.37	99.37	99.14	99.21	51350.0
2014-08-28 06:00:00	QQQ	ETF	99.14	99.23	99.1	99.17	21238.0
2014-08-28 07:00:00	QQQ	ETF	99.17	99.34	99.16	99.22	64225.0
2014-08-28 08:00:00	QQQ	ETF	99.25	99.33	99.19	99.22	231985.0
2014-08-28 09:00:00	QQQ	ETF	99.23	99.33	99.08	99.28	3510355.0
2014-08-28 10:00:00	QQQ	ETF	99.285	99.4	99.16	99.3472	3890051.0
2014-08-28 11:00:00	QQQ	ETF	99.35	99.4	99.2932	99.34	1843841.0
2014-08-28 12:00:00	QQQ	ETF	99.3499	99.53	99.31	99.46	1364315.0
2014-08-28 13:00:00	QQQ	ETF	99.47	99.47	99.37	99.44	908489.0
2014-08-28 14:00:00	QQQ	ETF	99.43	99.48	99.38	99.3851	1091149.0
2014-08-28 15:00:00	QQQ	ETF	99.3899	99.48	99.33	99.39	2556591.0
2014-08-28 16:00:00	QQQ	ETF	99.39	99.57	99.2792	99.57	1606144.0
2014-08-28 17:00:00	QQQ	ETF	99.57	99.6	99.41	99.59	2419496.0
2014-08-28 18:00:00	QQQ	ETF	99.57	99.59	99.54	99.57	7715.0
2014-08-28 19:00:00	QQQ	ETF	99.57	99.57	99.55	99.55	5760.0
2014-08-28 05:00:00	IWM	ETF	116.0	116.0	116.0	116.0	100.0
2014-08-28 06:00:00	IWM	ETF	115.88	115.93	115.84	115.84	4200.0
2014-08-28 07:00:00	IWM	ETF	116.03	116.15	115.96	115.96	13750.0
2014-08-28 08:00:00	IWM	ETF	116.03	116.1	115.9	115.95	246219.0
2014-08-28 09:00:00	IWM	ETF	115.97	116.14	115.51	116.02	3841056.0
2014-08-28 10:00:00	IWM	ETF	116.03	116.0816	115.64	115.96	4212163.0
2014-08-28 11:00:00	IWM	ETF	115.97	116.13	115.9	116.04	1420207.0
2014-08-28 12:00:00	IWM	ETF	116.055	116.23	115.98	116.17	1213154.0
2014-08-28 13:00:00	IWM	ETF	116.18	116.19	115.92	116.04	1367364.0
2014-08-28 14:00:00	IWM	ETF	116.04	116.06	115.85	115.8674	1519307.0
2014-08-28 15:00:00	IWM	ETF	115.87	116.1	115.81	115.9	4126641.0
2014-08-28 16:00:00	IWM	ETF	115.92	116.17	115.8667	116.17	2189852.0
2014-08-28 17:00:00	IWM	ETF	116.2	116.22	115.89	116.17	576018.0
2014-08-28 04:00:00	DIA	ETF	170.96	170.96	170.9	170.9	1028.0
2014-08-28 05:00:00	DIA	ETF	170.64	170.64	170.48	170.48	800.0
2014-08-28 07:00:00	DIA	ETF	170.43	170.43	170.41	170.41	3200.0
2014-08-28 08:00:00	DIA	ETF	170.45	170.65	170.37	170.37	11500.0
2014-08-28 09:00:00	DIA	ETF	170.43	170.5	170.1	170.45	810857.0

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

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