PREVIEW / etf_1hour / 2015-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-20.parquet
  size:    246 KB
  rows:    7,851

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
2015-01-20 04:00:00	SPY	ETF	202.0	202.25	201.99	201.99	2527.0
2015-01-20 05:00:00	SPY	ETF	202.26	202.51	202.16	202.49	64237.0
2015-01-20 06:00:00	SPY	ETF	202.42	202.73	202.22	202.7	84725.0
2015-01-20 07:00:00	SPY	ETF	202.7	203.0	202.61	202.85	581114.0
2015-01-20 08:00:00	SPY	ETF	202.86	202.91	201.12	202.62	1870067.0
2015-01-20 09:00:00	SPY	ETF	202.62	202.72	200.75	201.03	21768351.0
2015-01-20 10:00:00	SPY	ETF	201.04	201.575	200.53	200.81	21233012.0
2015-01-20 11:00:00	SPY	ETF	200.82	201.12	200.17	200.475	20228782.0
2015-01-20 12:00:00	SPY	ETF	200.46	201.065	200.3	200.94	9168783.0
2015-01-20 13:00:00	SPY	ETF	200.93	201.4299	200.57	201.2	9894318.0
2015-01-20 14:00:00	SPY	ETF	201.195	202.17	201.14	202.16	13120382.0
2015-01-20 15:00:00	SPY	ETF	202.16	202.35	201.77	202.04	20320946.0
2015-01-20 16:00:00	SPY	ETF	202.06	202.13	200.721	201.94	6011152.0
2015-01-20 17:00:00	SPY	ETF	201.94	202.07	201.94	201.99	218331.0
2015-01-20 18:00:00	SPY	ETF	202.0	202.15	201.94	202.1	80138.0
2015-01-20 19:00:00	SPY	ETF	202.09	202.09	201.91	201.95	37046.0
2015-01-20 04:00:00	QQQ	ETF	101.7	101.7	101.16	101.16	600.0
2015-01-20 05:00:00	QQQ	ETF	101.14	101.42	101.14	101.42	23000.0
2015-01-20 06:00:00	QQQ	ETF	101.37	101.53	101.37	101.51	28200.0
2015-01-20 07:00:00	QQQ	ETF	101.51	101.71	101.47	101.62	30494.0
2015-01-20 08:00:00	QQQ	ETF	101.62	101.64	101.44	101.45	117116.0
2015-01-20 09:00:00	QQQ	ETF	101.46	101.6458	100.61	100.79	6308373.0
2015-01-20 10:00:00	QQQ	ETF	100.78	101.14	100.5	100.64	5086557.0
2015-01-20 11:00:00	QQQ	ETF	100.64	100.875	100.29	100.52	3304825.0
2015-01-20 12:00:00	QQQ	ETF	100.51	100.96	100.415	100.91	1994936.0
2015-01-20 13:00:00	QQQ	ETF	100.9	101.24	100.71	101.19	2251611.0
2015-01-20 14:00:00	QQQ	ETF	101.19	101.79	101.16	101.78	3404388.0
2015-01-20 15:00:00	QQQ	ETF	101.78	101.88	101.54	101.62	4395795.0
2015-01-20 16:00:00	QQQ	ETF	101.61	101.72	101.45	101.66	834832.0
2015-01-20 17:00:00	QQQ	ETF	101.67	101.7	101.62	101.62	65715.0
2015-01-20 18:00:00	QQQ	ETF	101.67	101.78	101.67	101.76	22350.0
2015-01-20 19:00:00	QQQ	ETF	101.73	101.73	101.66	101.68	27260.0
2015-01-20 04:00:00	IWM	ETF	117.42	117.42	117.42	117.42	100.0
2015-01-20 06:00:00	IWM	ETF	116.91	116.91	116.91	116.91	814.0
2015-01-20 07:00:00	IWM	ETF	117.18	117.33	117.18	117.33	25425.0
2015-01-20 08:00:00	IWM	ETF	117.25	117.25	116.72	117.01	116758.0
2015-01-20 09:00:00	IWM	ETF	116.99	117.08	115.91	116.01	4507200.0
2015-01-20 10:00:00	IWM	ETF	116.0	116.17	115.32	115.5	5886873.0
2015-01-20 11:00:00	IWM	ETF	115.5	115.77	115.16	115.355	4366102.0
2015-01-20 12:00:00	IWM	ETF	115.35	115.9	115.3032	115.75	2070781.0
2015-01-20 13:00:00	IWM	ETF	115.74	115.89	115.49	115.77	1799859.0
2015-01-20 14:00:00	IWM	ETF	115.77	116.68	115.72	116.59	4006491.0
2015-01-20 15:00:00	IWM	ETF	116.58	116.61	115.92	116.22	4897958.0
2015-01-20 16:00:00	IWM	ETF	116.21	116.2999	115.6675	116.15	4143460.0
2015-01-20 17:00:00	IWM	ETF	116.15	116.19	116.12	116.15	17718.0
2015-01-20 18:00:00	IWM	ETF	116.2	116.22	116.2	116.22	200.0
2015-01-20 19:00:00	IWM	ETF	116.18	116.25	116.18	116.24	1600.0
2015-01-20 05:00:00	DIA	ETF	175.4	175.4	175.4	175.4	950.0
2015-01-20 07:00:00	DIA	ETF	175.25	175.26	175.25	175.26	200.0
2015-01-20 08:00:00	DIA	ETF	175.5	175.6	175.23	175.55	2540.0

> showing 50 of 7,851 rows — these rows as CSV

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