PREVIEW / etf_1hour / 2017-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-10.parquet
  size:    293 KB
  rows:    9,517

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-08-10 04:00:00	SPY	ETF	247.04	247.04	246.59	246.61	81792.0
2017-08-10 05:00:00	SPY	ETF	246.52	246.66	246.39	246.55	96799.0
2017-08-10 06:00:00	SPY	ETF	246.56	246.69	246.35	246.49	55547.0
2017-08-10 07:00:00	SPY	ETF	246.47	246.62	246.3	246.55	284542.0
2017-08-10 08:00:00	SPY	ETF	246.45	246.61	246.3	246.41	341929.0
2017-08-10 09:00:00	SPY	ETF	246.4	246.44	245.73	245.87	9780873.0
2017-08-10 10:00:00	SPY	ETF	245.88	245.92	245.02	245.44	17897537.0
2017-08-10 11:00:00	SPY	ETF	245.43	245.56	244.89	245.04	11803486.0
2017-08-10 12:00:00	SPY	ETF	245.04	245.12	244.44	244.89	12758072.0
2017-08-10 13:00:00	SPY	ETF	244.88	245.14	244.63	244.82	7539550.0
2017-08-10 14:00:00	SPY	ETF	244.82	245.47	244.59	244.9909	10493861.0
2017-08-10 15:00:00	SPY	ETF	244.99	245.11	243.7	243.79	31131432.0
2017-08-10 16:00:00	SPY	ETF	243.79	244.15	243.41	243.57	14340408.0
2017-08-10 17:00:00	SPY	ETF	243.55	245.0505	243.4	243.54	425255.0
2017-08-10 18:00:00	SPY	ETF	243.54	243.79	243.39	243.79	362801.0
2017-08-10 19:00:00	SPY	ETF	243.72	243.79	243.7	243.75	73575.0
2017-08-10 04:00:00	QQQ	ETF	143.79	143.79	143.56	143.57	28689.0
2017-08-10 05:00:00	QQQ	ETF	143.57	143.59	143.43	143.53	47277.0
2017-08-10 06:00:00	QQQ	ETF	143.57	143.58	143.34	143.4	17800.0
2017-08-10 07:00:00	QQQ	ETF	143.39	143.44	143.23	143.41	241795.0
2017-08-10 08:00:00	QQQ	ETF	143.43	143.5	143.31	143.34	113880.0
2017-08-10 09:00:00	QQQ	ETF	143.36	143.4	142.76	142.88	5698043.0
2017-08-10 10:00:00	QQQ	ETF	142.89	142.92	142.11	142.62	9323805.0
2017-08-10 11:00:00	QQQ	ETF	142.61	142.72	141.88	141.98	4219845.0
2017-08-10 12:00:00	QQQ	ETF	141.993	142.12	141.36	141.79	7472352.0
2017-08-10 13:00:00	QQQ	ETF	141.8	142.11	141.67	141.84	4422261.0
2017-08-10 14:00:00	QQQ	ETF	141.84	142.29	141.63	141.99	4668958.0
2017-08-10 15:00:00	QQQ	ETF	141.98	142.1	140.89	141.02	13740003.0
2017-08-10 16:00:00	QQQ	ETF	141.03	142.0962	140.53	140.63	3844610.0
2017-08-10 17:00:00	QQQ	ETF	140.63	141.9499	140.39	140.46	221437.0
2017-08-10 18:00:00	QQQ	ETF	140.47	140.76	140.44	140.7	77929.0
2017-08-10 19:00:00	QQQ	ETF	140.69	140.76	140.64	140.65	23827.0
2017-08-10 04:00:00	IWM	ETF	138.56	138.56	138.41	138.43	1577.0
2017-08-10 05:00:00	IWM	ETF	138.33	138.37	138.24	138.37	8738.0
2017-08-10 06:00:00	IWM	ETF	138.47	138.48	138.22	138.22	8998.0
2017-08-10 07:00:00	IWM	ETF	138.28	138.49	138.15	138.47	106905.0
2017-08-10 08:00:00	IWM	ETF	138.44	138.49	138.21	138.23	97700.0
2017-08-10 09:00:00	IWM	ETF	138.24	138.28	137.83	137.94	2927650.0
2017-08-10 10:00:00	IWM	ETF	137.94	137.95	136.975	137.38	6186616.0
2017-08-10 11:00:00	IWM	ETF	137.37	137.48	136.94	137.0348	3986706.0
2017-08-10 12:00:00	IWM	ETF	137.03	137.03	136.48	136.77	3281748.0
2017-08-10 13:00:00	IWM	ETF	136.77	137.34	136.66	136.86	4800402.0
2017-08-10 14:00:00	IWM	ETF	136.85	137.4	136.67	137.04	3719383.0
2017-08-10 15:00:00	IWM	ETF	137.04	137.15	136.26	136.31	6935458.0
2017-08-10 16:00:00	IWM	ETF	136.3	136.46	135.82	135.91	4300684.0
2017-08-10 17:00:00	IWM	ETF	135.92	137.5994	135.7	135.79	82542.0
2017-08-10 18:00:00	IWM	ETF	135.99	136.15	135.93	136.08	15302.0
2017-08-10 19:00:00	IWM	ETF	136.1	136.2	136.04	136.04	18405.0
2017-08-10 04:00:00	DIA	ETF	220.22	220.22	220.22	220.22	200.0
2017-08-10 05:00:00	DIA	ETF	220.19	220.19	220.02	220.02	300.0

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

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