PREVIEW / etf_1hour / 2017-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-22.parquet
  size:    284 KB
  rows:    9,382

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-11-22 04:00:00	SPY	ETF	259.86	259.92	259.86	259.92	1700.0
2017-11-22 05:00:00	SPY	ETF	259.92	259.95	259.92	259.95	5400.0
2017-11-22 06:00:00	SPY	ETF	259.92	259.95	259.88	259.93	3557.0
2017-11-22 07:00:00	SPY	ETF	259.97	260.19	259.97	260.19	188183.0
2017-11-22 08:00:00	SPY	ETF	259.99	260.18	259.93	259.99	497045.0
2017-11-22 09:00:00	SPY	ETF	259.99	260.15	259.9	259.98	4112520.0
2017-11-22 10:00:00	SPY	ETF	259.98	260.04	259.68	259.94	7382986.0
2017-11-22 11:00:00	SPY	ETF	259.95	260.0	259.67	259.76	4346701.0
2017-11-22 12:00:00	SPY	ETF	259.77	259.8	259.6	259.775	2782994.0
2017-11-22 13:00:00	SPY	ETF	259.77	259.82	259.57	259.8	5137577.0
2017-11-22 14:00:00	SPY	ETF	259.805	259.97	259.79	259.88	4127662.0
2017-11-22 15:00:00	SPY	ETF	259.87	259.97	259.74	259.77	7784494.0
2017-11-22 16:00:00	SPY	ETF	259.78	260.07	259.51	259.54	7765703.0
2017-11-22 17:00:00	SPY	ETF	259.55	259.61	259.54	259.59	135107.0
2017-11-22 18:00:00	SPY	ETF	259.58	259.66	259.54	259.65	98998.0
2017-11-22 19:00:00	SPY	ETF	259.64	259.7692	259.58	259.66	229010.0
2017-11-22 04:00:00	QQQ	ETF	155.47	155.47	155.4	155.4	11100.0
2017-11-22 05:00:00	QQQ	ETF	155.48	155.49	155.4	155.41	4997.0
2017-11-22 06:00:00	QQQ	ETF	155.43	155.43	155.38	155.38	6164.0
2017-11-22 07:00:00	QQQ	ETF	155.59	155.75	155.57	155.75	26092.0
2017-11-22 08:00:00	QQQ	ETF	155.71	155.74	155.54	155.59	59476.0
2017-11-22 09:00:00	QQQ	ETF	155.61	155.77	155.341	155.49	1897038.0
2017-11-22 10:00:00	QQQ	ETF	155.495	155.65	155.37	155.58	2798737.0
2017-11-22 11:00:00	QQQ	ETF	155.58	155.69	155.41	155.57	2397639.0
2017-11-22 12:00:00	QQQ	ETF	155.57	155.64	155.51	155.6336	633626.0
2017-11-22 13:00:00	QQQ	ETF	155.6292	155.646	155.51	155.62	658639.0
2017-11-22 14:00:00	QQQ	ETF	155.62	155.84	155.6023	155.755	1673792.0
2017-11-22 15:00:00	QQQ	ETF	155.75	155.77	155.61	155.69	2135641.0
2017-11-22 16:00:00	QQQ	ETF	155.69	155.72	155.64	155.64	911472.0
2017-11-22 17:00:00	QQQ	ETF	155.66	155.7	155.65	155.65	156504.0
2017-11-22 18:00:00	QQQ	ETF	155.65	155.72	155.65	155.7	1800.0
2017-11-22 19:00:00	QQQ	ETF	155.71	155.72	155.65	155.71	41761.0
2017-11-22 04:00:00	IWM	ETF	151.04	151.16	151.04	151.16	1300.0
2017-11-22 05:00:00	IWM	ETF	151.22	151.22	151.2	151.2	2000.0
2017-11-22 06:00:00	IWM	ETF	151.22	151.3	151.22	151.27	8374.0
2017-11-22 07:00:00	IWM	ETF	151.27	151.44	151.26	151.44	21658.0
2017-11-22 08:00:00	IWM	ETF	151.44	151.44	151.28	151.31	34834.0
2017-11-22 09:00:00	IWM	ETF	151.32	151.77	151.28	151.51	2505951.0
2017-11-22 10:00:00	IWM	ETF	151.51	151.64	150.8345	151.395	2612825.0
2017-11-22 11:00:00	IWM	ETF	151.4	151.43	151.131	151.25	1562420.0
2017-11-22 12:00:00	IWM	ETF	151.26	151.31	151.06	151.28	999368.0
2017-11-22 13:00:00	IWM	ETF	151.28	151.285	151.08	151.19	481156.0
2017-11-22 14:00:00	IWM	ETF	151.2	151.33	151.15	151.24	868182.0
2017-11-22 15:00:00	IWM	ETF	151.24	151.24	150.86	150.88	2068946.0
2017-11-22 16:00:00	IWM	ETF	150.89	151.1506	150.59	150.59	1819196.0
2017-11-22 17:00:00	IWM	ETF	150.59	150.89	150.32	150.46	310181.0
2017-11-22 18:00:00	IWM	ETF	150.52	150.55	150.47	150.55	10027.0
2017-11-22 19:00:00	IWM	ETF	150.55	150.8415	150.52	150.59	159303.0
2017-11-22 07:00:00	DIA	ETF	236.0	236.1	236.0	236.1	1300.0
2017-11-22 08:00:00	DIA	ETF	236.1	236.15	235.92	235.92	2350.0

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

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