PREVIEW / stock_1hour / 2015-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-15.parquet
  size:    1.1 MB
  rows:    49,779
  symbols: 3,434

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-12-15 04:00:00	AAPL	Stock	28.1125	28.2125	28.0825	28.175	98720.0
2015-12-15 05:00:00	AAPL	Stock	28.175	28.175	27.94	27.97	125460.0
2015-12-15 06:00:00	AAPL	Stock	27.975	28.0	27.5275	27.725	263196.0
2015-12-15 07:00:00	AAPL	Stock	27.7375	27.8675	27.6275	27.7875	451084.0
2015-12-15 08:00:00	AAPL	Stock	27.8	27.995	27.63	27.98	1531832.0
2015-12-15 09:00:00	AAPL	Stock	27.9825	28.0875	27.7825	27.8475	35976108.0
2015-12-15 10:00:00	AAPL	Stock	27.8475	28.2	27.84	28.16	33836656.0
2015-12-15 11:00:00	AAPL	Stock	28.155	28.16	27.8	27.875	27415832.0
2015-12-15 12:00:00	AAPL	Stock	27.875	28.0225	27.835	28.0075	17540152.0
2015-12-15 13:00:00	AAPL	Stock	28.0075	28.02	27.875	27.9425	15567404.0
2015-12-15 14:00:00	AAPL	Stock	27.9425	27.985	27.8325	27.844	14907008.0
2015-12-15 15:00:00	AAPL	Stock	27.845	27.8575	27.5875	27.6225	40445792.0
2015-12-15 16:00:00	AAPL	Stock	27.6225	28.0878	27.5825	27.6325	8651508.0
2015-12-15 17:00:00	AAPL	Stock	27.6375	28.0502	27.5875	27.595	115952.0
2015-12-15 18:00:00	AAPL	Stock	27.6025	27.6125	27.5875	27.5875	63660.0
2015-12-15 19:00:00	AAPL	Stock	27.6	27.6225	27.585	27.6225	71448.0
2015-12-15 04:00:00	MSFT	Stock	55.49	55.54	55.49	55.54	8304.0
2015-12-15 05:00:00	MSFT	Stock	55.54	55.55	55.51	55.52	5150.0
2015-12-15 06:00:00	MSFT	Stock	55.53	55.53	55.53	55.53	305.0
2015-12-15 07:00:00	MSFT	Stock	55.53	55.59	55.49	55.49	7800.0
2015-12-15 08:00:00	MSFT	Stock	55.52	55.69	55.42	55.69	32463.0
2015-12-15 09:00:00	MSFT	Stock	55.73	55.9	55.446	55.775	6390837.0
2015-12-15 10:00:00	MSFT	Stock	55.78	55.79	55.47	55.475	7280315.0
2015-12-15 11:00:00	MSFT	Stock	55.48	55.525	55.09	55.26	4720558.0
2015-12-15 12:00:00	MSFT	Stock	55.25	55.58	55.23	55.58	4549590.0
2015-12-15 13:00:00	MSFT	Stock	55.58	55.595	55.34	55.5	3012438.0
2015-12-15 14:00:00	MSFT	Stock	55.51	55.64	55.42	55.48	2515410.0
2015-12-15 15:00:00	MSFT	Stock	55.48	55.495	55.13	55.2	6277644.0
2015-12-15 16:00:00	MSFT	Stock	55.2	55.21	55.1	55.2	2386580.0
2015-12-15 17:00:00	MSFT	Stock	55.262	55.262	55.18	55.18	60300.0
2015-12-15 18:00:00	MSFT	Stock	55.21	55.21	55.17	55.17	400.0
2015-12-15 19:00:00	MSFT	Stock	55.21	55.21	55.18	55.2	10400.0
2015-12-15 08:00:00	NVDA	Stock	0.82	0.8418	0.82	0.8418	50000.0
2015-12-15 09:00:00	NVDA	Stock	0.8222	0.83	0.8142	0.8285	30430400.0
2015-12-15 10:00:00	NVDA	Stock	0.8285	0.829	0.8252	0.8273	37138840.0
2015-12-15 11:00:00	NVDA	Stock	0.8275	0.8276	0.8209	0.823	38009400.0
2015-12-15 12:00:00	NVDA	Stock	0.8228	0.8265	0.8222	0.8258	41872760.0
2015-12-15 13:00:00	NVDA	Stock	0.826	0.8282	0.8248	0.8265	23832880.0
2015-12-15 14:00:00	NVDA	Stock	0.8266	0.8273	0.825	0.8258	26945400.0
2015-12-15 15:00:00	NVDA	Stock	0.8258	0.8265	0.8236	0.8242	63151320.0
2015-12-15 16:00:00	NVDA	Stock	0.8245	0.8252	0.824	0.8252	2615680.0
2015-12-15 17:00:00	NVDA	Stock	0.8258	0.8258	0.8258	0.8258	101120.0
2015-12-15 18:00:00	NVDA	Stock	0.8225	0.8225	0.8225	0.8225	20000.0
2015-12-15 06:00:00	AMZN	Stock	33.1095	33.185	33.1095	33.185	16660.0
2015-12-15 07:00:00	AMZN	Stock	33.15	33.15	33.051	33.1	71380.0
2015-12-15 08:00:00	AMZN	Stock	33.1025	33.33	33.1	33.2765	839440.0
2015-12-15 09:00:00	AMZN	Stock	33.315	33.575	33.15	33.473	20991180.0
2015-12-15 10:00:00	AMZN	Stock	33.4812	33.5495	33.3565	33.4485	12228540.0
2015-12-15 11:00:00	AMZN	Stock	33.457	33.4719	33.15	33.2455	9022960.0
2015-12-15 12:00:00	AMZN	Stock	33.244	33.4995	33.2232	33.4325	7366600.0

> showing 50 of 49,779 rows — these rows as CSV

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