PREVIEW / etf_1hour / 2017-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-12.parquet
  size:    268 KB
  rows:    8,769

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-05-12 04:00:00	SPY	ETF	238.85	238.85	238.7	238.76	20061.0
2017-05-12 05:00:00	SPY	ETF	238.76	238.81	238.67	238.76	32450.0
2017-05-12 06:00:00	SPY	ETF	238.76	238.79	238.69	238.79	11200.0
2017-05-12 07:00:00	SPY	ETF	238.84	239.03	238.84	238.86	79919.0
2017-05-12 08:00:00	SPY	ETF	238.89	239.26	238.82	239.17	456666.0
2017-05-12 09:00:00	SPY	ETF	239.17	239.38	238.91	238.99	4844323.0
2017-05-12 10:00:00	SPY	ETF	238.99	239.1	238.67	238.8	7483066.0
2017-05-12 11:00:00	SPY	ETF	238.8	239.2	238.745	239.05	4126679.0
2017-05-12 12:00:00	SPY	ETF	239.05	239.06	238.86	238.92	3003961.0
2017-05-12 13:00:00	SPY	ETF	238.93	238.99	238.81	238.98	4185549.0
2017-05-12 14:00:00	SPY	ETF	238.99	239.4273	238.84	238.97	5844575.0
2017-05-12 15:00:00	SPY	ETF	238.975	239.04	238.745	239.03	11308986.0
2017-05-12 16:00:00	SPY	ETF	239.02	239.22	238.98	239.09	10805126.0
2017-05-12 17:00:00	SPY	ETF	239.07	239.16	239.0	239.12	137204.0
2017-05-12 18:00:00	SPY	ETF	239.12	239.13	239.1	239.11	26659.0
2017-05-12 19:00:00	SPY	ETF	239.13	239.15	239.1	239.14	27599.0
2017-05-12 04:00:00	QQQ	ETF	137.99	137.99	137.9	137.93	2100.0
2017-05-12 05:00:00	QQQ	ETF	137.92	138.0	137.92	138.0	25850.0
2017-05-12 06:00:00	QQQ	ETF	137.96	138.0	137.95	138.0	4000.0
2017-05-12 07:00:00	QQQ	ETF	138.06	138.16	138.06	138.11	1532.0
2017-05-12 08:00:00	QQQ	ETF	138.08	138.3	138.08	138.3	99121.0
2017-05-12 09:00:00	QQQ	ETF	138.31	138.54	138.29	138.36	2604129.0
2017-05-12 10:00:00	QQQ	ETF	138.36	138.54	138.23	138.34	2194741.0
2017-05-12 11:00:00	QQQ	ETF	138.34	138.625	138.305	138.595	1800161.0
2017-05-12 12:00:00	QQQ	ETF	138.6	138.6	138.47	138.52	1450766.0
2017-05-12 13:00:00	QQQ	ETF	138.525	138.61	138.48	138.59	589599.0
2017-05-12 14:00:00	QQQ	ETF	138.61	138.63	138.522	138.57	947140.0
2017-05-12 15:00:00	QQQ	ETF	138.57	138.61	138.38	138.61	2315227.0
2017-05-12 16:00:00	QQQ	ETF	138.61	138.7	138.6	138.69	821861.0
2017-05-12 17:00:00	QQQ	ETF	138.69	138.69	138.61	138.66	1568637.0
2017-05-12 18:00:00	QQQ	ETF	138.69	138.69	138.66	138.67	900.0
2017-05-12 19:00:00	QQQ	ETF	138.69	138.69	138.65	138.65	10005.0
2017-05-12 04:00:00	IWM	ETF	137.61	137.61	137.46	137.46	920.0
2017-05-12 05:00:00	IWM	ETF	137.58	137.58	137.44	137.52	12899.0
2017-05-12 06:00:00	IWM	ETF	137.53	137.58	137.53	137.58	5400.0
2017-05-12 07:00:00	IWM	ETF	137.6	137.7	137.54	137.56	67413.0
2017-05-12 08:00:00	IWM	ETF	137.56	137.89	137.5	137.83	162783.0
2017-05-12 09:00:00	IWM	ETF	137.83	137.99	137.27	137.63	2854066.0
2017-05-12 10:00:00	IWM	ETF	137.62	137.71	137.16	137.35	3223708.0
2017-05-12 11:00:00	IWM	ETF	137.35	137.78	137.25	137.71	1805627.0
2017-05-12 12:00:00	IWM	ETF	137.71	137.8875	137.56	137.76	1142725.0
2017-05-12 13:00:00	IWM	ETF	137.76	137.78	137.63	137.75	1049125.0
2017-05-12 14:00:00	IWM	ETF	137.75	137.76	137.53	137.68	1464661.0
2017-05-12 15:00:00	IWM	ETF	137.68	137.68	137.29	137.53	4083152.0
2017-05-12 16:00:00	IWM	ETF	137.51	137.69	137.39	137.66	1721240.0
2017-05-12 17:00:00	IWM	ETF	137.66	137.78	137.51	137.54	825658.0
2017-05-12 18:00:00	IWM	ETF	137.51	137.7	137.51	137.6	167856.0
2017-05-12 19:00:00	IWM	ETF	137.6	137.61	137.6	137.61	314.0
2017-05-12 06:00:00	DIA	ETF	208.8	208.86	208.8	208.86	200.0
2017-05-12 07:00:00	DIA	ETF	208.92	209.04	208.92	209.04	200.0

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

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