PREVIEW / stock_1hour / 2016-02-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-29.parquet
  size:    1.0 MB
  rows:    48,824
  symbols: 3,372

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-02-29 04:00:00	AAPL	Stock	24.2125	24.2125	23.985	23.985	14824.0
2016-02-29 05:00:00	AAPL	Stock	24.0	24.13	24.0	24.085	22212.0
2016-02-29 06:00:00	AAPL	Stock	24.0575	24.165	24.05	24.1625	6872.0
2016-02-29 07:00:00	AAPL	Stock	24.18	24.18	24.15	24.1625	33172.0
2016-02-29 08:00:00	AAPL	Stock	24.17	24.265	24.1625	24.265	101428.0
2016-02-29 09:00:00	AAPL	Stock	24.2525	24.4225	24.1875	24.39	16245704.0
2016-02-29 10:00:00	AAPL	Stock	24.3925	24.4925	24.3275	24.4675	13318036.0
2016-02-29 11:00:00	AAPL	Stock	24.465	24.5575	24.4375	24.5025	14376532.0
2016-02-29 12:00:00	AAPL	Stock	24.4975	24.5175	24.4075	24.4738	11051748.0
2016-02-29 13:00:00	AAPL	Stock	24.475	24.495	24.385	24.4265	9742104.0
2016-02-29 14:00:00	AAPL	Stock	24.425	24.4312	24.3	24.3375	12622512.0
2016-02-29 15:00:00	AAPL	Stock	24.3375	24.3375	24.1625	24.1625	23570256.0
2016-02-29 16:00:00	AAPL	Stock	24.1625	24.3895	24.1625	24.225	22190816.0
2016-02-29 17:00:00	AAPL	Stock	24.22	24.225	24.195	24.2	27200.0
2016-02-29 18:00:00	AAPL	Stock	24.2125	24.2375	24.21	24.225	34924.0
2016-02-29 19:00:00	AAPL	Stock	24.2125	24.23	24.19	24.1975	63012.0
2016-02-29 07:00:00	MSFT	Stock	51.1	51.17	51.1	51.17	1250.0
2016-02-29 08:00:00	MSFT	Stock	51.0	51.35	51.0	51.3	13255.0
2016-02-29 09:00:00	MSFT	Stock	51.28	51.38	51.0	51.2	1954629.0
2016-02-29 10:00:00	MSFT	Stock	51.19	51.325	51.01	51.304	2670456.0
2016-02-29 11:00:00	MSFT	Stock	51.301	51.65	51.25	51.505	2234416.0
2016-02-29 12:00:00	MSFT	Stock	51.51	51.55	51.31	51.37	1504506.0
2016-02-29 13:00:00	MSFT	Stock	51.38	51.465	51.21	51.32	1555331.0
2016-02-29 14:00:00	MSFT	Stock	51.315	51.32	50.83	50.865	3100695.0
2016-02-29 15:00:00	MSFT	Stock	50.86	50.92	50.66	50.77	7857356.0
2016-02-29 16:00:00	MSFT	Stock	50.88	50.93	50.69	50.8	6722107.0
2016-02-29 17:00:00	MSFT	Stock	50.79	50.88	50.75	50.76	184327.0
2016-02-29 18:00:00	MSFT	Stock	50.78	50.85	50.78	50.85	8805.0
2016-02-29 19:00:00	MSFT	Stock	50.88	50.88	50.78	50.78	3912.0
2016-02-29 07:00:00	NVDA	Stock	0.785	0.785	0.785	0.785	12000.0
2016-02-29 08:00:00	NVDA	Stock	0.79	0.7998	0.79	0.7975	53600.0
2016-02-29 09:00:00	NVDA	Stock	0.7972	0.7972	0.7835	0.7892	24738600.0
2016-02-29 10:00:00	NVDA	Stock	0.7892	0.7931	0.787	0.7923	32884880.0
2016-02-29 11:00:00	NVDA	Stock	0.7925	0.8005	0.7919	0.7998	36365440.0
2016-02-29 12:00:00	NVDA	Stock	0.7998	0.8002	0.7935	0.7952	40134280.0
2016-02-29 13:00:00	NVDA	Stock	0.7952	0.7975	0.7915	0.794	29270480.0
2016-02-29 14:00:00	NVDA	Stock	0.7938	0.7942	0.7898	0.7915	25008320.0
2016-02-29 15:00:00	NVDA	Stock	0.7912	0.7916	0.784	0.784	95081360.0
2016-02-29 16:00:00	NVDA	Stock	0.784	0.7848	0.784	0.7848	24394480.0
2016-02-29 04:00:00	AMZN	Stock	27.576	27.576	27.523	27.523	10800.0
2016-02-29 05:00:00	AMZN	Stock	27.545	27.546	27.545	27.546	4000.0
2016-02-29 06:00:00	AMZN	Stock	27.6	27.6	27.55	27.6	19520.0
2016-02-29 07:00:00	AMZN	Stock	27.5775	27.7075	27.5775	27.65	32220.0
2016-02-29 08:00:00	AMZN	Stock	27.625	27.825	27.5865	27.8	182000.0
2016-02-29 09:00:00	AMZN	Stock	27.8	28.022	27.638	27.9012	7308500.0
2016-02-29 10:00:00	AMZN	Stock	27.9268	28.1032	27.8	27.9615	9907900.0
2016-02-29 11:00:00	AMZN	Stock	27.9585	28.0405	27.8525	27.9925	6509300.0
2016-02-29 12:00:00	AMZN	Stock	27.985	28.163	27.953	28.1605	9389860.0
2016-02-29 13:00:00	AMZN	Stock	28.1614	28.2405	27.9695	28.0105	8733360.0
2016-02-29 14:00:00	AMZN	Stock	28.0061	28.0065	27.787	27.8045	8965040.0

> showing 50 of 48,824 rows — these rows as CSV

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