PREVIEW / stock_1hour / 2011-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-27.parquet
  size:    923 KB
  rows:    43,962
  symbols: 3,534

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
2011-05-27 05:00:00	AAPL	Stock	11.9732	11.9732	11.9732	11.9732	2800.0
2011-05-27 07:00:00	AAPL	Stock	11.9889	11.9889	11.9804	11.9804	8400.0
2011-05-27 08:00:00	AAPL	Stock	11.9714	12.0	11.9714	11.9857	458556.0
2011-05-27 09:00:00	AAPL	Stock	11.9893	11.9918	11.9396	11.9607	31384388.0
2011-05-27 10:00:00	AAPL	Stock	11.9607	12.055	11.95	12.0397	46953732.0
2011-05-27 11:00:00	AAPL	Stock	12.0393	12.0446	12.0211	12.0304	24640280.0
2011-05-27 12:00:00	AAPL	Stock	12.03	12.0368	12.0218	12.0257	15946056.0
2011-05-27 13:00:00	AAPL	Stock	12.0254	12.0296	12.0101	12.0107	15737512.0
2011-05-27 14:00:00	AAPL	Stock	12.0104	12.0189	11.9846	11.9882	17530100.0
2011-05-27 15:00:00	AAPL	Stock	11.9896	12.0582	11.9825	12.0489	42309596.0
2011-05-27 16:00:00	AAPL	Stock	12.0489	12.0625	11.9946	12.0625	5312300.0
2011-05-27 17:00:00	AAPL	Stock	12.05	12.0589	12.0439	12.0536	97860.0
2011-05-27 18:00:00	AAPL	Stock	12.0504	12.0536	12.05	12.05	44324.0
2011-05-27 19:00:00	AAPL	Stock	12.05	12.0536	12.0486	12.0518	35728.0
2011-05-27 08:00:00	MSFT	Stock	24.72	24.83	24.69	24.76	10800.0
2011-05-27 09:00:00	MSFT	Stock	24.76	24.78	24.62	24.7	6813759.0
2011-05-27 10:00:00	MSFT	Stock	24.7	24.77	24.65	24.77	8420642.0
2011-05-27 11:00:00	MSFT	Stock	24.76	24.81	24.73	24.765	5821724.0
2011-05-27 12:00:00	MSFT	Stock	24.765	24.88	24.75	24.865	5048012.0
2011-05-27 13:00:00	MSFT	Stock	24.86	24.9	24.79	24.89	6323776.0
2011-05-27 14:00:00	MSFT	Stock	24.895	24.9	24.79	24.8	5205895.0
2011-05-27 15:00:00	MSFT	Stock	24.81	24.86	24.75	24.76	10177158.0
2011-05-27 16:00:00	MSFT	Stock	24.76	24.838	24.19	24.815	1699455.0
2011-05-27 17:00:00	MSFT	Stock	24.67	24.83	24.67	24.83	6910.0
2011-05-27 18:00:00	MSFT	Stock	24.76	24.81	24.76	24.79	7896.0
2011-05-27 19:00:00	MSFT	Stock	24.8	24.83	24.8	24.83	1592.0
2011-05-27 07:00:00	NVDA	Stock	0.4705	0.4705	0.4705	0.4705	16000.0
2011-05-27 08:00:00	NVDA	Stock	0.4725	0.475	0.472	0.4748	265320.0
2011-05-27 09:00:00	NVDA	Stock	0.4748	0.4775	0.472	0.4768	69628960.0
2011-05-27 10:00:00	NVDA	Stock	0.477	0.48	0.4745	0.4795	95143080.0
2011-05-27 11:00:00	NVDA	Stock	0.4795	0.4875	0.479	0.4868	117612520.0
2011-05-27 12:00:00	NVDA	Stock	0.4869	0.4875	0.4852	0.486	64108680.0
2011-05-27 13:00:00	NVDA	Stock	0.486	0.4875	0.4832	0.484	69001600.0
2011-05-27 14:00:00	NVDA	Stock	0.4843	0.487	0.4832	0.4843	59092240.0
2011-05-27 15:00:00	NVDA	Stock	0.4843	0.4883	0.484	0.4875	158267360.0
2011-05-27 16:00:00	NVDA	Stock	0.4872	0.488	0.4829	0.487	1996360.0
2011-05-27 17:00:00	NVDA	Stock	0.4705	0.487	0.4705	0.4865	77200.0
2011-05-27 18:00:00	NVDA	Stock	0.4865	0.4865	0.4865	0.4865	4000.0
2011-05-27 19:00:00	NVDA	Stock	0.487	0.4875	0.4865	0.4875	202600.0
2011-05-27 09:00:00	AMZN	Stock	9.775	9.775	9.6805	9.714	7637480.0
2011-05-27 10:00:00	AMZN	Stock	9.7115	9.806	9.675	9.786	9609620.0
2011-05-27 11:00:00	AMZN	Stock	9.7859	9.7925	9.7538	9.7609	4961200.0
2011-05-27 12:00:00	AMZN	Stock	9.7625	9.7625	9.7305	9.7382	3841860.0
2011-05-27 13:00:00	AMZN	Stock	9.7385	9.7605	9.7315	9.7409	3478900.0
2011-05-27 14:00:00	AMZN	Stock	9.7418	9.8048	9.7005	9.7045	4661360.0
2011-05-27 15:00:00	AMZN	Stock	9.703	9.721	9.6915	9.707	10293300.0
2011-05-27 16:00:00	AMZN	Stock	9.708	9.732	9.7038	9.721	1994180.0
2011-05-27 17:00:00	AMZN	Stock	9.712	9.7335	9.707	9.7335	17980.0
2011-05-27 18:00:00	AMZN	Stock	9.7065	9.7065	9.7065	9.7065	26560.0
2011-05-27 19:00:00	AMZN	Stock	9.701	9.7025	9.7	9.7	19440.0

> showing 50 of 43,962 rows — these rows as CSV

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