PREVIEW / stock_1hour / 2012-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-16.parquet
  size:    919 KB
  rows:    43,396
  symbols: 3,440

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-08-16 04:00:00	AAPL	Stock	22.5539	22.5539	22.5361	22.5361	25200.0
2012-08-16 06:00:00	AAPL	Stock	22.5871	22.5889	22.5871	22.5889	5600.0
2012-08-16 07:00:00	AAPL	Stock	22.58	22.605	22.5611	22.6007	245224.0
2012-08-16 08:00:00	AAPL	Stock	22.5907	22.6071	22.5643	22.5643	1248072.0
2012-08-16 09:00:00	AAPL	Stock	22.5629	22.6071	22.5179	22.5707	35110376.0
2012-08-16 10:00:00	AAPL	Stock	22.57	22.6571	22.5261	22.6564	43966328.0
2012-08-16 11:00:00	AAPL	Stock	22.6561	22.7268	22.6386	22.7048	45026744.0
2012-08-16 12:00:00	AAPL	Stock	22.7061	22.7211	22.6704	22.7086	27023164.0
2012-08-16 13:00:00	AAPL	Stock	22.7071	22.7071	22.6604	22.6879	19226480.0
2012-08-16 14:00:00	AAPL	Stock	22.6879	22.7414	22.675	22.7179	32393060.0
2012-08-16 15:00:00	AAPL	Stock	22.7214	22.7332	22.7	22.725	40552372.0
2012-08-16 16:00:00	AAPL	Stock	22.725	22.7286	22.6567	22.725	6340096.0
2012-08-16 17:00:00	AAPL	Stock	22.7239	22.7264	22.7207	22.7207	118916.0
2012-08-16 18:00:00	AAPL	Stock	22.7207	22.7207	22.6871	22.6911	175280.0
2012-08-16 19:00:00	AAPL	Stock	22.6996	22.7	22.6825	22.6825	147308.0
2012-08-16 08:00:00	MSFT	Stock	30.27	30.3	30.25	30.28	27796.0
2012-08-16 09:00:00	MSFT	Stock	30.25	30.4	30.25	30.39	3548976.0
2012-08-16 10:00:00	MSFT	Stock	30.39	30.68	30.36	30.64	6447008.0
2012-08-16 11:00:00	MSFT	Stock	30.64	30.86	30.631	30.812	5340255.0
2012-08-16 12:00:00	MSFT	Stock	30.81	30.87	30.78	30.854	3815485.0
2012-08-16 13:00:00	MSFT	Stock	30.85	30.92	30.78	30.8	3368156.0
2012-08-16 14:00:00	MSFT	Stock	30.81	30.94	30.79	30.915	3620002.0
2012-08-16 15:00:00	MSFT	Stock	30.915	30.94	30.77	30.79	7039236.0
2012-08-16 16:00:00	MSFT	Stock	30.8	30.89	30.635	30.72	2015691.0
2012-08-16 17:00:00	MSFT	Stock	30.77	30.81	30.77	30.8	8244.0
2012-08-16 18:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	120.0
2012-08-16 19:00:00	MSFT	Stock	30.78	30.78	30.72	30.72	1774.0
2012-08-16 08:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	20000.0
2012-08-16 09:00:00	NVDA	Stock	0.3645	0.367	0.363	0.3665	48633080.0
2012-08-16 10:00:00	NVDA	Stock	0.3668	0.3678	0.366	0.3674	58258440.0
2012-08-16 11:00:00	NVDA	Stock	0.3674	0.3688	0.3665	0.3685	58951720.0
2012-08-16 12:00:00	NVDA	Stock	0.3685	0.3706	0.3675	0.3687	39942480.0
2012-08-16 13:00:00	NVDA	Stock	0.3688	0.3688	0.3678	0.3685	25285600.0
2012-08-16 14:00:00	NVDA	Stock	0.3682	0.3695	0.3682	0.3687	45083080.0
2012-08-16 15:00:00	NVDA	Stock	0.3687	0.3698	0.3681	0.3695	78723680.0
2012-08-16 16:00:00	NVDA	Stock	0.3695	0.3696	0.362	0.3693	15306760.0
2012-08-16 17:00:00	NVDA	Stock	0.369	0.369	0.368	0.368	20640.0
2012-08-16 18:00:00	NVDA	Stock	0.3695	0.37	0.3695	0.37	280000.0
2012-08-16 19:00:00	NVDA	Stock	0.3695	0.3695	0.3695	0.3695	6720.0
2012-08-16 08:00:00	AMZN	Stock	11.8835	11.8925	11.873	11.875	182140.0
2012-08-16 09:00:00	AMZN	Stock	11.875	11.9505	11.81	11.9505	13300660.0
2012-08-16 10:00:00	AMZN	Stock	11.9448	11.9635	11.8965	11.9407	12082320.0
2012-08-16 11:00:00	AMZN	Stock	11.939	12.044	11.915	12.0361	13512800.0
2012-08-16 12:00:00	AMZN	Stock	12.0375	12.085	12.025	12.054	11339640.0
2012-08-16 13:00:00	AMZN	Stock	12.054	12.0945	12.0225	12.05	7300580.0
2012-08-16 14:00:00	AMZN	Stock	12.047	12.137	12.039	12.1205	9054540.0
2012-08-16 15:00:00	AMZN	Stock	12.1205	12.1412	12.074	12.0745	15958620.0
2012-08-16 16:00:00	AMZN	Stock	12.0775	12.1185	11.9473	12.1185	3299820.0
2012-08-16 17:00:00	AMZN	Stock	12.059	12.07	12.059	12.07	32000.0
2012-08-16 19:00:00	AMZN	Stock	12.068	12.072	12.068	12.072	14000.0

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

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