PREVIEW / etf_1hour / 2015-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-15.parquet
  size:    242 KB
  rows:    7,753

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-06-15 04:00:00	SPY	ETF	209.6	209.6	208.94	209.25	13985.0
2015-06-15 05:00:00	SPY	ETF	209.31	209.35	209.09	209.09	21725.0
2015-06-15 06:00:00	SPY	ETF	209.12	209.43	209.03	209.33	40073.0
2015-06-15 07:00:00	SPY	ETF	209.28	209.31	208.87	208.99	468576.0
2015-06-15 08:00:00	SPY	ETF	209.0	209.21	208.68	208.7	1002150.0
2015-06-15 09:00:00	SPY	ETF	208.71	208.8	207.79	208.13	21647680.0
2015-06-15 10:00:00	SPY	ETF	208.125	208.59	208.03	208.57	20115075.0
2015-06-15 11:00:00	SPY	ETF	208.57	209.34	208.57	208.99	16748050.0
2015-06-15 12:00:00	SPY	ETF	208.99	209.31	208.9	209.234	8786497.0
2015-06-15 13:00:00	SPY	ETF	209.24	209.45	208.78	208.985	13016429.0
2015-06-15 14:00:00	SPY	ETF	208.99	209.32	208.82	208.91	9418950.0
2015-06-15 15:00:00	SPY	ETF	208.9	209.26	208.75	209.09	19725179.0
2015-06-15 16:00:00	SPY	ETF	209.08	209.11	208.26	209.01	6702676.0
2015-06-15 17:00:00	SPY	ETF	209.02	209.11	208.95	209.01	346445.0
2015-06-15 18:00:00	SPY	ETF	209.0	209.0	208.8	208.85	75047.0
2015-06-15 19:00:00	SPY	ETF	208.86	208.887	208.83	208.88	39427.0
2015-06-15 04:00:00	QQQ	ETF	108.28	108.32	108.28	108.32	600.0
2015-06-15 05:00:00	QQQ	ETF	108.32	108.32	108.3	108.3	6150.0
2015-06-15 06:00:00	QQQ	ETF	108.32	108.35	108.24	108.35	10050.0
2015-06-15 07:00:00	QQQ	ETF	108.29	108.33	108.16	108.18	79551.0
2015-06-15 08:00:00	QQQ	ETF	108.24	108.33	108.06	108.07	107264.0
2015-06-15 09:00:00	QQQ	ETF	108.08	108.13	107.31	107.482	4970311.0
2015-06-15 10:00:00	QQQ	ETF	107.48	107.78	107.44	107.73	4305384.0
2015-06-15 11:00:00	QQQ	ETF	107.73	108.17	107.73	108.02	3514774.0
2015-06-15 12:00:00	QQQ	ETF	108.01	108.21	107.9743	108.17	1391379.0
2015-06-15 13:00:00	QQQ	ETF	108.1757	108.38	108.01	108.16	2139639.0
2015-06-15 14:00:00	QQQ	ETF	108.15	108.37	108.13	108.1701	1381126.0
2015-06-15 15:00:00	QQQ	ETF	108.17	108.355	108.06	108.24	3231595.0
2015-06-15 16:00:00	QQQ	ETF	108.24	108.33	108.2	108.28	695042.0
2015-06-15 17:00:00	QQQ	ETF	108.28	108.29	108.22	108.24	23905.0
2015-06-15 18:00:00	QQQ	ETF	108.27	108.287	108.19	108.19	7854.0
2015-06-15 19:00:00	QQQ	ETF	108.2	108.23	108.2	108.21	5750.0
2015-06-15 04:00:00	IWM	ETF	125.51	125.54	125.44	125.47	4115.0
2015-06-15 07:00:00	IWM	ETF	125.29	125.31	125.27	125.28	2230.0
2015-06-15 08:00:00	IWM	ETF	125.32	125.33	125.19	125.2	88232.0
2015-06-15 09:00:00	IWM	ETF	125.19	125.21	123.94	124.26	6193281.0
2015-06-15 10:00:00	IWM	ETF	124.26	124.99	124.17	124.99	3302050.0
2015-06-15 11:00:00	IWM	ETF	124.99	125.8	124.99	125.6	4444899.0
2015-06-15 12:00:00	IWM	ETF	125.6	125.685	125.44	125.61	1811829.0
2015-06-15 13:00:00	IWM	ETF	125.61	125.68	125.39	125.54	1740453.0
2015-06-15 14:00:00	IWM	ETF	125.54	125.66	125.39	125.45	2010993.0
2015-06-15 15:00:00	IWM	ETF	125.44	125.78	125.33	125.55	3233714.0
2015-06-15 16:00:00	IWM	ETF	125.54	125.57	125.42	125.48	675054.0
2015-06-15 17:00:00	IWM	ETF	125.43	125.53	125.39	125.42	65400.0
2015-06-15 18:00:00	IWM	ETF	125.45	125.51	125.45	125.51	1100.0
2015-06-15 07:00:00	DIA	ETF	178.49	178.5	178.49	178.5	4000.0
2015-06-15 08:00:00	DIA	ETF	178.51	178.51	178.1	178.1	1600.0
2015-06-15 09:00:00	DIA	ETF	178.0	178.0	177.11	177.48	1178591.0
2015-06-15 10:00:00	DIA	ETF	177.46	177.6984	177.31	177.6295	783478.0
2015-06-15 11:00:00	DIA	ETF	177.63	178.29	177.63	178.0	877920.0

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

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