PREVIEW / stock_1hour / 2013-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-25.parquet
  size:    1022 KB
  rows:    47,133
  symbols: 3,544

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
2013-10-25 04:00:00	AAPL	Stock	19.0	19.01	18.9429	18.9821	93744.0
2013-10-25 05:00:00	AAPL	Stock	18.9943	19.0207	18.9821	19.0	145404.0
2013-10-25 06:00:00	AAPL	Stock	19.0161	19.0246	18.9854	19.0054	122668.0
2013-10-25 07:00:00	AAPL	Stock	19.0107	19.0711	18.9929	19.0164	1123248.0
2013-10-25 08:00:00	AAPL	Stock	19.0161	19.0625	18.9432	18.9936	1894480.0
2013-10-25 09:00:00	AAPL	Stock	18.9982	19.0439	18.9146	19.0006	58646504.0
2013-10-25 10:00:00	AAPL	Stock	19.0018	19.0268	18.9039	18.9082	47111120.0
2013-10-25 11:00:00	AAPL	Stock	18.9054	18.9496	18.8089	18.8539	49333032.0
2013-10-25 12:00:00	AAPL	Stock	18.8521	18.86	18.7818	18.8561	32541600.0
2013-10-25 13:00:00	AAPL	Stock	18.8575	18.9214	18.8368	18.9139	27542256.0
2013-10-25 14:00:00	AAPL	Stock	18.9139	18.9514	18.852	18.8711	32152792.0
2013-10-25 15:00:00	AAPL	Stock	18.873	18.875	18.7539	18.789	64925448.0
2013-10-25 16:00:00	AAPL	Stock	18.7929	18.9968	18.7352	18.765	11870880.0
2013-10-25 17:00:00	AAPL	Stock	18.7632	18.7696	18.7529	18.7675	322476.0
2013-10-25 18:00:00	AAPL	Stock	18.7675	18.775	18.7564	18.7675	166488.0
2013-10-25 19:00:00	AAPL	Stock	18.7625	18.7929	18.7554	18.7554	211512.0
2013-10-25 04:00:00	MSFT	Stock	35.21	35.5	35.21	35.22	7140.0
2013-10-25 05:00:00	MSFT	Stock	35.38	35.56	35.38	35.56	10250.0
2013-10-25 06:00:00	MSFT	Stock	35.52	35.54	35.49	35.54	12210.0
2013-10-25 07:00:00	MSFT	Stock	35.6	36.17	35.6	35.8	660755.0
2013-10-25 08:00:00	MSFT	Stock	35.76	36.1	35.55	35.82	1657483.0
2013-10-25 09:00:00	MSFT	Stock	35.83	36.19	35.69	36.12	31153226.0
2013-10-25 10:00:00	MSFT	Stock	36.12	36.29	35.86	35.875	24529031.0
2013-10-25 11:00:00	MSFT	Stock	35.879	35.92	35.553	35.603	12746834.0
2013-10-25 12:00:00	MSFT	Stock	35.603	35.71	35.47	35.61	7552159.0
2013-10-25 13:00:00	MSFT	Stock	35.61	35.88	35.6	35.84	7266579.0
2013-10-25 14:00:00	MSFT	Stock	35.84	35.97	35.805	35.895	7445082.0
2013-10-25 15:00:00	MSFT	Stock	35.89	35.945	35.65	35.73	14550999.0
2013-10-25 16:00:00	MSFT	Stock	35.73	35.883	35.68	35.71	4315865.0
2013-10-25 17:00:00	MSFT	Stock	35.71	35.809	35.68	35.68	9762.0
2013-10-25 18:00:00	MSFT	Stock	35.65	35.65	35.62	35.63	13812.0
2013-10-25 19:00:00	MSFT	Stock	35.63	35.63	35.62	35.63	4597.0
2013-10-25 08:00:00	NVDA	Stock	0.387	0.387	0.387	0.387	40000.0
2013-10-25 09:00:00	NVDA	Stock	0.3868	0.387	0.3841	0.3845	26059120.0
2013-10-25 10:00:00	NVDA	Stock	0.3845	0.3853	0.3828	0.384	86467920.0
2013-10-25 11:00:00	NVDA	Stock	0.3839	0.3848	0.3828	0.3828	32953120.0
2013-10-25 12:00:00	NVDA	Stock	0.3828	0.3833	0.3813	0.3815	33348360.0
2013-10-25 13:00:00	NVDA	Stock	0.3815	0.382	0.3806	0.3813	20916240.0
2013-10-25 14:00:00	NVDA	Stock	0.381	0.3822	0.3809	0.3814	24544760.0
2013-10-25 15:00:00	NVDA	Stock	0.3814	0.3818	0.3798	0.3809	89093520.0
2013-10-25 16:00:00	NVDA	Stock	0.381	0.3846	0.38	0.3809	15204240.0
2013-10-25 17:00:00	NVDA	Stock	0.38	0.38	0.38	0.38	4000.0
2013-10-25 18:00:00	NVDA	Stock	0.381	0.381	0.381	0.381	8680.0
2013-10-25 04:00:00	AMZN	Stock	17.9495	18.015	17.855	17.9	338200.0
2013-10-25 05:00:00	AMZN	Stock	17.95	18.1	17.913	18.05	128540.0
2013-10-25 06:00:00	AMZN	Stock	18.0095	18.102	18.0	18.086	204400.0
2013-10-25 07:00:00	AMZN	Stock	18.1	18.15	17.875	17.9	1388100.0
2013-10-25 08:00:00	AMZN	Stock	17.9005	18.125	17.7505	17.9025	5725100.0
2013-10-25 09:00:00	AMZN	Stock	17.9	18.3834	17.631	18.2435	85645200.0
2013-10-25 10:00:00	AMZN	Stock	18.2415	18.42	18.1325	18.1475	41384720.0

> showing 50 of 47,133 rows — these rows as CSV

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