PREVIEW / stock_1hour / 2012-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-29.parquet
  size:    940 KB
  rows:    44,313
  symbols: 3,536

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-29 04:00:00	AAPL	Stock	22.0714	22.0979	22.0714	22.0718	44800.0
2012-03-29 05:00:00	AAPL	Stock	22.0536	22.0536	22.0411	22.0411	70812.0
2012-03-29 06:00:00	AAPL	Stock	22.0229	22.0357	22.0004	22.025	56000.0
2012-03-29 07:00:00	AAPL	Stock	22.0143	22.0429	22.0	22.0346	461384.0
2012-03-29 08:00:00	AAPL	Stock	22.0311	22.0536	21.9404	21.9714	4064676.0
2012-03-29 09:00:00	AAPL	Stock	21.9714	22.02	21.8304	21.9561	98387016.0
2012-03-29 10:00:00	AAPL	Stock	21.9561	21.985	21.89	21.9582	66352888.0
2012-03-29 11:00:00	AAPL	Stock	21.9582	21.9604	21.7364	21.7493	122615920.0
2012-03-29 12:00:00	AAPL	Stock	21.7496	21.8568	21.6868	21.8425	95528720.0
2012-03-29 13:00:00	AAPL	Stock	21.8421	21.8468	21.7304	21.7471	47699064.0
2012-03-29 14:00:00	AAPL	Stock	21.7468	21.8421	21.7411	21.8018	48401416.0
2012-03-29 15:00:00	AAPL	Stock	21.8	21.8729	21.7446	21.7807	96163928.0
2012-03-29 16:00:00	AAPL	Stock	21.7768	21.8269	21.7679	21.8186	19899320.0
2012-03-29 17:00:00	AAPL	Stock	21.8179	21.8196	21.6332	21.7279	3935596.0
2012-03-29 18:00:00	AAPL	Stock	21.7268	21.7429	21.675	21.675	754068.0
2012-03-29 19:00:00	AAPL	Stock	21.675	21.6875	21.6571	21.6721	1279404.0
2012-03-29 07:00:00	MSFT	Stock	32.2	32.2	32.2	32.2	1000.0
2012-03-29 08:00:00	MSFT	Stock	32.19	32.19	32.11	32.12	9428.0
2012-03-29 09:00:00	MSFT	Stock	32.12	32.19	31.83	31.95	5638108.0
2012-03-29 10:00:00	MSFT	Stock	31.98	32.12	31.93	32.012	4582454.0
2012-03-29 11:00:00	MSFT	Stock	32.01	32.04	31.83	31.9	4217611.0
2012-03-29 12:00:00	MSFT	Stock	31.9	31.94	31.81	31.87	2691799.0
2012-03-29 13:00:00	MSFT	Stock	31.875	31.96	31.835	31.86	3096255.0
2012-03-29 14:00:00	MSFT	Stock	31.86	32.015	31.84	31.99	4746032.0
2012-03-29 15:00:00	MSFT	Stock	31.99	32.19	31.95	32.13	8710216.0
2012-03-29 16:00:00	MSFT	Stock	32.12	32.207	31.943	32.049	2167934.0
2012-03-29 17:00:00	MSFT	Stock	32.17	32.17	32.17	32.17	209.0
2012-03-29 18:00:00	MSFT	Stock	32.16	32.16	32.16	32.16	150.0
2012-03-29 19:00:00	MSFT	Stock	32.15	32.15	32.15	32.15	155.0
2012-03-29 09:00:00	NVDA	Stock	0.3775	0.3838	0.3768	0.3788	67007920.0
2012-03-29 10:00:00	NVDA	Stock	0.3788	0.382	0.3773	0.3784	59351800.0
2012-03-29 11:00:00	NVDA	Stock	0.3785	0.3785	0.3753	0.376	33852200.0
2012-03-29 12:00:00	NVDA	Stock	0.376	0.3763	0.375	0.3755	24864880.0
2012-03-29 13:00:00	NVDA	Stock	0.3755	0.3758	0.3738	0.3749	34413360.0
2012-03-29 14:00:00	NVDA	Stock	0.3749	0.378	0.3748	0.378	33883320.0
2012-03-29 15:00:00	NVDA	Stock	0.3778	0.3813	0.3775	0.3808	104089080.0
2012-03-29 16:00:00	NVDA	Stock	0.3805	0.3815	0.3748	0.3815	13826560.0
2012-03-29 17:00:00	NVDA	Stock	0.3815	0.3815	0.3808	0.3813	54600.0
2012-03-29 19:00:00	NVDA	Stock	0.3808	0.3808	0.3808	0.3808	8000.0
2012-03-29 06:00:00	AMZN	Stock	10.025	10.05	10.0155	10.042	32000.0
2012-03-29 07:00:00	AMZN	Stock	10.042	10.042	10.0275	10.0375	32040.0
2012-03-29 08:00:00	AMZN	Stock	10.03	10.125	10.015	10.1135	331420.0
2012-03-29 09:00:00	AMZN	Stock	10.1175	10.245	10.0315	10.207	23783380.0
2012-03-29 10:00:00	AMZN	Stock	10.2068	10.229	10.114	10.215	20095800.0
2012-03-29 11:00:00	AMZN	Stock	10.211	10.2655	10.0625	10.0835	21757940.0
2012-03-29 12:00:00	AMZN	Stock	10.082	10.1385	10.0525	10.1255	11707820.0
2012-03-29 13:00:00	AMZN	Stock	10.125	10.1255	10.0671	10.114	6574480.0
2012-03-29 14:00:00	AMZN	Stock	10.1142	10.2125	10.111	10.2	9283880.0
2012-03-29 15:00:00	AMZN	Stock	10.1965	10.2615	10.1825	10.238	16796700.0
2012-03-29 16:00:00	AMZN	Stock	10.233	10.2495	10.0528	10.2375	2880980.0

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

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