PREVIEW / stock_1hour / 2012-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-30.parquet
  size:    949 KB
  rows:    44,653
  symbols: 3,551

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
2012-04-30 04:00:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2012-04-30 05:00:00	AAPL	Stock	21.5643	21.5782	21.5643	21.5782	11200.0
2012-04-30 06:00:00	AAPL	Stock	21.5643	21.5643	21.5107	21.5357	50400.0
2012-04-30 07:00:00	AAPL	Stock	21.5354	21.5354	21.3911	21.3911	603680.0
2012-04-30 08:00:00	AAPL	Stock	21.4068	21.5	21.3161	21.3861	4517240.0
2012-04-30 09:00:00	AAPL	Stock	21.3861	21.3861	21.0182	21.045	99811068.0
2012-04-30 10:00:00	AAPL	Stock	21.0443	21.1618	21.0089	21.1393	94803240.0
2012-04-30 11:00:00	AAPL	Stock	21.135	21.1504	20.9675	21.0389	54767020.0
2012-04-30 12:00:00	AAPL	Stock	21.0389	21.0446	20.8839	20.9421	55098428.0
2012-04-30 13:00:00	AAPL	Stock	20.9434	21.0234	20.9218	21.0114	31479896.0
2012-04-30 14:00:00	AAPL	Stock	21.0093	21.0236	20.8964	20.9011	40548340.0
2012-04-30 15:00:00	AAPL	Stock	20.9007	20.9368	20.8214	20.8589	94450356.0
2012-04-30 16:00:00	AAPL	Stock	20.8582	21.0679	20.8536	20.875	22300012.0
2012-04-30 17:00:00	AAPL	Stock	20.875	20.8789	20.8571	20.8607	581280.0
2012-04-30 18:00:00	AAPL	Stock	20.8686	20.8739	20.8536	20.8543	209328.0
2012-04-30 19:00:00	AAPL	Stock	20.8521	20.8625	20.8393	20.8571	417592.0
2012-04-30 04:00:00	MSFT	Stock	31.86	31.86	31.86	31.86	500.0
2012-04-30 07:00:00	MSFT	Stock	32.19	32.19	31.93	32.0	2100.0
2012-04-30 08:00:00	MSFT	Stock	32.07	32.07	32.0	32.02	12852.0
2012-04-30 09:00:00	MSFT	Stock	32.04	32.11	31.91	31.98	3926300.0
2012-04-30 10:00:00	MSFT	Stock	31.98	32.04	31.935	32.0	4403747.0
2012-04-30 11:00:00	MSFT	Stock	31.995	32.03	31.96	31.985	3094783.0
2012-04-30 12:00:00	MSFT	Stock	31.99	32.01	31.95	31.99	1897324.0
2012-04-30 13:00:00	MSFT	Stock	31.99	32.01	31.97	32.0	1781260.0
2012-04-30 14:00:00	MSFT	Stock	32.01	32.035	31.99	32.03	6118574.0
2012-04-30 15:00:00	MSFT	Stock	32.03	32.07	31.99	32.02	8744742.0
2012-04-30 16:00:00	MSFT	Stock	32.01	32.03	31.97	32.0	5471083.0
2012-04-30 17:00:00	MSFT	Stock	32.01	32.01	32.01	32.01	19813.0
2012-04-30 18:00:00	MSFT	Stock	32.01	32.01	32.0	32.0	5200.0
2012-04-30 19:00:00	MSFT	Stock	32.01	32.01	32.01	32.01	6100.0
2012-04-30 08:00:00	NVDA	Stock	0.325	0.325	0.325	0.325	40000.0
2012-04-30 09:00:00	NVDA	Stock	0.3238	0.3258	0.3205	0.3248	44149360.0
2012-04-30 10:00:00	NVDA	Stock	0.3246	0.3268	0.3238	0.3238	37266080.0
2012-04-30 11:00:00	NVDA	Stock	0.3238	0.3258	0.3233	0.3255	31748080.0
2012-04-30 12:00:00	NVDA	Stock	0.3255	0.3258	0.3243	0.325	20881600.0
2012-04-30 13:00:00	NVDA	Stock	0.3248	0.3253	0.3238	0.325	20986960.0
2012-04-30 14:00:00	NVDA	Stock	0.325	0.325	0.324	0.3243	22300880.0
2012-04-30 15:00:00	NVDA	Stock	0.3245	0.3255	0.3243	0.325	65345360.0
2012-04-30 16:00:00	NVDA	Stock	0.3248	0.3252	0.3243	0.325	17636480.0
2012-04-30 17:00:00	NVDA	Stock	0.3263	0.3263	0.3263	0.3263	4000.0
2012-04-30 19:00:00	NVDA	Stock	0.3258	0.326	0.3243	0.3243	146920.0
2012-04-30 04:00:00	AMZN	Stock	11.2255	11.325	11.2255	11.325	4000.0
2012-04-30 06:00:00	AMZN	Stock	11.2475	11.3245	11.2475	11.3245	8000.0
2012-04-30 07:00:00	AMZN	Stock	11.2	11.27	11.2	11.235	126500.0
2012-04-30 08:00:00	AMZN	Stock	11.225	11.295	11.225	11.2825	536720.0
2012-04-30 09:00:00	AMZN	Stock	11.2835	11.415	11.152	11.3495	31545620.0
2012-04-30 10:00:00	AMZN	Stock	11.3475	11.4695	11.2605	11.4575	35585140.0
2012-04-30 11:00:00	AMZN	Stock	11.4575	11.66	11.421	11.655	40136600.0
2012-04-30 12:00:00	AMZN	Stock	11.6555	11.692	11.5795	11.6695	25918880.0
2012-04-30 13:00:00	AMZN	Stock	11.669	11.675	11.6125	11.634	11951800.0

> showing 50 of 44,653 rows — these rows as CSV

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