PREVIEW / stock_1hour / 2015-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-22.parquet
  size:    1.0 MB
  rows:    48,345
  symbols: 3,482

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
2015-07-22 04:00:00	AAPL	Stock	30.425	31.23	30.425	30.9375	889996.0
2015-07-22 05:00:00	AAPL	Stock	30.9375	31.1075	30.87	30.8775	329924.0
2015-07-22 06:00:00	AAPL	Stock	30.8825	30.9225	30.6425	30.6575	1200396.0
2015-07-22 07:00:00	AAPL	Stock	30.6525	30.75	30.4775	30.61	2400164.0
2015-07-22 08:00:00	AAPL	Stock	30.61	30.9175	30.3125	30.405	9335772.0
2015-07-22 09:00:00	AAPL	Stock	30.41	31.2325	30.28	31.1838	142481996.0
2015-07-22 10:00:00	AAPL	Stock	31.1825	31.235	30.98	31.2	79326420.0
2015-07-22 11:00:00	AAPL	Stock	31.205	31.225	30.915	30.97	42182336.0
2015-07-22 12:00:00	AAPL	Stock	30.97	31.2225	30.96	31.1775	29805416.0
2015-07-22 13:00:00	AAPL	Stock	31.18	31.375	31.1325	31.2225	34611456.0
2015-07-22 14:00:00	AAPL	Stock	31.2212	31.32	31.17	31.2915	26148548.0
2015-07-22 15:00:00	AAPL	Stock	31.2825	31.305	31.1775	31.305	42543852.0
2015-07-22 16:00:00	AAPL	Stock	31.305	31.4375	31.28	31.4125	17979468.0
2015-07-22 17:00:00	AAPL	Stock	31.4125	31.4375	31.3875	31.4025	296316.0
2015-07-22 18:00:00	AAPL	Stock	31.395	31.4375	31.395	31.4	167464.0
2015-07-22 19:00:00	AAPL	Stock	31.4008	31.4375	31.3925	31.4225	176740.0
2015-07-22 04:00:00	MSFT	Stock	45.27	45.5	45.0	45.5	7200.0
2015-07-22 06:00:00	MSFT	Stock	45.44	45.5	45.25	45.25	7345.0
2015-07-22 07:00:00	MSFT	Stock	45.25	45.45	45.25	45.39	58695.0
2015-07-22 08:00:00	MSFT	Stock	45.38	45.8	45.3	45.66	140232.0
2015-07-22 09:00:00	MSFT	Stock	45.67	46.93	45.3	46.86	9472990.0
2015-07-22 10:00:00	MSFT	Stock	46.87	46.93	45.73	45.955	10353291.0
2015-07-22 11:00:00	MSFT	Stock	45.96	46.095	45.62	45.83	8278356.0
2015-07-22 12:00:00	MSFT	Stock	45.83	45.98	45.43	45.94	6149055.0
2015-07-22 13:00:00	MSFT	Stock	45.94	46.02	45.4	45.46	5110771.0
2015-07-22 14:00:00	MSFT	Stock	45.46	45.6	45.203	45.375	4845187.0
2015-07-22 15:00:00	MSFT	Stock	45.37	45.54	45.23	45.54	8459864.0
2015-07-22 16:00:00	MSFT	Stock	45.54	45.59	45.49	45.54	2360938.0
2015-07-22 17:00:00	MSFT	Stock	45.54	45.59	45.54	45.59	4490.0
2015-07-22 18:00:00	MSFT	Stock	45.6	45.6	45.6	45.6	5900.0
2015-07-22 19:00:00	MSFT	Stock	45.6	45.64	45.6	45.63	2300.0
2015-07-22 07:00:00	NVDA	Stock	0.492	0.492	0.4918	0.4918	20000.0
2015-07-22 08:00:00	NVDA	Stock	0.4918	0.4918	0.4885	0.489	44000.0
2015-07-22 09:00:00	NVDA	Stock	0.4883	0.4918	0.4828	0.4838	29848200.0
2015-07-22 10:00:00	NVDA	Stock	0.4838	0.4868	0.4808	0.481	52981400.0
2015-07-22 11:00:00	NVDA	Stock	0.4812	0.4848	0.4793	0.484	54252280.0
2015-07-22 12:00:00	NVDA	Stock	0.4838	0.4883	0.4838	0.4883	47248560.0
2015-07-22 13:00:00	NVDA	Stock	0.4883	0.489	0.4862	0.4868	58294880.0
2015-07-22 14:00:00	NVDA	Stock	0.4868	0.4885	0.4852	0.4884	37460000.0
2015-07-22 15:00:00	NVDA	Stock	0.4883	0.4885	0.4844	0.4852	49883520.0
2015-07-22 16:00:00	NVDA	Stock	0.4851	0.4865	0.4851	0.4865	1542560.0
2015-07-22 04:00:00	AMZN	Stock	24.35	24.401	24.35	24.4	30000.0
2015-07-22 05:00:00	AMZN	Stock	24.3575	24.3575	24.355	24.355	12000.0
2015-07-22 06:00:00	AMZN	Stock	24.3945	24.5	24.3945	24.5	44600.0
2015-07-22 07:00:00	AMZN	Stock	24.456	24.5	24.4275	24.4275	80880.0
2015-07-22 08:00:00	AMZN	Stock	24.5395	24.5395	24.3125	24.362	211380.0
2015-07-22 09:00:00	AMZN	Stock	24.35	24.5135	24.2575	24.5135	9372680.0
2015-07-22 10:00:00	AMZN	Stock	24.4785	24.625	24.4145	24.488	11749400.0
2015-07-22 11:00:00	AMZN	Stock	24.4925	24.494	24.3065	24.323	6334660.0
2015-07-22 12:00:00	AMZN	Stock	24.3165	24.3768	24.245	24.325	5885560.0

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

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