PREVIEW / etf_1hour / 2014-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-28.parquet
  size:    223 KB
  rows:    6,994

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
2014-01-28 04:00:00	SPY	ETF	178.6	179.07	178.6	178.97	137540.0
2014-01-28 05:00:00	SPY	ETF	178.93	178.96	178.84	178.9	145829.0
2014-01-28 06:00:00	SPY	ETF	178.93	178.93	178.65	178.86	121443.0
2014-01-28 07:00:00	SPY	ETF	178.84	178.86	178.47	178.48	518756.0
2014-01-28 08:00:00	SPY	ETF	178.96	178.96	177.99	178.56	3208578.0
2014-01-28 09:00:00	SPY	ETF	178.58	178.94	178.02	178.866	15580827.0
2014-01-28 10:00:00	SPY	ETF	178.89	179.26	178.74	179.06	20878015.0
2014-01-28 11:00:00	SPY	ETF	179.06	179.3	178.28	178.59	16932765.0
2014-01-28 12:00:00	SPY	ETF	178.59	179.01	178.48	178.81	9076752.0
2014-01-28 13:00:00	SPY	ETF	178.83	179.08	178.72	178.85	6673325.0
2014-01-28 14:00:00	SPY	ETF	178.86	179.19	178.78	179.1	7443847.0
2014-01-28 15:00:00	SPY	ETF	179.105	179.27	178.92	179.07	16793443.0
2014-01-28 16:00:00	SPY	ETF	179.08	179.33	178.0287	179.3	7190150.0
2014-01-28 17:00:00	SPY	ETF	179.3	180.11	179.3	179.88	2036476.0
2014-01-28 18:00:00	SPY	ETF	179.88	180.33	179.76	179.94	1421189.0
2014-01-28 19:00:00	SPY	ETF	179.95	180.19	179.94	180.17	130139.0
2014-01-28 04:00:00	QQQ	ETF	85.8	85.8	85.8	85.8	4100.0
2014-01-28 05:00:00	QQQ	ETF	85.71	85.76	85.71	85.74	4400.0
2014-01-28 06:00:00	QQQ	ETF	85.73	85.73	85.62	85.71	5720.0
2014-01-28 07:00:00	QQQ	ETF	85.63	85.72	85.57	85.59	154655.0
2014-01-28 08:00:00	QQQ	ETF	85.59	85.67	85.38	85.64	336802.0
2014-01-28 09:00:00	QQQ	ETF	85.62	85.74	85.35	85.685	6403869.0
2014-01-28 10:00:00	QQQ	ETF	85.685	85.92	85.64	85.82	6350346.0
2014-01-28 11:00:00	QQQ	ETF	85.82	85.94	85.31	85.49	9005742.0
2014-01-28 12:00:00	QQQ	ETF	85.49	85.615	85.3849	85.55	4403833.0
2014-01-28 13:00:00	QQQ	ETF	85.545	85.69	85.46	85.52	6277238.0
2014-01-28 14:00:00	QQQ	ETF	85.51	85.8	85.475	85.7578	3180815.0
2014-01-28 15:00:00	QQQ	ETF	85.755	85.85	85.65	85.85	3840540.0
2014-01-28 16:00:00	QQQ	ETF	85.84	86.01	85.506	85.91	940663.0
2014-01-28 17:00:00	QQQ	ETF	85.9	86.23	85.9	86.2	43751.0
2014-01-28 18:00:00	QQQ	ETF	86.2	86.44	86.18	86.18	42303.0
2014-01-28 19:00:00	QQQ	ETF	86.2	86.32	86.2	86.29	14900.0
2014-01-28 06:00:00	IWM	ETF	112.41	112.41	112.3	112.3	200.0
2014-01-28 07:00:00	IWM	ETF	112.42	112.42	112.2	112.22	149244.0
2014-01-28 08:00:00	IWM	ETF	112.43	112.43	111.96	112.34	488860.0
2014-01-28 09:00:00	IWM	ETF	112.34	112.54	111.79	112.47	5862498.0
2014-01-28 10:00:00	IWM	ETF	112.48	112.77	112.27	112.6	5191376.0
2014-01-28 11:00:00	IWM	ETF	112.6	112.82	112.01	112.3	4215495.0
2014-01-28 12:00:00	IWM	ETF	112.3	112.53	112.155	112.5199	2162560.0
2014-01-28 13:00:00	IWM	ETF	112.52	112.67	112.315	112.53	2768913.0
2014-01-28 14:00:00	IWM	ETF	112.53	112.93	112.46	112.7299	3211331.0
2014-01-28 15:00:00	IWM	ETF	112.725	112.985	112.605	112.96	6573330.0
2014-01-28 16:00:00	IWM	ETF	112.96	113.18	111.9135	113.13	4218822.0
2014-01-28 17:00:00	IWM	ETF	113.18	113.86	113.18	113.66	270097.0
2014-01-28 18:00:00	IWM	ETF	113.7	113.93	113.6	113.65	79547.0
2014-01-28 19:00:00	IWM	ETF	113.69	113.74	113.6	113.74	30277.0
2014-01-28 06:00:00	DIA	ETF	159.05	159.05	159.05	159.05	100.0
2014-01-28 07:00:00	DIA	ETF	158.73	158.74	158.62	158.62	12000.0
2014-01-28 08:00:00	DIA	ETF	158.8	158.85	158.28	158.82	30576.0
2014-01-28 09:00:00	DIA	ETF	158.72	158.92	158.39	158.87	1093357.0

> showing 50 of 6,994 rows — these rows as CSV

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