PREVIEW / etf_1hour / 2016-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-06.parquet
  size:    251 KB
  rows:    8,161

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
2016-10-06 04:00:00	SPY	ETF	215.74	215.78	215.58	215.78	12610.0
2016-10-06 05:00:00	SPY	ETF	215.73	215.78	215.23	215.23	10793.0
2016-10-06 06:00:00	SPY	ETF	215.16	215.29	215.1	215.27	22479.0
2016-10-06 07:00:00	SPY	ETF	215.27	215.5	215.21	215.41	300823.0
2016-10-06 08:00:00	SPY	ETF	215.24	215.47	215.15	215.45	570262.0
2016-10-06 09:00:00	SPY	ETF	215.45	215.55	214.86	215.05	8040750.0
2016-10-06 10:00:00	SPY	ETF	215.05	215.22	214.94	215.12	8415697.0
2016-10-06 11:00:00	SPY	ETF	215.12	215.9	214.735	215.67	11368544.0
2016-10-06 12:00:00	SPY	ETF	215.675	216.04	215.66	215.79	5806106.0
2016-10-06 13:00:00	SPY	ETF	215.79	215.94	215.7	215.79	3782726.0
2016-10-06 14:00:00	SPY	ETF	215.7908	215.97	215.75	215.78	4784332.0
2016-10-06 15:00:00	SPY	ETF	215.79	215.95	215.64	215.83	10581799.0
2016-10-06 16:00:00	SPY	ETF	215.82	216.09	215.78	215.93	4106688.0
2016-10-06 17:00:00	SPY	ETF	215.9	215.92	215.84	215.88	113102.0
2016-10-06 18:00:00	SPY	ETF	215.89	215.96	215.84	215.87	106719.0
2016-10-06 19:00:00	SPY	ETF	215.85	215.85	215.55	215.62	269779.0
2016-10-06 05:00:00	QQQ	ETF	118.75	118.75	118.6	118.6	6235.0
2016-10-06 06:00:00	QQQ	ETF	118.57	118.63	118.57	118.63	5149.0
2016-10-06 07:00:00	QQQ	ETF	118.62	118.73	118.59	118.67	24151.0
2016-10-06 08:00:00	QQQ	ETF	118.66	118.68	118.57	118.68	122881.0
2016-10-06 09:00:00	QQQ	ETF	118.68	118.74	118.32	118.45	1891571.0
2016-10-06 10:00:00	QQQ	ETF	118.44	118.55	118.36	118.53	1596411.0
2016-10-06 11:00:00	QQQ	ETF	118.52	118.95	118.15	118.83	2974464.0
2016-10-06 12:00:00	QQQ	ETF	118.84	118.981	118.73	118.78	995820.0
2016-10-06 13:00:00	QQQ	ETF	118.77	118.83	118.69	118.71	609232.0
2016-10-06 14:00:00	QQQ	ETF	118.71	118.88	118.7	118.77	908962.0
2016-10-06 15:00:00	QQQ	ETF	118.775	118.88	118.7	118.74	1410034.0
2016-10-06 16:00:00	QQQ	ETF	118.74	118.84	118.71	118.75	388479.0
2016-10-06 17:00:00	QQQ	ETF	118.77	118.8	118.74	118.8	5698.0
2016-10-06 18:00:00	QQQ	ETF	118.76	118.76	118.71	118.74	15905.0
2016-10-06 19:00:00	QQQ	ETF	118.71	118.71	118.55	118.58	40859.0
2016-10-06 06:00:00	IWM	ETF	123.62	123.62	123.54	123.54	550.0
2016-10-06 07:00:00	IWM	ETF	123.65	123.79	123.65	123.68	4106.0
2016-10-06 08:00:00	IWM	ETF	123.7	123.85	123.53	123.8	141099.0
2016-10-06 09:00:00	IWM	ETF	123.82	123.82	123.02	123.09	2771460.0
2016-10-06 10:00:00	IWM	ETF	123.08	123.31	122.95	123.26	2556012.0
2016-10-06 11:00:00	IWM	ETF	123.26	123.89	122.82	123.74	4464050.0
2016-10-06 12:00:00	IWM	ETF	123.74	124.015	123.737	123.76	2120734.0
2016-10-06 13:00:00	IWM	ETF	123.76	123.86	123.65	123.76	953134.0
2016-10-06 14:00:00	IWM	ETF	123.75	124.0	123.7125	123.77	1601649.0
2016-10-06 15:00:00	IWM	ETF	123.78	123.93	123.76	123.83	2241663.0
2016-10-06 16:00:00	IWM	ETF	123.82	124.01	123.81	123.83	382644.0
2016-10-06 17:00:00	IWM	ETF	123.83	123.89	123.81	123.81	241526.0
2016-10-06 18:00:00	IWM	ETF	123.82	123.82	123.82	123.82	500.0
2016-10-06 19:00:00	IWM	ETF	123.75	123.8	123.69	123.72	6743.0
2016-10-06 05:00:00	DIA	ETF	182.7	182.7	182.66	182.66	200.0
2016-10-06 08:00:00	DIA	ETF	182.41	182.41	182.35	182.4	300.0
2016-10-06 09:00:00	DIA	ETF	182.5	182.5	181.47	181.76	649037.0
2016-10-06 10:00:00	DIA	ETF	181.74	182.0	181.69	181.77	347956.0
2016-10-06 11:00:00	DIA	ETF	181.76	182.61	181.49	182.42	547990.0

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

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