PREVIEW / stock_1hour / 2015-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-31.parquet
  size:    1.0 MB
  rows:    48,196
  symbols: 3,485

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-07-31 04:00:00	AAPL	Stock	30.615	30.655	30.615	30.655	1600.0
2015-07-31 05:00:00	AAPL	Stock	30.6625	30.67	30.6575	30.67	12600.0
2015-07-31 06:00:00	AAPL	Stock	30.6475	30.6475	30.5975	30.5975	8800.0
2015-07-31 07:00:00	AAPL	Stock	30.5975	30.5975	30.51	30.5725	111184.0
2015-07-31 08:00:00	AAPL	Stock	30.5375	30.625	30.51	30.6225	410096.0
2015-07-31 09:00:00	AAPL	Stock	30.6375	30.6975	30.375	30.3862	23852548.0
2015-07-31 10:00:00	AAPL	Stock	30.385	30.4075	30.2275	30.37	34447872.0
2015-07-31 11:00:00	AAPL	Stock	30.3675	30.3875	30.275	30.355	16467332.0
2015-07-31 12:00:00	AAPL	Stock	30.354	30.435	30.315	30.3268	12158496.0
2015-07-31 13:00:00	AAPL	Stock	30.321	30.375	30.295	30.3175	9952252.0
2015-07-31 14:00:00	AAPL	Stock	30.3175	30.355	30.265	30.2775	15104940.0
2015-07-31 15:00:00	AAPL	Stock	30.2775	30.3925	30.2662	30.365	30919024.0
2015-07-31 16:00:00	AAPL	Stock	30.325	30.395	30.325	30.375	9767448.0
2015-07-31 17:00:00	AAPL	Stock	30.37	30.375	30.325	30.36	125900.0
2015-07-31 18:00:00	AAPL	Stock	30.36	30.375	30.3525	30.3625	62480.0
2015-07-31 19:00:00	AAPL	Stock	30.3525	30.3725	30.35	30.3625	44448.0
2015-07-31 05:00:00	MSFT	Stock	46.9	46.9	46.9	46.9	200.0
2015-07-31 06:00:00	MSFT	Stock	46.95	46.95	46.95	46.95	100.0
2015-07-31 07:00:00	MSFT	Stock	46.9	46.9	46.89	46.89	300.0
2015-07-31 08:00:00	MSFT	Stock	46.95	47.053	46.86	47.053	14075.0
2015-07-31 09:00:00	MSFT	Stock	47.1	47.39	46.74	47.01	3566668.0
2015-07-31 10:00:00	MSFT	Stock	47.02	47.14	46.89	47.06	3974393.0
2015-07-31 11:00:00	MSFT	Stock	47.05	47.09	46.75	46.75	2992207.0
2015-07-31 12:00:00	MSFT	Stock	46.76	46.82	46.65	46.665	2331642.0
2015-07-31 13:00:00	MSFT	Stock	46.665	46.72	46.5	46.56	2506495.0
2015-07-31 14:00:00	MSFT	Stock	46.56	46.67	46.51	46.56	2760869.0
2015-07-31 15:00:00	MSFT	Stock	46.57	46.82	46.56	46.7	7690012.0
2015-07-31 16:00:00	MSFT	Stock	46.7	46.8	46.639	46.73	4003695.0
2015-07-31 17:00:00	MSFT	Stock	46.733	46.733	46.73	46.73	650.0
2015-07-31 18:00:00	MSFT	Stock	46.72	46.72	46.7	46.7	400.0
2015-07-31 19:00:00	MSFT	Stock	46.7	46.77	46.7	46.77	8100.0
2015-07-31 09:00:00	NVDA	Stock	0.5022	0.5028	0.497	0.5	18834520.0
2015-07-31 10:00:00	NVDA	Stock	0.5	0.5014	0.4978	0.4985	43219120.0
2015-07-31 11:00:00	NVDA	Stock	0.4986	0.4986	0.4958	0.496	24688320.0
2015-07-31 12:00:00	NVDA	Stock	0.496	0.5001	0.496	0.4992	22720920.0
2015-07-31 13:00:00	NVDA	Stock	0.4992	0.5004	0.497	0.497	21195520.0
2015-07-31 14:00:00	NVDA	Stock	0.497	0.4992	0.497	0.4984	15277560.0
2015-07-31 15:00:00	NVDA	Stock	0.4982	0.499	0.4972	0.4988	50229960.0
2015-07-31 16:00:00	NVDA	Stock	0.4988	0.499	0.4988	0.4988	16365160.0
2015-07-31 07:00:00	AMZN	Stock	26.8165	26.854	26.8165	26.854	14000.0
2015-07-31 08:00:00	AMZN	Stock	26.8445	26.9255	26.791	26.9255	176860.0
2015-07-31 09:00:00	AMZN	Stock	26.937	27.142	26.7775	26.9	13274260.0
2015-07-31 10:00:00	AMZN	Stock	26.9007	27.0	26.8165	26.992	8394980.0
2015-07-31 11:00:00	AMZN	Stock	26.9855	27.0	26.8635	26.8651	4152260.0
2015-07-31 12:00:00	AMZN	Stock	26.8854	26.9025	26.8275	26.8475	3889800.0
2015-07-31 13:00:00	AMZN	Stock	26.843	26.888	26.7295	26.762	4947980.0
2015-07-31 14:00:00	AMZN	Stock	26.7565	26.799	26.726	26.799	4560000.0
2015-07-31 15:00:00	AMZN	Stock	26.7955	26.8875	26.7955	26.8065	10915140.0
2015-07-31 16:00:00	AMZN	Stock	26.8075	26.8525	26.8075	26.8175	1607820.0
2015-07-31 17:00:00	AMZN	Stock	26.8325	26.8325	26.7885	26.7904	118720.0

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

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