PREVIEW / etf_1hour / 2016-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-04.parquet
  size:    257 KB
  rows:    8,238

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-03-04 04:00:00	SPY	ETF	199.56	199.65	199.31	199.6	32283.0
2016-03-04 05:00:00	SPY	ETF	199.6	199.83	199.6	199.83	10827.0
2016-03-04 06:00:00	SPY	ETF	199.83	200.05	199.83	200.01	64640.0
2016-03-04 07:00:00	SPY	ETF	199.92	200.18	199.84	200.07	205070.0
2016-03-04 08:00:00	SPY	ETF	200.06	200.85	199.66	199.72	4507656.0
2016-03-04 09:00:00	SPY	ETF	199.7	200.385	199.03	199.29	16038535.0
2016-03-04 10:00:00	SPY	ETF	199.29	200.38	199.06	200.23	17205685.0
2016-03-04 11:00:00	SPY	ETF	200.23	200.98	200.22	200.74	16219541.0
2016-03-04 12:00:00	SPY	ETF	200.74	200.93	200.45	200.78	9618083.0
2016-03-04 13:00:00	SPY	ETF	200.78	201.35	200.54	201.2405	11375232.0
2016-03-04 14:00:00	SPY	ETF	201.23	201.25	199.77	200.0411	15735113.0
2016-03-04 15:00:00	SPY	ETF	200.041	200.65	199.71	200.38	25084365.0
2016-03-04 16:00:00	SPY	ETF	200.38	200.47	199.708	200.06	10890829.0
2016-03-04 17:00:00	SPY	ETF	200.1	200.43	199.92	199.99	335250.0
2016-03-04 18:00:00	SPY	ETF	199.98	200.01	199.94	199.98	260313.0
2016-03-04 19:00:00	SPY	ETF	199.99	200.05	199.95	200.05	24264.0
2016-03-04 04:00:00	QQQ	ETF	105.45	105.45	105.41	105.41	347.0
2016-03-04 05:00:00	QQQ	ETF	105.53	105.59	105.53	105.59	600.0
2016-03-04 06:00:00	QQQ	ETF	105.66	105.79	105.66	105.79	2799.0
2016-03-04 07:00:00	QQQ	ETF	105.83	105.95	105.76	105.94	14661.0
2016-03-04 08:00:00	QQQ	ETF	105.91	106.3	105.6	105.6	746378.0
2016-03-04 09:00:00	QQQ	ETF	105.58	105.82	104.97	105.15	4864773.0
2016-03-04 10:00:00	QQQ	ETF	105.16	105.71	104.99	105.61	3829480.0
2016-03-04 11:00:00	QQQ	ETF	105.61	106.075	105.61	105.87	3089783.0
2016-03-04 12:00:00	QQQ	ETF	105.8707	106.05	105.72	106.0	1968956.0
2016-03-04 13:00:00	QQQ	ETF	106.005	106.35	105.85	106.275	2438562.0
2016-03-04 14:00:00	QQQ	ETF	106.28	106.3	105.39	105.5	3972362.0
2016-03-04 15:00:00	QQQ	ETF	105.5	105.83	105.33	105.665	4928471.0
2016-03-04 16:00:00	QQQ	ETF	105.66	105.69	105.44	105.51	2041277.0
2016-03-04 17:00:00	QQQ	ETF	105.5	105.5	105.47	105.48	4190.0
2016-03-04 18:00:00	QQQ	ETF	105.51	105.51	105.48	105.49	1158.0
2016-03-04 19:00:00	QQQ	ETF	105.4901	105.52	105.45	105.46	5922.0
2016-03-04 04:00:00	IWM	ETF	106.83	106.83	106.83	106.83	999.0
2016-03-04 06:00:00	IWM	ETF	107.07	107.15	107.07	107.15	2100.0
2016-03-04 07:00:00	IWM	ETF	107.16	107.25	107.1	107.22	36069.0
2016-03-04 08:00:00	IWM	ETF	107.12	107.54	106.91	106.91	302797.0
2016-03-04 09:00:00	IWM	ETF	106.94	107.27	106.67	106.94	3694431.0
2016-03-04 10:00:00	IWM	ETF	106.94	107.6	106.86	107.51	5117431.0
2016-03-04 11:00:00	IWM	ETF	107.52	108.19	107.5	108.1644	4037919.0
2016-03-04 12:00:00	IWM	ETF	108.17	108.3	107.94	108.16	3168376.0
2016-03-04 13:00:00	IWM	ETF	108.16	108.32	107.941	108.25	3123276.0
2016-03-04 14:00:00	IWM	ETF	108.25	108.25	107.23	107.47	5138617.0
2016-03-04 15:00:00	IWM	ETF	107.475	107.73	107.23	107.69	8620430.0
2016-03-04 16:00:00	IWM	ETF	107.7	108.24	107.53	107.59	1109417.0
2016-03-04 17:00:00	IWM	ETF	107.62	107.69	107.62	107.68	5525.0
2016-03-04 18:00:00	IWM	ETF	107.51	107.51	107.51	107.51	100.0
2016-03-04 08:00:00	DIA	ETF	169.73	170.25	169.37	169.55	5078.0
2016-03-04 09:00:00	DIA	ETF	169.37	169.75	168.94	169.1199	453096.0
2016-03-04 10:00:00	DIA	ETF	169.1	169.92	168.92	169.81	597663.0
2016-03-04 11:00:00	DIA	ETF	169.82	170.33	169.82	170.11	441635.0

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

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