PREVIEW / etf_1hour / 2017-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-06.parquet
  size:    275 KB
  rows:    8,911

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-03-06 04:00:00	SPY	ETF	237.52	237.9	237.36	237.81	15444.0
2017-03-06 05:00:00	SPY	ETF	237.73	237.81	237.65	237.76	5690.0
2017-03-06 06:00:00	SPY	ETF	237.77	237.91	237.77	237.9	16365.0
2017-03-06 07:00:00	SPY	ETF	237.91	237.91	237.76	237.78	86599.0
2017-03-06 08:00:00	SPY	ETF	237.84	237.9	237.61	237.66	362107.0
2017-03-06 09:00:00	SPY	ETF	237.68	237.77	237.17	237.58	6898093.0
2017-03-06 10:00:00	SPY	ETF	237.589	237.63	237.03	237.12	8062747.0
2017-03-06 11:00:00	SPY	ETF	237.115	237.36	237.01	237.1835	3807609.0
2017-03-06 12:00:00	SPY	ETF	237.18	237.55	237.13	237.53	3652457.0
2017-03-06 13:00:00	SPY	ETF	237.53	237.95	237.52	237.7847	6340663.0
2017-03-06 14:00:00	SPY	ETF	237.78	237.85	237.72	237.79	3649485.0
2017-03-06 15:00:00	SPY	ETF	237.8	238.12	237.71	237.76	14522083.0
2017-03-06 16:00:00	SPY	ETF	237.75	237.94	237.34	237.34	5933406.0
2017-03-06 17:00:00	SPY	ETF	237.36	237.71	237.31	237.4	210275.0
2017-03-06 18:00:00	SPY	ETF	237.39	237.82	237.35	237.47	923221.0
2017-03-06 19:00:00	SPY	ETF	237.47	237.57	237.46	237.55	37720.0
2017-03-06 04:00:00	QQQ	ETF	130.8	130.94	130.5	130.7	2800.0
2017-03-06 05:00:00	QQQ	ETF	130.79	130.79	130.73	130.73	16139.0
2017-03-06 06:00:00	QQQ	ETF	130.76	130.82	130.76	130.82	15179.0
2017-03-06 07:00:00	QQQ	ETF	130.8	130.8	130.75	130.76	4026.0
2017-03-06 08:00:00	QQQ	ETF	130.74	130.78	130.62	130.68	111466.0
2017-03-06 09:00:00	QQQ	ETF	130.66	130.7	130.365	130.54	1524183.0
2017-03-06 10:00:00	QQQ	ETF	130.53	130.54	130.21	130.3	2087836.0
2017-03-06 11:00:00	QQQ	ETF	130.29	130.44	130.23	130.34	896811.0
2017-03-06 12:00:00	QQQ	ETF	130.33	130.55	130.31	130.52	815536.0
2017-03-06 13:00:00	QQQ	ETF	130.515	130.845	130.51	130.745	1468015.0
2017-03-06 14:00:00	QQQ	ETF	130.7416	130.83	130.72	130.78	658826.0
2017-03-06 15:00:00	QQQ	ETF	130.77	130.95	130.7	130.73	2237471.0
2017-03-06 16:00:00	QQQ	ETF	130.73	130.78	130.56	130.56	472089.0
2017-03-06 17:00:00	QQQ	ETF	130.59	130.63	130.59	130.59	5177.0
2017-03-06 18:00:00	QQQ	ETF	130.61	130.64	130.57	130.64	11147.0
2017-03-06 19:00:00	QQQ	ETF	130.67	130.76	130.67	130.76	12650.0
2017-03-06 04:00:00	IWM	ETF	137.76	137.77	137.71	137.77	5180.0
2017-03-06 05:00:00	IWM	ETF	138.0	138.0	137.96	137.96	2700.0
2017-03-06 06:00:00	IWM	ETF	138.05	138.05	138.03	138.03	398.0
2017-03-06 07:00:00	IWM	ETF	138.07	138.11	138.01	138.03	65484.0
2017-03-06 08:00:00	IWM	ETF	138.03	138.08	137.65	137.72	128344.0
2017-03-06 09:00:00	IWM	ETF	137.74	137.97	137.26	137.69	3469934.0
2017-03-06 10:00:00	IWM	ETF	137.69	137.859	137.07	137.15	3737950.0
2017-03-06 11:00:00	IWM	ETF	137.15	137.445	136.99	137.07	2117829.0
2017-03-06 12:00:00	IWM	ETF	137.06	137.4	137.02	137.34	1818941.0
2017-03-06 13:00:00	IWM	ETF	137.34	137.81	137.34	137.63	1601882.0
2017-03-06 14:00:00	IWM	ETF	137.625	137.69	137.46	137.53	1236732.0
2017-03-06 15:00:00	IWM	ETF	137.54	137.97	137.515	137.71	3430899.0
2017-03-06 16:00:00	IWM	ETF	137.7	137.78	137.29	137.29	2455889.0
2017-03-06 17:00:00	IWM	ETF	137.3	137.42	137.3	137.41	21873.0
2017-03-06 18:00:00	IWM	ETF	137.4	137.43	137.4	137.43	300.0
2017-03-06 19:00:00	IWM	ETF	137.43	137.6	137.43	137.6	3662.0
2017-03-06 04:00:00	DIA	ETF	209.53	209.53	209.53	209.53	150.0
2017-03-06 07:00:00	DIA	ETF	209.6	209.6	209.6	209.6	100.0

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

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