PREVIEW / etf_1hour / 2015-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-26.parquet
  size:    245 KB
  rows:    7,796

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-05-26 04:00:00	SPY	ETF	212.6	212.6	212.1	212.22	23743.0
2015-05-26 05:00:00	SPY	ETF	212.25	212.29	212.15	212.25	11100.0
2015-05-26 06:00:00	SPY	ETF	212.22	212.99	212.22	212.66	122695.0
2015-05-26 07:00:00	SPY	ETF	212.6	212.83	212.57	212.68	174567.0
2015-05-26 08:00:00	SPY	ETF	212.69	212.73	212.28	212.4	848524.0
2015-05-26 09:00:00	SPY	ETF	212.4	212.5	211.47	211.57	15330895.0
2015-05-26 10:00:00	SPY	ETF	211.59	211.69	210.83	210.9	18517397.0
2015-05-26 11:00:00	SPY	ETF	210.91	211.24	210.61	210.89	11961297.0
2015-05-26 12:00:00	SPY	ETF	210.9	211.11	210.67	210.695	7103245.0
2015-05-26 13:00:00	SPY	ETF	210.7	210.88	210.27	210.35	11472963.0
2015-05-26 14:00:00	SPY	ETF	210.34	212.9089	210.21	210.24	18522159.0
2015-05-26 15:00:00	SPY	ETF	210.25	210.92	210.2	210.73	25853764.0
2015-05-26 16:00:00	SPY	ETF	210.73	212.0	210.7	211.13	10943651.0
2015-05-26 17:00:00	SPY	ETF	210.7	211.22	210.7	211.15	229099.0
2015-05-26 18:00:00	SPY	ETF	211.15	211.15	210.99	211.06	121579.0
2015-05-26 19:00:00	SPY	ETF	211.05	211.09	210.91	210.95	101577.0
2015-05-26 04:00:00	QQQ	ETF	110.07	110.07	109.95	109.95	31970.0
2015-05-26 05:00:00	QQQ	ETF	109.99	109.99	109.99	109.99	5890.0
2015-05-26 06:00:00	QQQ	ETF	110.0	110.35	110.0	110.35	23100.0
2015-05-26 07:00:00	QQQ	ETF	110.34	110.43	110.34	110.41	52900.0
2015-05-26 08:00:00	QQQ	ETF	110.42	110.44	110.14	110.17	215563.0
2015-05-26 09:00:00	QQQ	ETF	110.15	110.38	109.53	109.56	4079370.0
2015-05-26 10:00:00	QQQ	ETF	109.56	109.65	109.15	109.2	4540999.0
2015-05-26 11:00:00	QQQ	ETF	109.2	109.32	108.99	109.21	2923875.0
2015-05-26 12:00:00	QQQ	ETF	109.22	109.33	109.07	109.1	1628806.0
2015-05-26 13:00:00	QQQ	ETF	109.1	109.2	108.84	108.87	2238953.0
2015-05-26 14:00:00	QQQ	ETF	108.895	109.02	108.76	108.7793	1812439.0
2015-05-26 15:00:00	QQQ	ETF	108.77	109.24	108.76	109.18	4050505.0
2015-05-26 16:00:00	QQQ	ETF	109.185	109.38	109.17	109.37	1745825.0
2015-05-26 17:00:00	QQQ	ETF	109.37	109.4	109.331	109.35	11997.0
2015-05-26 18:00:00	QQQ	ETF	109.37	109.39	109.3	109.32	15274.0
2015-05-26 19:00:00	QQQ	ETF	109.32	109.32	109.28	109.29	6220.0
2015-05-26 04:00:00	IWM	ETF	124.05	124.05	123.0	123.0	300.0
2015-05-26 05:00:00	IWM	ETF	123.66	123.66	123.66	123.66	100.0
2015-05-26 06:00:00	IWM	ETF	123.88	123.88	123.88	123.88	2800.0
2015-05-26 07:00:00	IWM	ETF	123.96	124.26	123.96	124.05	18300.0
2015-05-26 08:00:00	IWM	ETF	124.03	124.12	123.82	123.89	123624.0
2015-05-26 09:00:00	IWM	ETF	123.93	124.04	122.94	123.15	4934395.0
2015-05-26 10:00:00	IWM	ETF	123.13	123.325	122.82	123.01	5819567.0
2015-05-26 11:00:00	IWM	ETF	123.01	123.035	122.52	122.93	4102519.0
2015-05-26 12:00:00	IWM	ETF	122.94	123.26	122.9	122.975	2260316.0
2015-05-26 13:00:00	IWM	ETF	122.98	123.15	122.8	122.855	2022552.0
2015-05-26 14:00:00	IWM	ETF	122.85	123.09	122.705	122.77	1983848.0
2015-05-26 15:00:00	IWM	ETF	122.76	123.35	122.75	123.22	4264952.0
2015-05-26 16:00:00	IWM	ETF	123.23	123.43	123.15	123.34	2176401.0
2015-05-26 17:00:00	IWM	ETF	123.38	123.4	123.34	123.36	1700.0
2015-05-26 18:00:00	IWM	ETF	123.3	123.3	123.3	123.3	1500.0
2015-05-26 19:00:00	IWM	ETF	123.3	123.3	123.3	123.3	200.0
2015-05-26 04:00:00	DIA	ETF	181.0	181.0	181.0	181.0	100.0
2015-05-26 05:00:00	DIA	ETF	181.56	181.56	181.56	181.56	100.0

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

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