PREVIEW / etf_1hour / 2017-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-03.parquet
  size:    279 KB
  rows:    9,016

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-04-03 04:00:00	SPY	ETF	236.13	236.13	235.75	235.94	5391.0
2017-04-03 05:00:00	SPY	ETF	235.91	236.0	235.91	236.0	1725.0
2017-04-03 06:00:00	SPY	ETF	236.0	236.0	235.8	235.81	11805.0
2017-04-03 07:00:00	SPY	ETF	235.81	235.86	235.75	235.75	289738.0
2017-04-03 08:00:00	SPY	ETF	235.82	235.95	235.68	235.86	487474.0
2017-04-03 09:00:00	SPY	ETF	235.87	236.03	235.69	235.77	9568021.0
2017-04-03 10:00:00	SPY	ETF	235.76	235.9	234.64	234.67	15031958.0
2017-04-03 11:00:00	SPY	ETF	234.675	234.84	234.16	234.32	12745292.0
2017-04-03 12:00:00	SPY	ETF	234.32	234.83	233.91	234.82	8514956.0
2017-04-03 13:00:00	SPY	ETF	234.82	234.97	234.46	234.75	4375265.0
2017-04-03 14:00:00	SPY	ETF	234.76	235.7412	234.49	235.12	7229835.0
2017-04-03 15:00:00	SPY	ETF	235.13	235.52	235.06	235.37	13216832.0
2017-04-03 16:00:00	SPY	ETF	235.37	235.6	235.3	235.33	9919955.0
2017-04-03 17:00:00	SPY	ETF	235.33	235.34	235.26	235.29	110786.0
2017-04-03 18:00:00	SPY	ETF	235.3	235.38	235.28	235.36	86555.0
2017-04-03 19:00:00	SPY	ETF	235.33	235.39	235.32	235.34	21765.0
2017-04-03 04:00:00	QQQ	ETF	132.49	132.49	132.49	132.49	1300.0
2017-04-03 05:00:00	QQQ	ETF	132.57	132.6	132.57	132.6	25000.0
2017-04-03 06:00:00	QQQ	ETF	132.58	132.58	132.58	132.58	500.0
2017-04-03 07:00:00	QQQ	ETF	132.5	132.52	132.46	132.46	10121.0
2017-04-03 08:00:00	QQQ	ETF	132.48	132.57	132.45	132.53	29488.0
2017-04-03 09:00:00	QQQ	ETF	132.53	132.81	132.38	132.6	2697428.0
2017-04-03 10:00:00	QQQ	ETF	132.6	132.731	132.06	132.07	3896028.0
2017-04-03 11:00:00	QQQ	ETF	132.08	132.16	131.76	131.85	4020309.0
2017-04-03 12:00:00	QQQ	ETF	131.85	132.1	131.56	132.095	2871773.0
2017-04-03 13:00:00	QQQ	ETF	132.1	132.18	131.85	132.0347	1825492.0
2017-04-03 14:00:00	QQQ	ETF	132.04	132.35	131.925	132.26	1917257.0
2017-04-03 15:00:00	QQQ	ETF	132.25	132.47	132.24	132.28	3357769.0
2017-04-03 16:00:00	QQQ	ETF	132.29	132.43	132.26	132.29	521327.0
2017-04-03 17:00:00	QQQ	ETF	132.27	132.3	132.25	132.25	7188.0
2017-04-03 18:00:00	QQQ	ETF	132.29	132.31	132.25	132.25	1934.0
2017-04-03 19:00:00	QQQ	ETF	132.28	132.3	132.26	132.26	26999.0
2017-04-03 05:00:00	IWM	ETF	137.76	137.94	137.76	137.94	3000.0
2017-04-03 06:00:00	IWM	ETF	137.76	137.76	137.76	137.76	300.0
2017-04-03 07:00:00	IWM	ETF	137.69	137.76	137.69	137.76	503.0
2017-04-03 08:00:00	IWM	ETF	137.71	137.95	137.48	137.94	82808.0
2017-04-03 09:00:00	IWM	ETF	137.92	138.1	137.16	137.23	3340920.0
2017-04-03 10:00:00	IWM	ETF	137.22	137.3	136.2	136.25	6040465.0
2017-04-03 11:00:00	IWM	ETF	136.2401	136.3901	135.6	135.89	4944198.0
2017-04-03 12:00:00	IWM	ETF	135.88	136.395	135.685	136.3	3266188.0
2017-04-03 13:00:00	IWM	ETF	136.31	136.52	135.91	136.16	2934488.0
2017-04-03 14:00:00	IWM	ETF	136.165	136.62	135.96	136.265	2611208.0
2017-04-03 15:00:00	IWM	ETF	136.26	136.32	136.02	136.06	6597475.0
2017-04-03 16:00:00	IWM	ETF	136.03	136.17	135.97	135.97	4725218.0
2017-04-03 17:00:00	IWM	ETF	135.98	136.0879	135.95	136.0	128756.0
2017-04-03 18:00:00	IWM	ETF	136.02	136.05	136.02	136.05	3434.0
2017-04-03 19:00:00	IWM	ETF	136.05	136.07	136.03	136.03	3950.0
2017-04-03 08:00:00	DIA	ETF	206.67	206.67	206.67	206.67	2013.0
2017-04-03 09:00:00	DIA	ETF	206.65	206.65	206.34	206.39	488892.0
2017-04-03 10:00:00	DIA	ETF	206.38	206.48	205.54	205.59	920210.0

> showing 50 of 9,016 rows — these rows as CSV

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