PREVIEW / stock_1hour / 2014-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-12.parquet
  size:    1.0 MB
  rows:    47,970
  symbols: 3,569

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
2014-08-12 04:00:00	AAPL	Stock	24.0625	24.12	24.0625	24.12	4400.0
2014-08-12 05:00:00	AAPL	Stock	24.15	24.15	24.0875	24.0875	20536.0
2014-08-12 06:00:00	AAPL	Stock	24.08	24.1425	24.075	24.125	52260.0
2014-08-12 07:00:00	AAPL	Stock	24.1175	24.1225	24.04	24.07	143700.0
2014-08-12 08:00:00	AAPL	Stock	24.07	24.12	24.0375	24.0575	501784.0
2014-08-12 09:00:00	AAPL	Stock	24.0575	24.22	24.0075	24.15	26419760.0
2014-08-12 10:00:00	AAPL	Stock	24.1512	24.1725	24.06	24.0875	22242600.0
2014-08-12 11:00:00	AAPL	Stock	24.0875	24.095	23.975	24.0825	18967052.0
2014-08-12 12:00:00	AAPL	Stock	24.08	24.0825	24.0	24.02	10186832.0
2014-08-12 13:00:00	AAPL	Stock	24.0225	24.0575	24.0125	24.0415	8672800.0
2014-08-12 14:00:00	AAPL	Stock	24.04	24.045	23.9025	23.9112	14543692.0
2014-08-12 15:00:00	AAPL	Stock	23.9112	24.0425	23.9102	23.9925	20054272.0
2014-08-12 16:00:00	AAPL	Stock	23.9925	24.2	23.9675	23.9825	4890436.0
2014-08-12 17:00:00	AAPL	Stock	23.98	23.9925	23.96	23.9825	1150276.0
2014-08-12 18:00:00	AAPL	Stock	23.9825	23.9925	23.9775	23.9925	71868.0
2014-08-12 19:00:00	AAPL	Stock	23.99	23.9975	23.9875	23.9875	43848.0
2014-08-12 08:00:00	MSFT	Stock	43.2	43.2	43.2	43.2	100.0
2014-08-12 09:00:00	MSFT	Stock	43.22	43.49	43.0	43.34	2906531.0
2014-08-12 10:00:00	MSFT	Stock	43.34	43.54	43.29	43.36	3492548.0
2014-08-12 11:00:00	MSFT	Stock	43.35	43.37	43.21	43.3	1958733.0
2014-08-12 12:00:00	MSFT	Stock	43.3	43.39	43.25	43.355	1441002.0
2014-08-12 13:00:00	MSFT	Stock	43.35	43.48	43.345	43.417	1729029.0
2014-08-12 14:00:00	MSFT	Stock	43.417	43.48	43.31	43.39	2349905.0
2014-08-12 15:00:00	MSFT	Stock	43.39	43.59	43.38	43.525	3946854.0
2014-08-12 16:00:00	MSFT	Stock	43.52	43.55	43.299	43.529	2848894.0
2014-08-12 17:00:00	MSFT	Stock	43.52	43.52	43.52	43.52	7502.0
2014-08-12 18:00:00	MSFT	Stock	43.54	43.54	43.54	43.54	600.0
2014-08-12 19:00:00	MSFT	Stock	43.55	43.55	43.5	43.5	800.0
2014-08-12 09:00:00	NVDA	Stock	0.4728	0.475	0.4705	0.4734	25029560.0
2014-08-12 10:00:00	NVDA	Stock	0.4734	0.4735	0.4695	0.4704	35952280.0
2014-08-12 11:00:00	NVDA	Stock	0.4702	0.4702	0.4673	0.4689	38701800.0
2014-08-12 12:00:00	NVDA	Stock	0.469	0.472	0.468	0.4718	30706640.0
2014-08-12 13:00:00	NVDA	Stock	0.4718	0.4718	0.4694	0.47	24899760.0
2014-08-12 14:00:00	NVDA	Stock	0.47	0.4705	0.4686	0.4698	35115760.0
2014-08-12 15:00:00	NVDA	Stock	0.4695	0.4725	0.4695	0.4724	44136280.0
2014-08-12 16:00:00	NVDA	Stock	0.4725	0.4734	0.4718	0.4726	45541720.0
2014-08-12 18:00:00	NVDA	Stock	0.4738	0.4738	0.4738	0.4738	40000.0
2014-08-12 08:00:00	AMZN	Stock	15.9165	15.975	15.9165	15.957	65580.0
2014-08-12 09:00:00	AMZN	Stock	15.957	16.0	15.908	15.9965	5555480.0
2014-08-12 10:00:00	AMZN	Stock	15.9975	16.0655	15.943	15.962	7222460.0
2014-08-12 11:00:00	AMZN	Stock	15.9625	15.964	15.88	15.952	4690200.0
2014-08-12 12:00:00	AMZN	Stock	15.9495	15.995	15.9239	15.955	2825060.0
2014-08-12 13:00:00	AMZN	Stock	15.959	15.9825	15.915	15.9165	2315300.0
2014-08-12 14:00:00	AMZN	Stock	15.9135	15.9205	15.8475	15.88	3082660.0
2014-08-12 15:00:00	AMZN	Stock	15.8785	15.997	15.8785	15.967	6525300.0
2014-08-12 16:00:00	AMZN	Stock	15.966	15.975	15.9369	15.974	382620.0
2014-08-12 17:00:00	AMZN	Stock	15.966	15.966	15.966	15.966	56460.0
2014-08-12 18:00:00	AMZN	Stock	15.998	15.998	15.998	15.998	6000.0
2014-08-12 07:00:00	GOOGL	Stock	28.9495	28.9495	28.9495	28.9495	4000.0
2014-08-12 08:00:00	GOOGL	Stock	28.753	28.753	28.753	28.753	2100.0

> showing 50 of 47,970 rows — these rows as CSV

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