PREVIEW / stock_1hour / 2015-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-16.parquet
  size:    1.1 MB
  rows:    49,646
  symbols: 3,525

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-03-16 04:00:00	AAPL	Stock	30.9075	31.0125	30.9075	31.0	32480.0
2015-03-16 05:00:00	AAPL	Stock	31.02	31.0425	30.985	30.995	13600.0
2015-03-16 06:00:00	AAPL	Stock	31.0	31.0	30.9625	30.9625	31260.0
2015-03-16 07:00:00	AAPL	Stock	30.98	30.9825	30.9325	30.9325	68404.0
2015-03-16 08:00:00	AAPL	Stock	30.95	30.9825	30.8375	30.8775	726808.0
2015-03-16 09:00:00	AAPL	Stock	30.8775	30.9975	30.7175	30.91	24133852.0
2015-03-16 10:00:00	AAPL	Stock	30.9125	31.12	30.9075	31.0225	24521008.0
2015-03-16 11:00:00	AAPL	Stock	31.025	31.125	31.015	31.08	14177812.0
2015-03-16 12:00:00	AAPL	Stock	31.08	31.095	30.9775	31.0338	9795304.0
2015-03-16 13:00:00	AAPL	Stock	31.035	31.0725	30.9875	31.0675	8760708.0
2015-03-16 14:00:00	AAPL	Stock	31.0675	31.1425	31.06	31.1225	11816504.0
2015-03-16 15:00:00	AAPL	Stock	31.125	31.2375	31.1235	31.235	25347824.0
2015-03-16 16:00:00	AAPL	Stock	31.2375	31.2405	31.0438	31.1575	13463264.0
2015-03-16 17:00:00	AAPL	Stock	31.17	31.2375	31.16	31.17	1222200.0
2015-03-16 18:00:00	AAPL	Stock	31.18	31.1825	31.15	31.1675	33032.0
2015-03-16 19:00:00	AAPL	Stock	31.1675	31.195	31.15	31.19	134324.0
2015-03-16 06:00:00	MSFT	Stock	41.34	41.39	41.27	41.39	1645.0
2015-03-16 07:00:00	MSFT	Stock	41.48	41.5	41.4	41.4	1250.0
2015-03-16 08:00:00	MSFT	Stock	41.469	41.49	41.25	41.34	16492.0
2015-03-16 09:00:00	MSFT	Stock	41.34	41.63	41.33	41.59	4410576.0
2015-03-16 10:00:00	MSFT	Stock	41.58	41.6	41.28	41.37	4284092.0
2015-03-16 11:00:00	MSFT	Stock	41.375	41.51	41.35	41.38	3662887.0
2015-03-16 12:00:00	MSFT	Stock	41.37	41.48	41.34	41.39	2798246.0
2015-03-16 13:00:00	MSFT	Stock	41.39	41.41	41.3	41.41	3331111.0
2015-03-16 14:00:00	MSFT	Stock	41.405	41.46	41.35	41.444	4120114.0
2015-03-16 15:00:00	MSFT	Stock	41.445	41.64	41.42	41.54	7179160.0
2015-03-16 16:00:00	MSFT	Stock	41.56	41.57	41.44	41.46	3839352.0
2015-03-16 17:00:00	MSFT	Stock	41.56	41.56	41.41	41.469	365433.0
2015-03-16 18:00:00	MSFT	Stock	41.43	41.43	41.41	41.42	2000.0
2015-03-16 19:00:00	MSFT	Stock	41.42	41.47	41.41	41.47	3829.0
2015-03-16 08:00:00	NVDA	Stock	0.5675	0.5675	0.5675	0.5675	8000.0
2015-03-16 09:00:00	NVDA	Stock	0.5725	0.5745	0.5682	0.5738	31547840.0
2015-03-16 10:00:00	NVDA	Stock	0.5738	0.5778	0.5738	0.5746	38249360.0
2015-03-16 11:00:00	NVDA	Stock	0.5748	0.575	0.572	0.5732	35579040.0
2015-03-16 12:00:00	NVDA	Stock	0.5732	0.5734	0.5706	0.571	11583120.0
2015-03-16 13:00:00	NVDA	Stock	0.571	0.5732	0.57	0.573	14638800.0
2015-03-16 14:00:00	NVDA	Stock	0.5732	0.5745	0.5722	0.5727	23463640.0
2015-03-16 15:00:00	NVDA	Stock	0.5728	0.5752	0.5726	0.5742	53295360.0
2015-03-16 16:00:00	NVDA	Stock	0.5742	0.5745	0.5738	0.5742	17810120.0
2015-03-16 17:00:00	NVDA	Stock	0.5742	0.5742	0.5731	0.5742	1131360.0
2015-03-16 19:00:00	NVDA	Stock	0.5735	0.5735	0.5735	0.5735	4000.0
2015-03-16 06:00:00	AMZN	Stock	18.5525	18.5525	18.5455	18.5455	4000.0
2015-03-16 08:00:00	AMZN	Stock	18.534	18.5775	18.528	18.528	70960.0
2015-03-16 09:00:00	AMZN	Stock	18.5465	18.5503	18.336	18.475	9113940.0
2015-03-16 10:00:00	AMZN	Stock	18.4732	18.624	18.4645	18.607	8240520.0
2015-03-16 11:00:00	AMZN	Stock	18.607	18.677	18.5855	18.6212	4059160.0
2015-03-16 12:00:00	AMZN	Stock	18.6202	18.635	18.562	18.595	3407700.0
2015-03-16 13:00:00	AMZN	Stock	18.5885	18.6375	18.553	18.6375	3059980.0
2015-03-16 14:00:00	AMZN	Stock	18.637	18.6945	18.619	18.653	4380040.0
2015-03-16 15:00:00	AMZN	Stock	18.6535	18.697	18.6535	18.6675	7119500.0

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

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