PREVIEW / stock_1hour / 2012-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-13.parquet
  size:    917 KB
  rows:    43,282
  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-01-13 04:00:00	AAPL	Stock	15.0829	15.0829	15.0786	15.0786	8400.0
2012-01-13 05:00:00	AAPL	Stock	15.0786	15.0821	15.0643	15.0643	46704.0
2012-01-13 06:00:00	AAPL	Stock	15.0643	15.0643	15.0643	15.0643	5600.0
2012-01-13 07:00:00	AAPL	Stock	15.05	15.0679	15.0229	15.0296	227892.0
2012-01-13 08:00:00	AAPL	Stock	15.0296	15.07	14.9821	14.9871	1471512.0
2012-01-13 09:00:00	AAPL	Stock	14.9879	15.0161	14.9507	14.9829	39999372.0
2012-01-13 10:00:00	AAPL	Stock	14.9821	15.0046	14.9561	14.9739	46017972.0
2012-01-13 11:00:00	AAPL	Stock	14.9738	15.0089	14.9609	14.9943	21491540.0
2012-01-13 12:00:00	AAPL	Stock	14.995	14.9954	14.9661	14.9896	15330308.0
2012-01-13 13:00:00	AAPL	Stock	14.9904	14.9907	14.9643	14.9746	18024440.0
2012-01-13 14:00:00	AAPL	Stock	14.9757	14.9936	14.9689	14.9829	15870260.0
2012-01-13 15:00:00	AAPL	Stock	14.9834	15.0079	14.9771	14.9984	48811700.0
2012-01-13 16:00:00	AAPL	Stock	14.9993	15.0031	14.975	14.9989	12623716.0
2012-01-13 17:00:00	AAPL	Stock	14.9986	14.9996	14.9889	14.9911	349412.0
2012-01-13 18:00:00	AAPL	Stock	14.9893	14.9993	14.9893	14.9918	172088.0
2012-01-13 19:00:00	AAPL	Stock	14.9929	14.9964	14.9911	14.9961	114156.0
2012-01-13 08:00:00	MSFT	Stock	27.99	27.99	27.9	27.92	26756.0
2012-01-13 09:00:00	MSFT	Stock	27.92	28.0	27.79	27.96	5380800.0
2012-01-13 10:00:00	MSFT	Stock	27.96	27.96	27.79	27.896	13117985.0
2012-01-13 11:00:00	MSFT	Stock	27.893	28.0	27.86	27.99	6888990.0
2012-01-13 12:00:00	MSFT	Stock	27.995	28.0	27.95	28.0	3465959.0
2012-01-13 13:00:00	MSFT	Stock	28.0	28.03	27.9	28.02	4353493.0
2012-01-13 14:00:00	MSFT	Stock	28.02	28.09	27.98	28.069	5226980.0
2012-01-13 15:00:00	MSFT	Stock	28.065	28.25	28.06	28.25	15449364.0
2012-01-13 16:00:00	MSFT	Stock	28.25	28.33	27.91	28.25	4096888.0
2012-01-13 17:00:00	MSFT	Stock	28.24	28.25	28.151	28.25	79031.0
2012-01-13 18:00:00	MSFT	Stock	28.24	28.25	28.22	28.22	28241.0
2012-01-13 19:00:00	MSFT	Stock	28.24	28.25	28.23	28.25	5735.0
2012-01-13 08:00:00	NVDA	Stock	0.3535	0.3535	0.35	0.3505	50440.0
2012-01-13 09:00:00	NVDA	Stock	0.3505	0.3508	0.3458	0.346	62362360.0
2012-01-13 10:00:00	NVDA	Stock	0.346	0.3462	0.3415	0.3429	100532080.0
2012-01-13 11:00:00	NVDA	Stock	0.343	0.3468	0.3428	0.3442	61970640.0
2012-01-13 12:00:00	NVDA	Stock	0.3442	0.345	0.3422	0.3442	48485320.0
2012-01-13 13:00:00	NVDA	Stock	0.3445	0.3455	0.3438	0.3442	44046680.0
2012-01-13 14:00:00	NVDA	Stock	0.3444	0.3446	0.343	0.3439	39521640.0
2012-01-13 15:00:00	NVDA	Stock	0.3438	0.3445	0.3425	0.3433	122590160.0
2012-01-13 16:00:00	NVDA	Stock	0.3433	0.3525	0.3428	0.3428	8997240.0
2012-01-13 17:00:00	NVDA	Stock	0.3433	0.3433	0.3433	0.3433	88000.0
2012-01-13 18:00:00	NVDA	Stock	0.3433	0.3433	0.3425	0.3425	269720.0
2012-01-13 19:00:00	NVDA	Stock	0.343	0.343	0.343	0.343	52000.0
2012-01-13 04:00:00	AMZN	Stock	8.8125	8.8125	8.7885	8.7885	4000.0
2012-01-13 07:00:00	AMZN	Stock	8.796	8.799	8.796	8.7975	9160.0
2012-01-13 08:00:00	AMZN	Stock	8.796	8.81	8.7695	8.7695	61500.0
2012-01-13 09:00:00	AMZN	Stock	8.7695	8.841	8.684	8.7495	16109280.0
2012-01-13 10:00:00	AMZN	Stock	8.749	8.7875	8.675	8.785	13939920.0
2012-01-13 11:00:00	AMZN	Stock	8.783	8.831	8.782	8.8055	10551280.0
2012-01-13 12:00:00	AMZN	Stock	8.8025	8.861	8.8	8.849	8721780.0
2012-01-13 13:00:00	AMZN	Stock	8.85	8.854	8.805	8.849	5853040.0
2012-01-13 14:00:00	AMZN	Stock	8.8465	8.8845	8.8438	8.8798	8926080.0
2012-01-13 15:00:00	AMZN	Stock	8.8792	8.94	8.875	8.9255	17497180.0

> showing 50 of 43,282 rows — these rows as CSV

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