PREVIEW / etf_1hour / 2016-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-06.parquet
  size:    257 KB
  rows:    8,259

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
2016-01-06 04:00:00	SPY	ETF	199.52	199.85	199.35	199.53	282108.0
2016-01-06 05:00:00	SPY	ETF	199.5	199.59	198.75	198.79	163271.0
2016-01-06 06:00:00	SPY	ETF	198.79	198.84	198.06	198.8	256517.0
2016-01-06 07:00:00	SPY	ETF	198.8	198.83	197.87	197.97	1094727.0
2016-01-06 08:00:00	SPY	ETF	197.97	199.11	197.75	198.38	2253045.0
2016-01-06 09:00:00	SPY	ETF	198.38	201.35	197.98	199.2	20173043.0
2016-01-06 10:00:00	SPY	ETF	199.18	199.69	198.73	199.26	21645816.0
2016-01-06 11:00:00	SPY	ETF	199.25	200.06	199.21	199.32	13966124.0
2016-01-06 12:00:00	SPY	ETF	199.32	199.73	199.06	199.23	8483444.0
2016-01-06 13:00:00	SPY	ETF	199.235	199.32	198.68	198.731	8513053.0
2016-01-06 14:00:00	SPY	ETF	198.73	199.34	197.65	197.75	22693967.0
2016-01-06 15:00:00	SPY	ETF	197.75	198.93	197.6	198.79	36220511.0
2016-01-06 16:00:00	SPY	ETF	198.79	199.27	198.484	199.16	14391453.0
2016-01-06 17:00:00	SPY	ETF	199.2	199.28	199.2	199.28	258750.0
2016-01-06 18:00:00	SPY	ETF	199.28	199.45	198.85	199.44	215870.0
2016-01-06 19:00:00	SPY	ETF	199.44	199.56	199.24	199.29	189245.0
2016-01-06 04:00:00	QQQ	ETF	108.33	108.35	108.09	108.16	21960.0
2016-01-06 05:00:00	QQQ	ETF	108.1	108.1	107.67	107.7	3410.0
2016-01-06 06:00:00	QQQ	ETF	107.67	107.67	107.4	107.56	42408.0
2016-01-06 07:00:00	QQQ	ETF	107.54	107.59	107.13	107.17	102024.0
2016-01-06 08:00:00	QQQ	ETF	107.17	109.31	107.1	109.31	234283.0
2016-01-06 09:00:00	QQQ	ETF	107.41	108.22	107.23	108.1768	6254922.0
2016-01-06 10:00:00	QQQ	ETF	108.16	108.65	107.86	108.51	5112965.0
2016-01-06 11:00:00	QQQ	ETF	108.49	108.89	108.335	108.52	3684652.0
2016-01-06 12:00:00	QQQ	ETF	108.53	108.66	108.285	108.361	2303643.0
2016-01-06 13:00:00	QQQ	ETF	108.37	108.47	108.01	108.05	2380909.0
2016-01-06 14:00:00	QQQ	ETF	108.05	108.48	107.495	107.56	5589159.0
2016-01-06 15:00:00	QQQ	ETF	107.55	108.35	107.47	108.27	9587348.0
2016-01-06 16:00:00	QQQ	ETF	108.27	108.61	108.26	108.58	1035498.0
2016-01-06 17:00:00	QQQ	ETF	108.6	108.61	108.55	108.6	6481.0
2016-01-06 18:00:00	QQQ	ETF	108.58	108.65	108.5	108.65	110995.0
2016-01-06 19:00:00	QQQ	ETF	108.65	108.75	108.53	108.58	16751.0
2016-01-06 04:00:00	IWM	ETF	109.5	109.5	109.23	109.4	560.0
2016-01-06 05:00:00	IWM	ETF	109.0	109.0	108.93	108.93	350.0
2016-01-06 06:00:00	IWM	ETF	108.8	108.8	108.51	108.74	3460.0
2016-01-06 07:00:00	IWM	ETF	108.82	108.84	108.42	108.44	137401.0
2016-01-06 08:00:00	IWM	ETF	108.47	110.2	108.3	108.5	154110.0
2016-01-06 09:00:00	IWM	ETF	108.5	109.23	108.35	109.18	4513858.0
2016-01-06 10:00:00	IWM	ETF	109.17	109.48	108.875	109.23	3396438.0
2016-01-06 11:00:00	IWM	ETF	109.23	109.6	109.02	109.045	3298859.0
2016-01-06 12:00:00	IWM	ETF	109.05	109.15	108.74	108.81	3066027.0
2016-01-06 13:00:00	IWM	ETF	108.805	108.94	108.54	108.57	2444336.0
2016-01-06 14:00:00	IWM	ETF	108.58	108.79	108.04	108.0836	4729542.0
2016-01-06 15:00:00	IWM	ETF	108.08	108.86	108.0	108.605	8061568.0
2016-01-06 16:00:00	IWM	ETF	108.59	108.89	108.55	108.81	1749568.0
2016-01-06 17:00:00	IWM	ETF	108.76	108.79	108.71	108.76	19785.0
2016-01-06 18:00:00	IWM	ETF	108.76	108.83	108.74	108.74	3400.0
2016-01-06 19:00:00	IWM	ETF	108.79	108.79	108.75	108.75	2000.0
2016-01-06 04:00:00	DIA	ETF	169.83	170.0	169.8	169.84	500.0
2016-01-06 05:00:00	DIA	ETF	169.63	169.63	169.33	169.33	200.0

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

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