PREVIEW / stock_1hour / 2012-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-21.parquet
  size:    943 KB
  rows:    44,749
  symbols: 3,511

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-03-21 04:00:00	AAPL	Stock	21.6679	21.6932	21.65	21.6571	120400.0
2012-03-21 05:00:00	AAPL	Stock	21.6607	21.6607	21.5964	21.6196	44940.0
2012-03-21 06:00:00	AAPL	Stock	21.6107	21.6196	21.6018	21.6018	16772.0
2012-03-21 07:00:00	AAPL	Stock	21.5982	21.6339	21.5464	21.5789	620844.0
2012-03-21 08:00:00	AAPL	Stock	21.5721	21.6414	21.4682	21.4929	8843548.0
2012-03-21 09:00:00	AAPL	Stock	21.4993	21.6732	21.4789	21.6504	111223616.0
2012-03-21 10:00:00	AAPL	Stock	21.6554	21.7107	21.5968	21.6404	103281500.0
2012-03-21 11:00:00	AAPL	Stock	21.6374	21.7	21.6107	21.6404	60695768.0
2012-03-21 12:00:00	AAPL	Stock	21.6389	21.7054	21.6371	21.6989	42679224.0
2012-03-21 13:00:00	AAPL	Stock	21.6979	21.7407	21.6571	21.7234	49118300.0
2012-03-21 14:00:00	AAPL	Stock	21.7239	21.7711	21.7179	21.7557	65489340.0
2012-03-21 15:00:00	AAPL	Stock	21.7568	21.7732	21.5179	21.5179	151009432.0
2012-03-21 16:00:00	AAPL	Stock	21.5179	21.7539	21.5164	21.5371	38765020.0
2012-03-21 17:00:00	AAPL	Stock	21.5361	21.5504	21.5179	21.5464	1830304.0
2012-03-21 18:00:00	AAPL	Stock	21.5475	21.5704	21.5393	21.5643	532364.0
2012-03-21 19:00:00	AAPL	Stock	21.5636	21.5671	21.5571	21.5629	859600.0
2012-03-21 07:00:00	MSFT	Stock	32.06	32.06	32.0	32.05	6837.0
2012-03-21 08:00:00	MSFT	Stock	32.0	32.06	31.99	32.01	100423.0
2012-03-21 09:00:00	MSFT	Stock	32.03	32.15	31.92	31.99	5177848.0
2012-03-21 10:00:00	MSFT	Stock	31.99	32.01	31.87	31.926	4260972.0
2012-03-21 11:00:00	MSFT	Stock	31.92	31.94	31.82	31.83	3309462.0
2012-03-21 12:00:00	MSFT	Stock	31.83	32.02	31.82	32.005	3322650.0
2012-03-21 13:00:00	MSFT	Stock	32.005	32.03	31.91	31.985	4058797.0
2012-03-21 14:00:00	MSFT	Stock	31.99	32.04	31.97	31.995	3837462.0
2012-03-21 15:00:00	MSFT	Stock	32.0	32.1	31.91	31.935	7036574.0
2012-03-21 16:00:00	MSFT	Stock	31.925	32.073	31.84	31.91	5502564.0
2012-03-21 17:00:00	MSFT	Stock	31.94	31.94	31.91	31.92	2000.0
2012-03-21 18:00:00	MSFT	Stock	31.91	31.92	31.91	31.92	6300.0
2012-03-21 19:00:00	MSFT	Stock	31.94	31.94	31.92	31.92	600.0
2012-03-21 08:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	261520.0
2012-03-21 09:00:00	NVDA	Stock	0.36	0.3622	0.3592	0.3613	39472920.0
2012-03-21 10:00:00	NVDA	Stock	0.3612	0.3618	0.3562	0.3568	56107360.0
2012-03-21 11:00:00	NVDA	Stock	0.3568	0.3632	0.356	0.3625	126900120.0
2012-03-21 12:00:00	NVDA	Stock	0.3626	0.3648	0.3624	0.3625	60094600.0
2012-03-21 13:00:00	NVDA	Stock	0.3626	0.3635	0.3618	0.3625	56571680.0
2012-03-21 14:00:00	NVDA	Stock	0.3628	0.3634	0.3615	0.3625	44913520.0
2012-03-21 15:00:00	NVDA	Stock	0.3625	0.363	0.3612	0.3618	62748040.0
2012-03-21 16:00:00	NVDA	Stock	0.3615	0.3625	0.3615	0.3615	18970640.0
2012-03-21 18:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	16000.0
2012-03-21 19:00:00	NVDA	Stock	0.3638	0.3638	0.3638	0.3638	8000.0
2012-03-21 07:00:00	AMZN	Stock	9.618	9.65	9.618	9.649	40600.0
2012-03-21 08:00:00	AMZN	Stock	9.6165	9.6575	9.59	9.628	439700.0
2012-03-21 09:00:00	AMZN	Stock	9.6345	9.714	9.563	9.62	20081820.0
2012-03-21 10:00:00	AMZN	Stock	9.62	9.6603	9.574	9.59	20077900.0
2012-03-21 11:00:00	AMZN	Stock	9.5895	9.629	9.5635	9.6076	8312060.0
2012-03-21 12:00:00	AMZN	Stock	9.607	9.685	9.6	9.6705	7864080.0
2012-03-21 13:00:00	AMZN	Stock	9.671	9.6735	9.6085	9.622	4459200.0
2012-03-21 14:00:00	AMZN	Stock	9.6215	9.6414	9.605	9.6185	5933720.0
2012-03-21 15:00:00	AMZN	Stock	9.619	9.639	9.5745	9.5865	14323720.0
2012-03-21 16:00:00	AMZN	Stock	9.5865	9.6216	9.5705	9.586	2600880.0

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

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