PREVIEW / stock_1hour / 2012-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-13.parquet
  size:    904 KB
  rows:    42,992
  symbols: 3,471

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-08-13 04:00:00	AAPL	Stock	22.2036	22.2036	22.1661	22.1786	27076.0
2012-08-13 05:00:00	AAPL	Stock	22.2054	22.2054	22.2054	22.2054	26460.0
2012-08-13 06:00:00	AAPL	Stock	22.2321	22.2464	22.2321	22.2464	23800.0
2012-08-13 07:00:00	AAPL	Stock	22.2464	22.3571	22.24	22.3261	612248.0
2012-08-13 08:00:00	AAPL	Stock	22.3268	22.3429	22.2632	22.2889	2135140.0
2012-08-13 09:00:00	AAPL	Stock	22.2864	22.445	22.2589	22.3799	71945832.0
2012-08-13 10:00:00	AAPL	Stock	22.3769	22.4232	22.3429	22.3804	48775692.0
2012-08-13 11:00:00	AAPL	Stock	22.3807	22.4143	22.3401	22.4018	23579052.0
2012-08-13 12:00:00	AAPL	Stock	22.4018	22.4329	22.3804	22.426	20978440.0
2012-08-13 13:00:00	AAPL	Stock	22.4268	22.4375	22.4107	22.4246	17653328.0
2012-08-13 14:00:00	AAPL	Stock	22.4254	22.4732	22.4151	22.4661	30831192.0
2012-08-13 15:00:00	AAPL	Stock	22.4636	22.5	22.4371	22.5	49615916.0
2012-08-13 16:00:00	AAPL	Stock	22.5	22.5454	22.381	22.545	10488912.0
2012-08-13 17:00:00	AAPL	Stock	22.5429	22.5539	22.5	22.5518	570892.0
2012-08-13 18:00:00	AAPL	Stock	22.5493	22.5596	22.5429	22.5589	67732.0
2012-08-13 19:00:00	AAPL	Stock	22.5604	22.5714	22.5357	22.5357	351428.0
2012-08-13 08:00:00	MSFT	Stock	30.45	30.45	30.45	30.45	800.0
2012-08-13 09:00:00	MSFT	Stock	30.48	30.48	30.33	30.379	2354614.0
2012-08-13 10:00:00	MSFT	Stock	30.38	30.4	30.25	30.27	4392345.0
2012-08-13 11:00:00	MSFT	Stock	30.27	30.28	30.16	30.24	2840026.0
2012-08-13 12:00:00	MSFT	Stock	30.24	30.31	30.2	30.3	1925871.0
2012-08-13 13:00:00	MSFT	Stock	30.3	30.34	30.26	30.33	2195903.0
2012-08-13 14:00:00	MSFT	Stock	30.32	30.395	30.29	30.362	2640948.0
2012-08-13 15:00:00	MSFT	Stock	30.37	30.4	30.315	30.4	4829813.0
2012-08-13 16:00:00	MSFT	Stock	30.4	30.45	30.253	30.342	1550714.0
2012-08-13 17:00:00	MSFT	Stock	30.38	30.4	30.38	30.4	8400.0
2012-08-13 18:00:00	MSFT	Stock	30.39	30.4	30.39	30.4	1000.0
2012-08-13 19:00:00	MSFT	Stock	30.39	30.39	30.39	30.39	3500.0
2012-08-13 08:00:00	NVDA	Stock	0.3675	0.369	0.3675	0.3688	812080.0
2012-08-13 09:00:00	NVDA	Stock	0.369	0.3698	0.3645	0.3685	71638120.0
2012-08-13 10:00:00	NVDA	Stock	0.3686	0.369	0.3655	0.3668	78169480.0
2012-08-13 11:00:00	NVDA	Stock	0.3669	0.3692	0.3654	0.3685	67648760.0
2012-08-13 12:00:00	NVDA	Stock	0.3682	0.3705	0.367	0.3705	52715280.0
2012-08-13 13:00:00	NVDA	Stock	0.3705	0.3705	0.368	0.3695	41864760.0
2012-08-13 14:00:00	NVDA	Stock	0.3692	0.3705	0.369	0.37	34943600.0
2012-08-13 15:00:00	NVDA	Stock	0.37	0.3703	0.3685	0.3703	85386840.0
2012-08-13 16:00:00	NVDA	Stock	0.3703	0.3703	0.3685	0.3695	4844560.0
2012-08-13 17:00:00	NVDA	Stock	0.3703	0.3703	0.3703	0.3703	1182680.0
2012-08-13 18:00:00	NVDA	Stock	0.3682	0.3688	0.3682	0.3682	60000.0
2012-08-13 19:00:00	NVDA	Stock	0.3688	0.3695	0.3688	0.3695	75720.0
2012-08-13 07:00:00	AMZN	Stock	11.563	11.563	11.563	11.563	2000.0
2012-08-13 08:00:00	AMZN	Stock	11.619	11.619	11.619	11.619	4000.0
2012-08-13 09:00:00	AMZN	Stock	11.642	11.6885	11.592	11.6715	6095260.0
2012-08-13 10:00:00	AMZN	Stock	11.667	11.7184	11.5875	11.612	5992540.0
2012-08-13 11:00:00	AMZN	Stock	11.608	11.608	11.55	11.567	4913280.0
2012-08-13 12:00:00	AMZN	Stock	11.5655	11.6155	11.5525	11.611	3213140.0
2012-08-13 13:00:00	AMZN	Stock	11.613	11.664	11.601	11.643	3570140.0
2012-08-13 14:00:00	AMZN	Stock	11.643	11.6858	11.614	11.624	5384760.0
2012-08-13 15:00:00	AMZN	Stock	11.621	11.625	11.575	11.622	9474880.0
2012-08-13 16:00:00	AMZN	Stock	11.622	11.642	11.5827	11.6058	1187100.0

> showing 50 of 42,992 rows — these rows as CSV

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