PREVIEW / stock_1hour / 2014-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-17.parquet
  size:    1.0 MB
  rows:    48,268
  symbols: 3,577

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-09-17 04:00:00	AAPL	Stock	25.175	25.1875	25.165	25.1675	12812.0
2014-09-17 05:00:00	AAPL	Stock	25.1625	25.1625	25.1	25.13	23600.0
2014-09-17 06:00:00	AAPL	Stock	25.135	25.15	25.025	25.09	39448.0
2014-09-17 07:00:00	AAPL	Stock	25.0875	25.125	25.065	25.1	127476.0
2014-09-17 08:00:00	AAPL	Stock	25.095	25.31	25.0825	25.28	924192.0
2014-09-17 09:00:00	AAPL	Stock	25.265	25.4225	25.2	25.345	29819948.0
2014-09-17 10:00:00	AAPL	Stock	25.3475	25.385	25.1875	25.295	35163368.0
2014-09-17 11:00:00	AAPL	Stock	25.295	25.33	25.2525	25.2675	18487928.0
2014-09-17 12:00:00	AAPL	Stock	25.2675	25.305	25.215	25.22	17468904.0
2014-09-17 13:00:00	AAPL	Stock	25.22	25.3125	25.1875	25.2975	19442520.0
2014-09-17 14:00:00	AAPL	Stock	25.2965	25.405	25.148	25.3675	36924284.0
2014-09-17 15:00:00	AAPL	Stock	25.3688	25.45	25.3175	25.395	40560140.0
2014-09-17 16:00:00	AAPL	Stock	25.395	25.7195	25.26	25.3875	11536192.0
2014-09-17 17:00:00	AAPL	Stock	25.395	25.395	25.37	25.375	434384.0
2014-09-17 18:00:00	AAPL	Stock	25.385	25.395	25.375	25.39	103400.0
2014-09-17 19:00:00	AAPL	Stock	25.39	25.4	25.38	25.4	44332.0
2014-09-17 04:00:00	MSFT	Stock	46.7	46.7	46.6	46.7	5425.0
2014-09-17 05:00:00	MSFT	Stock	46.64	46.64	46.55	46.55	900.0
2014-09-17 06:00:00	MSFT	Stock	46.6	46.6	46.36	46.4	8408.0
2014-09-17 07:00:00	MSFT	Stock	46.4	46.43	46.31	46.4	46860.0
2014-09-17 08:00:00	MSFT	Stock	46.4	46.43	46.16	46.3	176036.0
2014-09-17 09:00:00	MSFT	Stock	46.3	46.66	46.23	46.55	5235254.0
2014-09-17 10:00:00	MSFT	Stock	46.56	46.67	46.5	46.52	4325325.0
2014-09-17 11:00:00	MSFT	Stock	46.51	46.54	46.46	46.48	3514696.0
2014-09-17 12:00:00	MSFT	Stock	46.485	46.53	46.4	46.48	2764285.0
2014-09-17 13:00:00	MSFT	Stock	46.47	46.56	46.41	46.52	2295372.0
2014-09-17 14:00:00	MSFT	Stock	46.53	46.62	46.355	46.597	8446727.0
2014-09-17 15:00:00	MSFT	Stock	46.59	46.69	46.445	46.51	7630103.0
2014-09-17 16:00:00	MSFT	Stock	46.52	46.554	46.5	46.52	2900698.0
2014-09-17 17:00:00	MSFT	Stock	46.52	46.52	46.51	46.51	7404.0
2014-09-17 18:00:00	MSFT	Stock	46.52	46.52	46.48	46.48	61681.0
2014-09-17 19:00:00	MSFT	Stock	46.5	46.51	46.5	46.51	900.0
2014-09-17 09:00:00	NVDA	Stock	0.4765	0.4832	0.4765	0.48	18266160.0
2014-09-17 10:00:00	NVDA	Stock	0.4798	0.4808	0.4782	0.479	17564200.0
2014-09-17 11:00:00	NVDA	Stock	0.479	0.4803	0.4775	0.478	13975560.0
2014-09-17 12:00:00	NVDA	Stock	0.478	0.4782	0.4766	0.477	10560160.0
2014-09-17 13:00:00	NVDA	Stock	0.477	0.479	0.4758	0.479	12768240.0
2014-09-17 14:00:00	NVDA	Stock	0.4788	0.4818	0.475	0.4818	38930000.0
2014-09-17 15:00:00	NVDA	Stock	0.4818	0.4829	0.4782	0.4788	47784080.0
2014-09-17 16:00:00	NVDA	Stock	0.4788	0.4793	0.4786	0.4788	8810040.0
2014-09-17 17:00:00	NVDA	Stock	0.4772	0.4772	0.4772	0.4772	4000.0
2014-09-17 07:00:00	AMZN	Stock	16.305	16.305	16.305	16.305	2000.0
2014-09-17 08:00:00	AMZN	Stock	16.388	16.388	16.355	16.375	44840.0
2014-09-17 09:00:00	AMZN	Stock	16.375	16.4	16.1385	16.2244	10428280.0
2014-09-17 10:00:00	AMZN	Stock	16.225	16.2385	16.076	16.2065	14846960.0
2014-09-17 11:00:00	AMZN	Stock	16.212	16.236	16.1695	16.223	5988140.0
2014-09-17 12:00:00	AMZN	Stock	16.229	16.259	16.156	16.243	4689440.0
2014-09-17 13:00:00	AMZN	Stock	16.243	16.3465	16.2375	16.32	7506520.0
2014-09-17 14:00:00	AMZN	Stock	16.3245	16.395	16.2075	16.294	11860880.0
2014-09-17 15:00:00	AMZN	Stock	16.2965	16.347	16.182	16.1995	14914600.0

> showing 50 of 48,268 rows — these rows as CSV

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