PREVIEW / etf_1hour / 2017-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-30.parquet
  size:    276 KB
  rows:    9,007

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-30 04:00:00	SPY	ETF	245.41	245.41	245.31	245.33	4234.0
2017-08-30 05:00:00	SPY	ETF	245.31	245.31	245.16	245.16	3700.0
2017-08-30 06:00:00	SPY	ETF	245.15	245.26	245.13	245.24	13514.0
2017-08-30 07:00:00	SPY	ETF	245.23	245.26	245.01	245.13	111163.0
2017-08-30 08:00:00	SPY	ETF	245.21	245.21	244.67	244.7	593256.0
2017-08-30 09:00:00	SPY	ETF	244.72	245.15	244.62	245.11	5184670.0
2017-08-30 10:00:00	SPY	ETF	245.11	245.49	244.98	245.47	8402527.0
2017-08-30 11:00:00	SPY	ETF	245.47	245.59	245.33	245.51	5596505.0
2017-08-30 12:00:00	SPY	ETF	245.52	245.83	245.44	245.81	3983027.0
2017-08-30 13:00:00	SPY	ETF	245.805	246.29	245.7797	246.22	5815752.0
2017-08-30 14:00:00	SPY	ETF	246.23	246.32	246.035	246.23	6889414.0
2017-08-30 15:00:00	SPY	ETF	246.23	246.25	245.66	246.04	13950347.0
2017-08-30 16:00:00	SPY	ETF	246.03	246.08	245.92	245.94	8717589.0
2017-08-30 17:00:00	SPY	ETF	245.94	246.0	245.9	245.91	340435.0
2017-08-30 18:00:00	SPY	ETF	245.91	246.0	245.88	245.95	221294.0
2017-08-30 19:00:00	SPY	ETF	245.98	246.12	245.95	246.1	34926.0
2017-08-30 04:00:00	QQQ	ETF	143.54	143.58	143.36	143.36	15059.0
2017-08-30 05:00:00	QQQ	ETF	143.33	143.33	143.29	143.29	600.0
2017-08-30 06:00:00	QQQ	ETF	143.3	143.3	143.26	143.26	340.0
2017-08-30 07:00:00	QQQ	ETF	143.33	143.36	143.17	143.3	71911.0
2017-08-30 08:00:00	QQQ	ETF	143.29	143.36	142.94	143.0	170800.0
2017-08-30 09:00:00	QQQ	ETF	143.0	143.71	142.97	143.67	3705110.0
2017-08-30 10:00:00	QQQ	ETF	143.66	143.98	143.49	143.97	2852144.0
2017-08-30 11:00:00	QQQ	ETF	143.97	144.01	143.82	143.9338	2670378.0
2017-08-30 12:00:00	QQQ	ETF	143.94	144.31	143.88	144.29	2981965.0
2017-08-30 13:00:00	QQQ	ETF	144.285	144.8301	144.2599	144.76	5100142.0
2017-08-30 14:00:00	QQQ	ETF	144.76	144.89	144.64	144.76	2821619.0
2017-08-30 15:00:00	QQQ	ETF	144.76	144.8	144.42	144.66	8276495.0
2017-08-30 16:00:00	QQQ	ETF	144.66	144.74	144.64	144.7	1404915.0
2017-08-30 17:00:00	QQQ	ETF	144.67	144.74	143.9647	144.7	44941.0
2017-08-30 18:00:00	QQQ	ETF	144.68	144.74	144.64	144.72	11425.0
2017-08-30 19:00:00	QQQ	ETF	144.74	144.84	144.74	144.83	38270.0
2017-08-30 04:00:00	IWM	ETF	137.82	137.84	137.81	137.81	16300.0
2017-08-30 05:00:00	IWM	ETF	137.66	137.66	137.66	137.66	200.0
2017-08-30 06:00:00	IWM	ETF	137.6	137.67	137.55	137.65	1780.0
2017-08-30 07:00:00	IWM	ETF	137.64	137.64	137.49	137.5	4103.0
2017-08-30 08:00:00	IWM	ETF	137.48	137.49	137.21	137.24	27784.0
2017-08-30 09:00:00	IWM	ETF	137.2	137.7362	137.16	137.65	1386914.0
2017-08-30 10:00:00	IWM	ETF	137.64	138.1	137.51	138.0399	2261304.0
2017-08-30 11:00:00	IWM	ETF	138.0317	138.18	137.85	138.01	2007590.0
2017-08-30 12:00:00	IWM	ETF	138.0	138.25	137.96	138.19	993737.0
2017-08-30 13:00:00	IWM	ETF	138.18	138.37	138.09	138.11	2345051.0
2017-08-30 14:00:00	IWM	ETF	138.1	138.35	138.02	138.35	1513555.0
2017-08-30 15:00:00	IWM	ETF	138.35	138.51	138.19	138.35	3377686.0
2017-08-30 16:00:00	IWM	ETF	138.37	138.44	138.17	138.17	577536.0
2017-08-30 17:00:00	IWM	ETF	138.2	138.22	138.2	138.22	1003.0
2017-08-30 18:00:00	IWM	ETF	138.22	138.26	138.21	138.26	2279.0
2017-08-30 19:00:00	IWM	ETF	138.3	138.4	138.3	138.36	3867.0
2017-08-30 07:00:00	DIA	ETF	219.0	219.0	219.0	219.0	100.0
2017-08-30 08:00:00	DIA	ETF	218.96	218.97	218.6	218.6	8656.0

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

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