PREVIEW / stock_1hour / 2015-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-09.parquet
  size:    1.0 MB
  rows:    48,997
  symbols: 3,443

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-09-09 04:00:00	AAPL	Stock	28.1675	28.53	28.1675	28.4375	65208.0
2015-09-09 05:00:00	AAPL	Stock	28.4575	28.4675	28.355	28.355	83956.0
2015-09-09 06:00:00	AAPL	Stock	28.38	28.4075	28.3375	28.3375	127848.0
2015-09-09 07:00:00	AAPL	Stock	28.3625	28.4475	28.3375	28.425	409664.0
2015-09-09 08:00:00	AAPL	Stock	28.4375	28.475	28.3375	28.41	1881824.0
2015-09-09 09:00:00	AAPL	Stock	28.4125	28.45	27.925	28.0475	38439120.0
2015-09-09 10:00:00	AAPL	Stock	28.0475	28.2395	27.965	28.0738	35892044.0
2015-09-09 11:00:00	AAPL	Stock	28.0725	28.17	28.0275	28.1375	18138680.0
2015-09-09 12:00:00	AAPL	Stock	28.1425	28.28	28.115	28.2012	21496084.0
2015-09-09 13:00:00	AAPL	Stock	28.2025	28.505	27.975	28.035	74500840.0
2015-09-09 14:00:00	AAPL	Stock	28.0375	28.1175	27.6775	27.8962	53675440.0
2015-09-09 15:00:00	AAPL	Stock	27.8925	27.945	27.4425	27.5365	57944404.0
2015-09-09 16:00:00	AAPL	Stock	27.525	28.157	27.4825	27.555	7634180.0
2015-09-09 17:00:00	AAPL	Stock	27.5575	27.61	27.525	27.595	323008.0
2015-09-09 18:00:00	AAPL	Stock	27.605	27.61	27.475	27.495	407356.0
2015-09-09 19:00:00	AAPL	Stock	27.5	27.5375	27.445	27.4625	211568.0
2015-09-09 04:00:00	MSFT	Stock	44.46	44.46	44.46	44.46	100.0
2015-09-09 06:00:00	MSFT	Stock	44.22	44.25	44.22	44.25	5445.0
2015-09-09 07:00:00	MSFT	Stock	44.3	44.3	44.23	44.27	3810.0
2015-09-09 08:00:00	MSFT	Stock	44.28	44.35	44.23	44.35	21200.0
2015-09-09 09:00:00	MSFT	Stock	44.37	44.43	44.185	44.27	3138491.0
2015-09-09 10:00:00	MSFT	Stock	44.28	44.3	43.86	43.9	3949922.0
2015-09-09 11:00:00	MSFT	Stock	43.9	43.96	43.69	43.795	2407974.0
2015-09-09 12:00:00	MSFT	Stock	43.79	43.94	43.66	43.695	1886310.0
2015-09-09 13:00:00	MSFT	Stock	43.7	43.94	43.49	43.52	2845572.0
2015-09-09 14:00:00	MSFT	Stock	43.52	43.62	43.26	43.39	2949691.0
2015-09-09 15:00:00	MSFT	Stock	43.37	43.52	42.91	43.07	6920099.0
2015-09-09 16:00:00	MSFT	Stock	43.07	43.1	43.06	43.1	7791067.0
2015-09-09 17:00:00	MSFT	Stock	43.1	43.11	43.1	43.11	1380.0
2015-09-09 18:00:00	MSFT	Stock	43.08	43.08	42.87	43.08	4400.0
2015-09-09 19:00:00	MSFT	Stock	42.9	43.04	42.9	43.04	350.0
2015-09-09 08:00:00	NVDA	Stock	0.57	0.57	0.57	0.57	71920.0
2015-09-09 09:00:00	NVDA	Stock	0.5688	0.5735	0.5672	0.5685	25751600.0
2015-09-09 10:00:00	NVDA	Stock	0.5685	0.5692	0.559	0.5602	30519960.0
2015-09-09 11:00:00	NVDA	Stock	0.5602	0.5638	0.5595	0.5625	19111240.0
2015-09-09 12:00:00	NVDA	Stock	0.5625	0.5652	0.562	0.5632	18711360.0
2015-09-09 13:00:00	NVDA	Stock	0.5632	0.5664	0.5608	0.561	18975080.0
2015-09-09 14:00:00	NVDA	Stock	0.5612	0.5639	0.5608	0.5625	25208480.0
2015-09-09 15:00:00	NVDA	Stock	0.5628	0.5629	0.5545	0.5558	103540920.0
2015-09-09 16:00:00	NVDA	Stock	0.5562	0.557	0.5558	0.5558	3196720.0
2015-09-09 19:00:00	NVDA	Stock	0.5555	0.5555	0.5555	0.5555	8000.0
2015-09-09 04:00:00	AMZN	Stock	26.2465	26.2465	26.2465	26.2465	2000.0
2015-09-09 05:00:00	AMZN	Stock	26.151	26.151	26.125	26.125	10000.0
2015-09-09 06:00:00	AMZN	Stock	26.125	26.125	26.103	26.103	16000.0
2015-09-09 07:00:00	AMZN	Stock	26.122	26.1775	26.122	26.143	112940.0
2015-09-09 08:00:00	AMZN	Stock	26.1305	26.23	26.075	26.215	344040.0
2015-09-09 09:00:00	AMZN	Stock	26.2	26.472	26.097	26.387	18376400.0
2015-09-09 10:00:00	AMZN	Stock	26.3995	26.4975	26.203	26.2422	14031220.0
2015-09-09 11:00:00	AMZN	Stock	26.2305	26.3255	26.15	26.2205	7412480.0
2015-09-09 12:00:00	AMZN	Stock	26.215	26.2855	26.151	26.1908	4020800.0

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

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