PREVIEW / stock_1hour / 2014-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-01.parquet
  size:    1.0 MB
  rows:    48,989
  symbols: 3,579

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
2014-10-01 04:00:00	AAPL	Stock	25.125	25.135	25.1	25.135	9000.0
2014-10-01 05:00:00	AAPL	Stock	25.1425	25.15	25.1425	25.1425	5000.0
2014-10-01 06:00:00	AAPL	Stock	25.16	25.175	25.16	25.1625	8892.0
2014-10-01 07:00:00	AAPL	Stock	25.1675	25.18	25.095	25.1125	94728.0
2014-10-01 08:00:00	AAPL	Stock	25.1125	25.1875	25.0625	25.17	422540.0
2014-10-01 09:00:00	AAPL	Stock	25.17	25.2	24.9412	24.9625	25266532.0
2014-10-01 10:00:00	AAPL	Stock	24.9625	25.0	24.875	24.995	31990156.0
2014-10-01 11:00:00	AAPL	Stock	24.995	25.075	24.9175	24.9625	21473572.0
2014-10-01 12:00:00	AAPL	Stock	24.9638	24.9725	24.8875	24.8958	14418968.0
2014-10-01 13:00:00	AAPL	Stock	24.8975	24.9225	24.725	24.74	28112244.0
2014-10-01 14:00:00	AAPL	Stock	24.74	24.855	24.6925	24.7125	23467152.0
2014-10-01 15:00:00	AAPL	Stock	24.7125	24.8625	24.675	24.7975	39852060.0
2014-10-01 16:00:00	AAPL	Stock	24.795	24.976	24.7692	24.8125	9276780.0
2014-10-01 17:00:00	AAPL	Stock	24.8075	24.835	24.8	24.835	43168.0
2014-10-01 18:00:00	AAPL	Stock	24.8325	24.85	24.795	24.8325	243864.0
2014-10-01 19:00:00	AAPL	Stock	24.8275	24.8375	24.7975	24.8075	89456.0
2014-10-01 08:00:00	MSFT	Stock	46.36	46.36	46.21	46.21	2155.0
2014-10-01 09:00:00	MSFT	Stock	46.26	46.53	46.22	46.24	3771388.0
2014-10-01 10:00:00	MSFT	Stock	46.235	46.32	45.95	46.3	5572894.0
2014-10-01 11:00:00	MSFT	Stock	46.295	46.37	46.25	46.34	4017136.0
2014-10-01 12:00:00	MSFT	Stock	46.335	46.35	46.07	46.135	3896691.0
2014-10-01 13:00:00	MSFT	Stock	46.13	46.18	45.9	45.907	3538577.0
2014-10-01 14:00:00	MSFT	Stock	45.905	46.03	45.845	45.855	3364544.0
2014-10-01 15:00:00	MSFT	Stock	45.86	46.06	45.855	45.91	7239998.0
2014-10-01 16:00:00	MSFT	Stock	45.9	46.131	45.9	45.9	5495409.0
2014-10-01 17:00:00	MSFT	Stock	45.91	45.91	45.91	45.91	262.0
2014-10-01 18:00:00	MSFT	Stock	45.9	46.0	45.9	46.0	33650.0
2014-10-01 19:00:00	MSFT	Stock	45.93	45.93	45.92	45.92	4000.0
2014-10-01 09:00:00	NVDA	Stock	0.462	0.462	0.4565	0.4576	26847560.0
2014-10-01 10:00:00	NVDA	Stock	0.4575	0.464	0.4562	0.4634	80758120.0
2014-10-01 11:00:00	NVDA	Stock	0.4635	0.4652	0.4624	0.464	52103360.0
2014-10-01 12:00:00	NVDA	Stock	0.464	0.464	0.46	0.4603	24868600.0
2014-10-01 13:00:00	NVDA	Stock	0.46	0.4605	0.4582	0.4584	21645000.0
2014-10-01 14:00:00	NVDA	Stock	0.4584	0.4593	0.4562	0.4562	21174680.0
2014-10-01 15:00:00	NVDA	Stock	0.4562	0.4595	0.4555	0.4568	90272520.0
2014-10-01 16:00:00	NVDA	Stock	0.457	0.4621	0.4566	0.4568	3442080.0
2014-10-01 19:00:00	NVDA	Stock	0.456	0.456	0.456	0.456	26040.0
2014-10-01 08:00:00	AMZN	Stock	16.1	16.1	16.0505	16.0525	24000.0
2014-10-01 09:00:00	AMZN	Stock	16.068	16.1083	15.918	15.9375	7678940.0
2014-10-01 10:00:00	AMZN	Stock	15.935	15.9685	15.8379	15.906	11440760.0
2014-10-01 11:00:00	AMZN	Stock	15.9026	15.996	15.888	15.9135	6499280.0
2014-10-01 12:00:00	AMZN	Stock	15.907	15.9305	15.8505	15.8615	4899080.0
2014-10-01 13:00:00	AMZN	Stock	15.867	15.8834	15.835	15.8445	5228540.0
2014-10-01 14:00:00	AMZN	Stock	15.8478	15.892	15.805	15.805	5108460.0
2014-10-01 15:00:00	AMZN	Stock	15.8075	15.9135	15.7775	15.873	12250740.0
2014-10-01 16:00:00	AMZN	Stock	15.87	16.1516	15.8698	15.873	1115740.0
2014-10-01 17:00:00	AMZN	Stock	15.8775	15.88	15.8775	15.88	10000.0
2014-10-01 18:00:00	AMZN	Stock	15.873	15.8775	15.873	15.8775	118200.0
2014-10-01 19:00:00	AMZN	Stock	15.876	15.8835	15.876	15.8835	28040.0
2014-10-01 08:00:00	GOOGL	Stock	29.4205	29.4205	29.4	29.4005	29000.0

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

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