PREVIEW / etf_1hour / 2017-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-16.parquet
  size:    275 KB
  rows:    8,867

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
2017-02-16 04:00:00	SPY	ETF	235.0	235.0	234.87	234.89	7950.0
2017-02-16 05:00:00	SPY	ETF	234.85	234.9	234.78	234.83	11675.0
2017-02-16 06:00:00	SPY	ETF	234.9	234.92	234.82	234.86	21813.0
2017-02-16 07:00:00	SPY	ETF	234.88	234.91	234.75	234.78	44275.0
2017-02-16 08:00:00	SPY	ETF	234.78	234.89	234.63	234.86	599583.0
2017-02-16 09:00:00	SPY	ETF	234.87	235.155	234.51	234.67	10355611.0
2017-02-16 10:00:00	SPY	ETF	234.66	234.95	233.97	234.31	14642505.0
2017-02-16 11:00:00	SPY	ETF	234.31	234.53	233.85	234.5202	12065877.0
2017-02-16 12:00:00	SPY	ETF	234.5201	234.7	234.25	234.44	8004462.0
2017-02-16 13:00:00	SPY	ETF	234.445	234.46	234.17	234.345	7545076.0
2017-02-16 14:00:00	SPY	ETF	234.345	234.45	234.09	234.375	8863723.0
2017-02-16 15:00:00	SPY	ETF	234.375	234.75	234.34	234.73	15232394.0
2017-02-16 16:00:00	SPY	ETF	234.74	234.89	234.7	234.75	4333110.0
2017-02-16 17:00:00	SPY	ETF	234.73	234.77	234.7	234.7	2220141.0
2017-02-16 18:00:00	SPY	ETF	234.69	234.69	234.57	234.57	60498.0
2017-02-16 19:00:00	SPY	ETF	234.58	234.67	234.51	234.65	83187.0
2017-02-16 04:00:00	QQQ	ETF	129.38	129.38	129.37	129.38	1700.0
2017-02-16 05:00:00	QQQ	ETF	129.4	129.4	129.39	129.39	463.0
2017-02-16 06:00:00	QQQ	ETF	129.42	129.43	129.36	129.38	5350.0
2017-02-16 07:00:00	QQQ	ETF	129.39	129.45	129.34	129.37	39358.0
2017-02-16 08:00:00	QQQ	ETF	129.36	129.4	129.31	129.38	78403.0
2017-02-16 09:00:00	QQQ	ETF	129.38	129.63	129.2	129.31	2003100.0
2017-02-16 10:00:00	QQQ	ETF	129.305	129.54	128.95	129.14	2802143.0
2017-02-16 11:00:00	QQQ	ETF	129.14	129.2	128.92	129.145	2599705.0
2017-02-16 12:00:00	QQQ	ETF	129.145	129.23	129.015	129.075	1187176.0
2017-02-16 13:00:00	QQQ	ETF	129.07	129.11	128.97	129.09	987907.0
2017-02-16 14:00:00	QQQ	ETF	129.1	129.17	128.9684	129.12	1557866.0
2017-02-16 15:00:00	QQQ	ETF	129.12	129.26	129.09	129.25	2190847.0
2017-02-16 16:00:00	QQQ	ETF	129.25	129.31	129.0857	129.23	952222.0
2017-02-16 17:00:00	QQQ	ETF	129.25	129.26	129.21	129.21	1664.0
2017-02-16 18:00:00	QQQ	ETF	129.21	129.21	129.15	129.15	2688.0
2017-02-16 19:00:00	QQQ	ETF	129.12	129.2573	129.08	129.19	306000.0
2017-02-16 05:00:00	IWM	ETF	139.32	139.32	139.32	139.32	100.0
2017-02-16 06:00:00	IWM	ETF	139.34	139.34	139.26	139.26	9210.0
2017-02-16 07:00:00	IWM	ETF	139.34	139.37	139.22	139.25	30074.0
2017-02-16 08:00:00	IWM	ETF	139.24	139.38	139.15	139.38	70585.0
2017-02-16 09:00:00	IWM	ETF	139.41	139.84	139.2	139.29	2034496.0
2017-02-16 10:00:00	IWM	ETF	139.28	139.35	138.47	138.78	3665853.0
2017-02-16 11:00:00	IWM	ETF	138.78	138.78	138.21	138.66	4325495.0
2017-02-16 12:00:00	IWM	ETF	138.67	138.92	138.35	138.73	1602882.0
2017-02-16 13:00:00	IWM	ETF	138.73	138.77	138.51	138.63	1863888.0
2017-02-16 14:00:00	IWM	ETF	138.63	138.68	138.38	138.595	2446711.0
2017-02-16 15:00:00	IWM	ETF	138.6	139.18	138.57	139.16	4423841.0
2017-02-16 16:00:00	IWM	ETF	139.17	139.32	139.02	139.02	1293941.0
2017-02-16 17:00:00	IWM	ETF	139.01	139.1	138.96	139.1	13830.0
2017-02-16 18:00:00	IWM	ETF	139.02	139.02	138.93	139.0	5163.0
2017-02-16 19:00:00	IWM	ETF	138.99	139.0803	138.93	138.93	139036.0
2017-02-16 07:00:00	DIA	ETF	206.5	206.5	206.38	206.38	1855.0
2017-02-16 08:00:00	DIA	ETF	206.45	206.45	206.27	206.42	1755.0
2017-02-16 09:00:00	DIA	ETF	206.48	206.7199	206.28	206.35	562992.0

> showing 50 of 8,867 rows — these rows as CSV

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