PREVIEW / stock_1hour / 2011-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-13.parquet
  size:    932 KB
  rows:    44,708
  symbols: 3,526

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-12-13 04:00:00	AAPL	Stock	14.0	14.0	14.0	14.0	2800.0
2011-12-13 05:00:00	AAPL	Stock	14.0357	14.0357	14.0357	14.0357	2800.0
2011-12-13 06:00:00	AAPL	Stock	14.0714	14.0714	14.0711	14.0714	8400.0
2011-12-13 07:00:00	AAPL	Stock	14.0579	14.0714	14.0357	14.0679	145740.0
2011-12-13 08:00:00	AAPL	Stock	14.0536	14.0725	13.9943	14.0446	2370592.0
2011-12-13 09:00:00	AAPL	Stock	14.0375	14.1214	14.025	14.1011	48718740.0
2011-12-13 10:00:00	AAPL	Stock	14.108	14.1082	14.0061	14.0349	51827524.0
2011-12-13 11:00:00	AAPL	Stock	14.0321	14.0429	13.985	14.0382	35848680.0
2011-12-13 12:00:00	AAPL	Stock	14.0386	14.0446	13.9961	14.0271	24443132.0
2011-12-13 13:00:00	AAPL	Stock	14.0268	14.0386	14.0011	14.0304	18888632.0
2011-12-13 14:00:00	AAPL	Stock	14.0325	14.0621	13.9571	13.9971	48073004.0
2011-12-13 15:00:00	AAPL	Stock	13.9961	14.0129	13.825	13.8854	90612340.0
2011-12-13 16:00:00	AAPL	Stock	13.8831	14.0436	13.8584	13.8893	11108524.0
2011-12-13 17:00:00	AAPL	Stock	13.9943	13.9943	13.8875	13.9021	165200.0
2011-12-13 18:00:00	AAPL	Stock	13.9061	13.9093	13.8861	13.9025	131404.0
2011-12-13 19:00:00	AAPL	Stock	13.9004	13.9107	13.8968	13.9107	74060.0
2011-12-13 07:00:00	MSFT	Stock	25.69	25.7	25.51	25.65	6100.0
2011-12-13 08:00:00	MSFT	Stock	25.66	25.73	25.61	25.7	46750.0
2011-12-13 09:00:00	MSFT	Stock	25.69	26.0	25.68	25.93	6365003.0
2011-12-13 10:00:00	MSFT	Stock	25.94	26.05	25.79	25.89	8624695.0
2011-12-13 11:00:00	MSFT	Stock	25.89	26.02	25.79	26.0	6245772.0
2011-12-13 12:00:00	MSFT	Stock	26.001	26.03	25.91	25.98	3549632.0
2011-12-13 13:00:00	MSFT	Stock	25.98	26.04	25.94	26.015	3966583.0
2011-12-13 14:00:00	MSFT	Stock	26.011	26.1	25.84	25.89	7819979.0
2011-12-13 15:00:00	MSFT	Stock	25.885	25.92	25.651	25.73	13765684.0
2011-12-13 16:00:00	MSFT	Stock	25.74	25.99	25.73	25.769	3361085.0
2011-12-13 17:00:00	MSFT	Stock	25.51	25.83	25.51	25.83	4995.0
2011-12-13 18:00:00	MSFT	Stock	25.76	25.8	25.76	25.8	9747.0
2011-12-13 19:00:00	MSFT	Stock	25.78	25.78	25.75	25.75	1700.0
2011-12-13 08:00:00	NVDA	Stock	0.3638	0.3662	0.3638	0.3662	48000.0
2011-12-13 09:00:00	NVDA	Stock	0.3662	0.3725	0.3662	0.368	43828280.0
2011-12-13 10:00:00	NVDA	Stock	0.3679	0.372	0.3635	0.364	73348960.0
2011-12-13 11:00:00	NVDA	Stock	0.364	0.3642	0.3608	0.3633	56840400.0
2011-12-13 12:00:00	NVDA	Stock	0.3635	0.3688	0.3602	0.3622	43352400.0
2011-12-13 13:00:00	NVDA	Stock	0.3622	0.3682	0.3582	0.3585	69153320.0
2011-12-13 14:00:00	NVDA	Stock	0.3586	0.3673	0.355	0.3555	84881480.0
2011-12-13 15:00:00	NVDA	Stock	0.3555	0.3668	0.351	0.3533	128210200.0
2011-12-13 16:00:00	NVDA	Stock	0.3525	0.3623	0.3525	0.354	3201080.0
2011-12-13 17:00:00	NVDA	Stock	0.3632	0.3632	0.3632	0.3632	28000.0
2011-12-13 18:00:00	NVDA	Stock	0.3533	0.354	0.3533	0.3538	399920.0
2011-12-13 19:00:00	NVDA	Stock	0.3538	0.354	0.3525	0.354	306800.0
2011-12-13 07:00:00	AMZN	Stock	9.484	9.54	9.451	9.536	38000.0
2011-12-13 08:00:00	AMZN	Stock	9.52	9.52	9.4	9.45	610780.0
2011-12-13 09:00:00	AMZN	Stock	9.4485	9.484	9.3136	9.33	21079480.0
2011-12-13 10:00:00	AMZN	Stock	9.321	9.4079	9.1265	9.1375	31986720.0
2011-12-13 11:00:00	AMZN	Stock	9.1367	9.4379	9.052	9.1255	33630040.0
2011-12-13 12:00:00	AMZN	Stock	9.1314	9.3729	9.1005	9.149	12293800.0
2011-12-13 13:00:00	AMZN	Stock	9.146	9.3531	9.106	9.131	10574280.0
2011-12-13 14:00:00	AMZN	Stock	9.131	9.3451	9.025	9.043	25800880.0
2011-12-13 15:00:00	AMZN	Stock	9.044	9.09	8.925	9.025	38510040.0

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

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