PREVIEW / etf_1hour / 2017-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-19.parquet
  size:    275 KB
  rows:    8,885

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-19 04:00:00	SPY	ETF	236.71	237.2	236.7	237.01	24723.0
2017-05-19 05:00:00	SPY	ETF	237.0	237.41	237.0	237.31	22325.0
2017-05-19 06:00:00	SPY	ETF	237.21	237.21	237.09	237.11	26516.0
2017-05-19 07:00:00	SPY	ETF	237.11	237.28	237.1	237.19	137933.0
2017-05-19 08:00:00	SPY	ETF	237.18	237.36	236.77	237.27	616317.0
2017-05-19 09:00:00	SPY	ETF	237.29	238.18	237.09	237.99	11876358.0
2017-05-19 10:00:00	SPY	ETF	238.0	238.49	237.96	238.42	20590284.0
2017-05-19 11:00:00	SPY	ETF	238.42	238.6	238.28	238.59	11545574.0
2017-05-19 12:00:00	SPY	ETF	238.59	238.95	238.58	238.84	10111803.0
2017-05-19 13:00:00	SPY	ETF	238.8483	238.85	238.64	238.76	10626279.0
2017-05-19 14:00:00	SPY	ETF	238.765	239.08	238.68	238.86	7215028.0
2017-05-19 15:00:00	SPY	ETF	238.8508	238.9	238.09	238.3	25366999.0
2017-05-19 16:00:00	SPY	ETF	238.3	238.54	238.22	238.54	14833200.0
2017-05-19 17:00:00	SPY	ETF	238.5	238.52	238.37	238.47	468827.0
2017-05-19 18:00:00	SPY	ETF	238.48	238.55	238.31	238.33	252387.0
2017-05-19 19:00:00	SPY	ETF	238.37	238.49	237.99	237.99	320155.0
2017-05-19 04:00:00	QQQ	ETF	137.27	137.64	137.27	137.64	455.0
2017-05-19 05:00:00	QQQ	ETF	137.7	137.75	137.62	137.75	32617.0
2017-05-19 06:00:00	QQQ	ETF	137.63	137.63	137.56	137.56	6050.0
2017-05-19 07:00:00	QQQ	ETF	137.56	137.68	137.56	137.65	33371.0
2017-05-19 08:00:00	QQQ	ETF	137.64	137.87	137.61	137.78	610237.0
2017-05-19 09:00:00	QQQ	ETF	137.78	138.2099	137.66	138.03	4245641.0
2017-05-19 10:00:00	QQQ	ETF	138.03	138.29	137.9754	138.21	2956688.0
2017-05-19 11:00:00	QQQ	ETF	138.215	138.32	138.015	138.2	2086897.0
2017-05-19 12:00:00	QQQ	ETF	138.21	138.42	138.191	138.34	2594033.0
2017-05-19 13:00:00	QQQ	ETF	138.3401	138.37	138.215	138.24	1817225.0
2017-05-19 14:00:00	QQQ	ETF	138.24	138.3854	138.16	138.26	2125673.0
2017-05-19 15:00:00	QQQ	ETF	138.26	138.2802	137.76	137.85	8157760.0
2017-05-19 16:00:00	QQQ	ETF	137.84	137.92	137.82	137.88	2770292.0
2017-05-19 17:00:00	QQQ	ETF	137.88	137.88	137.83	137.85	2194951.0
2017-05-19 18:00:00	QQQ	ETF	137.84	137.92	137.84	137.87	3681.0
2017-05-19 19:00:00	QQQ	ETF	137.85	137.87	137.56	137.64	12323.0
2017-05-19 04:00:00	IWM	ETF	135.32	135.32	135.32	135.32	3800.0
2017-05-19 05:00:00	IWM	ETF	135.77	135.77	135.66	135.66	3240.0
2017-05-19 06:00:00	IWM	ETF	135.47	135.54	135.47	135.54	2320.0
2017-05-19 07:00:00	IWM	ETF	135.64	135.82	135.59	135.77	13265.0
2017-05-19 08:00:00	IWM	ETF	135.68	135.8	135.58	135.66	68315.0
2017-05-19 09:00:00	IWM	ETF	135.66	136.44	135.44	136.195	3694116.0
2017-05-19 10:00:00	IWM	ETF	136.2	136.58	135.97	136.33	4533491.0
2017-05-19 11:00:00	IWM	ETF	136.33	136.42	135.86	136.18	3935444.0
2017-05-19 12:00:00	IWM	ETF	136.18	136.56	136.11	136.48	1876533.0
2017-05-19 13:00:00	IWM	ETF	136.475	136.55	136.32	136.51	1983421.0
2017-05-19 14:00:00	IWM	ETF	136.52	136.76	136.4	136.64	2051677.0
2017-05-19 15:00:00	IWM	ETF	136.64	136.67	135.86	135.98	10044061.0
2017-05-19 16:00:00	IWM	ETF	136.03	136.05	135.93	136.0	4862353.0
2017-05-19 17:00:00	IWM	ETF	136.0	136.03	135.98	136.03	4141.0
2017-05-19 18:00:00	IWM	ETF	136.08	136.1	135.95	135.95	12604.0
2017-05-19 19:00:00	IWM	ETF	136.0	136.0	135.87	135.87	7431.0
2017-05-19 04:00:00	DIA	ETF	206.38	206.66	206.38	206.66	400.0
2017-05-19 05:00:00	DIA	ETF	206.75	206.75	206.75	206.75	100.0

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

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