PREVIEW / stock_1hour / 2016-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-25.parquet
  size:    1.0 MB
  rows:    48,355
  symbols: 3,331

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-25 04:00:00	AAPL	Stock	23.97	24.005	23.97	23.975	10800.0
2016-02-25 05:00:00	AAPL	Stock	23.975	24.02	23.975	24.02	6400.0
2016-02-25 06:00:00	AAPL	Stock	23.975	24.035	23.975	24.035	17204.0
2016-02-25 07:00:00	AAPL	Stock	24.0	24.0375	23.9875	24.0	38936.0
2016-02-25 08:00:00	AAPL	Stock	24.0	24.045	23.965	24.03	283624.0
2016-02-25 09:00:00	AAPL	Stock	24.03	24.0625	23.8125	23.8825	15986952.0
2016-02-25 10:00:00	AAPL	Stock	23.8825	24.1075	23.825	24.0025	16712944.0
2016-02-25 11:00:00	AAPL	Stock	24.0025	24.05	23.9125	23.9575	12130612.0
2016-02-25 12:00:00	AAPL	Stock	23.9575	23.9775	23.9	23.9325	7590180.0
2016-02-25 13:00:00	AAPL	Stock	23.9325	24.1	23.925	24.0775	10380176.0
2016-02-25 14:00:00	AAPL	Stock	24.075	24.0875	23.9625	23.995	10466220.0
2016-02-25 15:00:00	AAPL	Stock	23.9925	24.19	23.9925	24.19	19688368.0
2016-02-25 16:00:00	AAPL	Stock	24.19	24.1925	23.8672	24.1425	7010460.0
2016-02-25 17:00:00	AAPL	Stock	24.1375	24.1525	24.125	24.1475	39624.0
2016-02-25 18:00:00	AAPL	Stock	24.1475	24.1475	24.1275	24.1375	77048.0
2016-02-25 19:00:00	AAPL	Stock	24.1375	24.1575	24.1375	24.155	32272.0
2016-02-25 04:00:00	MSFT	Stock	51.46	51.46	51.46	51.46	300.0
2016-02-25 06:00:00	MSFT	Stock	51.5	51.5	51.5	51.5	100.0
2016-02-25 07:00:00	MSFT	Stock	51.74	51.76	51.74	51.75	1100.0
2016-02-25 08:00:00	MSFT	Stock	51.65	51.65	51.53	51.64	8039.0
2016-02-25 09:00:00	MSFT	Stock	51.64	51.84	50.61	50.69	3905368.0
2016-02-25 10:00:00	MSFT	Stock	50.69	51.27	50.64	51.1	3793051.0
2016-02-25 11:00:00	MSFT	Stock	51.11	51.43	50.98	51.39	2628606.0
2016-02-25 12:00:00	MSFT	Stock	51.395	51.41	51.036	51.155	2367071.0
2016-02-25 13:00:00	MSFT	Stock	51.155	51.56	51.13	51.53	1994574.0
2016-02-25 14:00:00	MSFT	Stock	51.53	52.01	51.35	51.445	2443199.0
2016-02-25 15:00:00	MSFT	Stock	51.44	52.1	51.42	52.1	6415196.0
2016-02-25 16:00:00	MSFT	Stock	52.1	52.1	50.924	51.99	1762903.0
2016-02-25 17:00:00	MSFT	Stock	51.99	52.0	51.95	51.95	6000.0
2016-02-25 18:00:00	MSFT	Stock	51.95	51.99	51.91	51.99	4100.0
2016-02-25 19:00:00	MSFT	Stock	52.0	52.06	51.95	51.96	2700.0
2016-02-25 09:00:00	NVDA	Stock	0.7985	0.8012	0.783	0.7878	52627600.0
2016-02-25 10:00:00	NVDA	Stock	0.7878	0.7901	0.7835	0.7885	59327840.0
2016-02-25 11:00:00	NVDA	Stock	0.7885	0.794	0.7874	0.7912	34705480.0
2016-02-25 12:00:00	NVDA	Stock	0.7914	0.7918	0.7868	0.7887	30540280.0
2016-02-25 13:00:00	NVDA	Stock	0.7886	0.792	0.7865	0.7898	31929400.0
2016-02-25 14:00:00	NVDA	Stock	0.79	0.792	0.7865	0.7868	47701120.0
2016-02-25 15:00:00	NVDA	Stock	0.787	0.7975	0.787	0.797	65615160.0
2016-02-25 16:00:00	NVDA	Stock	0.7972	0.7975	0.7915	0.7975	9247800.0
2016-02-25 17:00:00	NVDA	Stock	0.7998	0.7998	0.7998	0.7998	4000.0
2016-02-25 05:00:00	AMZN	Stock	27.576	27.7	27.576	27.7	12400.0
2016-02-25 06:00:00	AMZN	Stock	27.702	27.815	27.702	27.738	17400.0
2016-02-25 07:00:00	AMZN	Stock	27.79	27.855	27.79	27.824	49420.0
2016-02-25 08:00:00	AMZN	Stock	27.7765	27.8125	27.61	27.7	255560.0
2016-02-25 09:00:00	AMZN	Stock	27.7105	27.9695	27.54	27.566	11922060.0
2016-02-25 10:00:00	AMZN	Stock	27.5665	27.7385	27.41	27.425	9749360.0
2016-02-25 11:00:00	AMZN	Stock	27.425	27.5665	27.3415	27.535	9882700.0
2016-02-25 12:00:00	AMZN	Stock	27.5438	27.5525	27.2648	27.4142	9018760.0
2016-02-25 13:00:00	AMZN	Stock	27.4075	27.703	27.3895	27.6525	12113840.0
2016-02-25 14:00:00	AMZN	Stock	27.6435	27.6515	27.3615	27.5185	8885280.0

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

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