PREVIEW / stock_1hour / 2013-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-22.parquet
  size:    1.0 MB
  rows:    48,986
  symbols: 3,552

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-22 04:00:00	AAPL	Stock	18.75	18.75	18.7143	18.72	58800.0
2013-10-22 05:00:00	AAPL	Stock	18.72	18.7404	18.72	18.7404	76496.0
2013-10-22 06:00:00	AAPL	Stock	18.75	18.7643	18.7061	18.7643	376880.0
2013-10-22 07:00:00	AAPL	Stock	18.7843	18.8071	18.7286	18.7496	1468684.0
2013-10-22 08:00:00	AAPL	Stock	18.75	18.8871	18.7429	18.8214	5024012.0
2013-10-22 09:00:00	AAPL	Stock	18.8211	18.8796	18.6664	18.7174	75971336.0
2013-10-22 10:00:00	AAPL	Stock	18.7177	18.7893	18.1439	18.4836	101286220.0
2013-10-22 11:00:00	AAPL	Stock	18.4839	18.5932	18.3429	18.5732	71077356.0
2013-10-22 12:00:00	AAPL	Stock	18.5776	18.5821	18.4114	18.4489	36570688.0
2013-10-22 13:00:00	AAPL	Stock	18.4468	18.5804	18.4432	18.5511	45032708.0
2013-10-22 14:00:00	AAPL	Stock	18.5529	18.6554	18.2464	18.4893	113752576.0
2013-10-22 15:00:00	AAPL	Stock	18.4882	18.6518	18.48	18.5668	58814812.0
2013-10-22 16:00:00	AAPL	Stock	18.5667	18.742	18.5188	18.742	18727464.0
2013-10-22 17:00:00	AAPL	Stock	18.5939	18.7072	18.5585	18.6304	671328.0
2013-10-22 18:00:00	AAPL	Stock	18.6411	18.6421	18.5654	18.6093	539448.0
2013-10-22 19:00:00	AAPL	Stock	18.6075	18.625	18.5986	18.6071	241808.0
2013-10-22 08:00:00	MSFT	Stock	34.98	35.19	34.98	35.14	13243.0
2013-10-22 09:00:00	MSFT	Stock	35.14	35.14	34.715	34.93	4584139.0
2013-10-22 10:00:00	MSFT	Stock	34.93	34.99	34.69	34.885	6875416.0
2013-10-22 11:00:00	MSFT	Stock	34.89	34.95	34.69	34.83	4950947.0
2013-10-22 12:00:00	MSFT	Stock	34.83	34.85	34.75	34.784	2146717.0
2013-10-22 13:00:00	MSFT	Stock	34.78	34.83	34.57	34.666	3985851.0
2013-10-22 14:00:00	MSFT	Stock	34.67	34.71	34.58	34.6	4512200.0
2013-10-22 15:00:00	MSFT	Stock	34.6	34.65	34.52	34.57	7555258.0
2013-10-22 16:00:00	MSFT	Stock	34.58	34.854	34.55	34.59	3239410.0
2013-10-22 17:00:00	MSFT	Stock	34.59	34.6	34.55	34.6	78505.0
2013-10-22 18:00:00	MSFT	Stock	34.58	34.6	34.54	34.58	19978.0
2013-10-22 19:00:00	MSFT	Stock	34.6	34.6	34.6	34.6	465.0
2013-10-22 09:00:00	NVDA	Stock	0.3962	0.3965	0.3935	0.3935	13596400.0
2013-10-22 10:00:00	NVDA	Stock	0.3938	0.3953	0.3928	0.3931	46665840.0
2013-10-22 11:00:00	NVDA	Stock	0.3931	0.394	0.3908	0.394	26830480.0
2013-10-22 12:00:00	NVDA	Stock	0.394	0.3945	0.3928	0.3931	11990400.0
2013-10-22 13:00:00	NVDA	Stock	0.3933	0.3938	0.392	0.3936	25962960.0
2013-10-22 14:00:00	NVDA	Stock	0.3938	0.3945	0.3929	0.3941	16159600.0
2013-10-22 15:00:00	NVDA	Stock	0.3942	0.3955	0.3942	0.3945	28154400.0
2013-10-22 16:00:00	NVDA	Stock	0.3944	0.395	0.3925	0.3925	9989920.0
2013-10-22 17:00:00	NVDA	Stock	0.3918	0.3973	0.3908	0.3973	60000.0
2013-10-22 19:00:00	NVDA	Stock	0.3915	0.3915	0.3915	0.3915	12000.0
2013-10-22 04:00:00	AMZN	Stock	16.3145	16.3145	16.3145	16.3145	2000.0
2013-10-22 05:00:00	AMZN	Stock	16.3265	16.3265	16.175	16.175	57820.0
2013-10-22 06:00:00	AMZN	Stock	16.3125	16.322	16.3125	16.322	8000.0
2013-10-22 07:00:00	AMZN	Stock	16.347	16.37	16.347	16.37	4700.0
2013-10-22 08:00:00	AMZN	Stock	16.3665	16.4205	16.32	16.3825	189080.0
2013-10-22 09:00:00	AMZN	Stock	16.412	16.671	16.35	16.6445	15026120.0
2013-10-22 10:00:00	AMZN	Stock	16.646	16.8555	16.284	16.415	29143920.0
2013-10-22 11:00:00	AMZN	Stock	16.422	16.6	16.336	16.559	9350320.0
2013-10-22 12:00:00	AMZN	Stock	16.56	16.594	16.425	16.4775	3731080.0
2013-10-22 13:00:00	AMZN	Stock	16.48	16.635	16.475	16.6175	4572940.0
2013-10-22 14:00:00	AMZN	Stock	16.62	16.6395	16.534	16.58	4384780.0
2013-10-22 15:00:00	AMZN	Stock	16.58	16.6645	16.58	16.6285	8868080.0

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

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