PREVIEW / stock_1hour / 2013-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-26.parquet
  size:    1.0 MB
  rows:    47,782
  symbols: 3,561

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-11-26 06:00:00	AAPL	Stock	18.7175	18.7232	18.7146	18.7204	22400.0
2013-11-26 07:00:00	AAPL	Stock	18.7004	18.7475	18.7	18.7475	81676.0
2013-11-26 08:00:00	AAPL	Stock	18.7357	18.7696	18.7071	18.755	1006068.0
2013-11-26 09:00:00	AAPL	Stock	18.7561	18.8518	18.7143	18.8201	45797276.0
2013-11-26 10:00:00	AAPL	Stock	18.8139	18.9046	18.7964	18.8893	55723724.0
2013-11-26 11:00:00	AAPL	Stock	18.8889	18.9589	18.8804	18.9351	43339240.0
2013-11-26 12:00:00	AAPL	Stock	18.9364	19.0718	18.9343	19.04	54899376.0
2013-11-26 13:00:00	AAPL	Stock	19.0418	19.1361	19.0409	19.1225	49969276.0
2013-11-26 14:00:00	AAPL	Stock	19.1232	19.1479	19.0846	19.1293	34381032.0
2013-11-26 15:00:00	AAPL	Stock	19.1307	19.1464	19.0507	19.0571	61277888.0
2013-11-26 16:00:00	AAPL	Stock	19.05	19.1262	18.8957	19.065	43363656.0
2013-11-26 17:00:00	AAPL	Stock	19.0593	19.0964	19.05	19.0964	2431072.0
2013-11-26 18:00:00	AAPL	Stock	19.1	19.1129	19.0893	19.0961	789852.0
2013-11-26 19:00:00	AAPL	Stock	19.0946	19.105	19.0925	19.0946	425740.0
2013-11-26 07:00:00	MSFT	Stock	37.6	37.63	37.6	37.63	346.0
2013-11-26 08:00:00	MSFT	Stock	37.6	37.71	37.6	37.64	48394.0
2013-11-26 09:00:00	MSFT	Stock	37.65	37.71	37.457	37.51	3071059.0
2013-11-26 10:00:00	MSFT	Stock	37.52	37.575	37.43	37.535	4083476.0
2013-11-26 11:00:00	MSFT	Stock	37.54	37.61	37.49	37.5	3117659.0
2013-11-26 12:00:00	MSFT	Stock	37.5	37.57	37.495	37.53	1548846.0
2013-11-26 13:00:00	MSFT	Stock	37.53	37.58	37.51	37.56	1525499.0
2013-11-26 14:00:00	MSFT	Stock	37.55	37.62	37.54	37.57	1636390.0
2013-11-26 15:00:00	MSFT	Stock	37.58	37.6	37.35	37.36	7891037.0
2013-11-26 16:00:00	MSFT	Stock	37.36	37.592	37.334	37.42	8972314.0
2013-11-26 17:00:00	MSFT	Stock	37.363	37.552	37.35	37.42	264631.0
2013-11-26 19:00:00	MSFT	Stock	37.4	37.4	37.4	37.4	100.0
2013-11-26 08:00:00	NVDA	Stock	0.3878	0.39	0.3878	0.3878	270591000.0
2013-11-26 09:00:00	NVDA	Stock	0.3925	0.3968	0.391	0.3935	107058040.0
2013-11-26 10:00:00	NVDA	Stock	0.3936	0.3938	0.391	0.3933	65931280.0
2013-11-26 11:00:00	NVDA	Stock	0.3933	0.3935	0.3905	0.3905	35657480.0
2013-11-26 12:00:00	NVDA	Stock	0.3906	0.3925	0.3905	0.3913	24585480.0
2013-11-26 13:00:00	NVDA	Stock	0.3913	0.3915	0.3894	0.3908	31543800.0
2013-11-26 14:00:00	NVDA	Stock	0.3908	0.392	0.3902	0.3905	39196480.0
2013-11-26 15:00:00	NVDA	Stock	0.3905	0.3915	0.3902	0.3908	48234320.0
2013-11-26 16:00:00	NVDA	Stock	0.391	0.3922	0.3882	0.3915	30220560.0
2013-11-26 17:00:00	NVDA	Stock	0.3912	0.3912	0.3912	0.3912	491880.0
2013-11-26 19:00:00	NVDA	Stock	0.391	0.391	0.391	0.391	40000.0
2013-11-26 05:00:00	AMZN	Stock	18.8375	18.8375	18.8375	18.8375	2000.0
2013-11-26 06:00:00	AMZN	Stock	18.8375	18.8375	18.8375	18.8375	27200.0
2013-11-26 07:00:00	AMZN	Stock	18.879	18.8805	18.879	18.8805	6000.0
2013-11-26 08:00:00	AMZN	Stock	18.8865	18.9	18.854	18.875	106080.0
2013-11-26 09:00:00	AMZN	Stock	18.888	18.888	18.76	18.79	8673500.0
2013-11-26 10:00:00	AMZN	Stock	18.7896	18.931	18.7409	18.9108	9743060.0
2013-11-26 11:00:00	AMZN	Stock	18.911	18.9465	18.887	18.9188	4168540.0
2013-11-26 12:00:00	AMZN	Stock	18.9155	19.125	18.9136	19.0695	9005360.0
2013-11-26 13:00:00	AMZN	Stock	19.0725	19.088	18.975	18.9865	4105780.0
2013-11-26 14:00:00	AMZN	Stock	18.991	19.0715	18.95	19.04	4825560.0
2013-11-26 15:00:00	AMZN	Stock	19.0379	19.105	19.0345	19.069	9369760.0
2013-11-26 16:00:00	AMZN	Stock	19.0685	19.098	18.9551	19.084	1031600.0
2013-11-26 17:00:00	AMZN	Stock	19.0745	19.0745	19.0685	19.0685	115820.0

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

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