PREVIEW / etf_1hour / 2017-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-29.parquet
  size:    283 KB
  rows:    9,243

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-29 04:00:00	SPY	ETF	242.73	242.87	242.46	242.64	46919.0
2017-08-29 05:00:00	SPY	ETF	242.5	243.04	242.43	242.95	22265.0
2017-08-29 06:00:00	SPY	ETF	242.93	243.09	242.78	243.09	46252.0
2017-08-29 07:00:00	SPY	ETF	243.14	243.52	243.14	243.43	364693.0
2017-08-29 08:00:00	SPY	ETF	243.43	243.53	243.11	243.26	806234.0
2017-08-29 09:00:00	SPY	ETF	243.25	243.85	242.93	243.8	8936828.0
2017-08-29 10:00:00	SPY	ETF	243.8	244.33	243.47	244.22	9831491.0
2017-08-29 11:00:00	SPY	ETF	244.21	244.57	244.13	244.4	6556485.0
2017-08-29 12:00:00	SPY	ETF	244.4	244.7	244.32	244.575	6002628.0
2017-08-29 13:00:00	SPY	ETF	244.58	244.76	244.42	244.63	3620279.0
2017-08-29 14:00:00	SPY	ETF	244.63	244.95	244.57	244.92	2817952.0
2017-08-29 15:00:00	SPY	ETF	244.92	245.15	244.8	244.85	8247025.0
2017-08-29 16:00:00	SPY	ETF	244.84	245.08	244.6462	245.0	3000645.0
2017-08-29 17:00:00	SPY	ETF	244.98	244.99	244.86	244.93	170953.0
2017-08-29 18:00:00	SPY	ETF	244.93	244.95	244.82	244.88	99992.0
2017-08-29 19:00:00	SPY	ETF	244.89	245.2	244.89	245.15	101941.0
2017-08-29 04:00:00	QQQ	ETF	141.2	141.25	140.92	141.0	77745.0
2017-08-29 05:00:00	QQQ	ETF	140.97	141.26	140.85	141.23	29486.0
2017-08-29 06:00:00	QQQ	ETF	141.23	141.31	141.15	141.31	6499.0
2017-08-29 07:00:00	QQQ	ETF	141.35	141.49	141.32	141.45	115200.0
2017-08-29 08:00:00	QQQ	ETF	141.43	141.51	141.21	141.32	263308.0
2017-08-29 09:00:00	QQQ	ETF	141.27	141.98	141.06	141.92	5380327.0
2017-08-29 10:00:00	QQQ	ETF	141.92	142.53	141.76	142.4	5197909.0
2017-08-29 11:00:00	QQQ	ETF	142.39	142.91	142.36	142.795	1932588.0
2017-08-29 12:00:00	QQQ	ETF	142.79	142.94	142.72	142.81	840550.0
2017-08-29 13:00:00	QQQ	ETF	142.8099	142.9	142.6343	142.76	1402717.0
2017-08-29 14:00:00	QQQ	ETF	142.76	143.07	142.74	143.04	1432117.0
2017-08-29 15:00:00	QQQ	ETF	143.05	143.21	142.91	142.98	4088647.0
2017-08-29 16:00:00	QQQ	ETF	142.97	143.12	141.6367	143.09	1340374.0
2017-08-29 17:00:00	QQQ	ETF	143.12	143.12	143.08	143.08	650.0
2017-08-29 18:00:00	QQQ	ETF	143.08	143.08	142.99	143.03	16547.0
2017-08-29 19:00:00	QQQ	ETF	143.04	143.29	143.04	143.26	40694.0
2017-08-29 04:00:00	IWM	ETF	136.32	136.34	136.15	136.34	19855.0
2017-08-29 05:00:00	IWM	ETF	136.14	136.5	136.08	136.48	3835.0
2017-08-29 06:00:00	IWM	ETF	136.46	136.6	136.46	136.6	2903.0
2017-08-29 07:00:00	IWM	ETF	136.6	136.81	136.6	136.7	86729.0
2017-08-29 08:00:00	IWM	ETF	136.69	136.85	136.54	136.64	100456.0
2017-08-29 09:00:00	IWM	ETF	136.64	137.13	136.39	136.8	2252360.0
2017-08-29 10:00:00	IWM	ETF	136.82	137.08	136.23	136.84	3225349.0
2017-08-29 11:00:00	IWM	ETF	136.83	137.25	136.61	137.04	2353963.0
2017-08-29 12:00:00	IWM	ETF	137.03	137.73	136.96	137.67	1885627.0
2017-08-29 13:00:00	IWM	ETF	137.68	137.81	137.41	137.505	1734016.0
2017-08-29 14:00:00	IWM	ETF	137.5066	137.73	137.42	137.66	940258.0
2017-08-29 15:00:00	IWM	ETF	137.66	137.76	137.47	137.52	2409064.0
2017-08-29 16:00:00	IWM	ETF	137.49	137.56	136.7203	137.49	2502999.0
2017-08-29 18:00:00	IWM	ETF	137.49	137.49	137.49	137.49	200.0
2017-08-29 19:00:00	IWM	ETF	137.5	137.6	137.49	137.6	1335.0
2017-08-29 06:00:00	DIA	ETF	216.8	216.8	216.77	216.77	700.0
2017-08-29 08:00:00	DIA	ETF	216.83	216.9	216.83	216.84	1000.0
2017-08-29 09:00:00	DIA	ETF	216.76	217.615	216.62	217.61	426702.0

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

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