PREVIEW / stock_1hour / 2016-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-20.parquet
  size:    1.1 MB
  rows:    51,129
  symbols: 3,415

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
2016-01-20 04:00:00	AAPL	Stock	23.875	23.875	23.4175	23.6825	112608.0
2016-01-20 05:00:00	AAPL	Stock	23.65	23.65	23.5825	23.6125	69220.0
2016-01-20 06:00:00	AAPL	Stock	23.635	23.6975	23.6125	23.6525	119448.0
2016-01-20 07:00:00	AAPL	Stock	23.67	23.775	23.645	23.7	307092.0
2016-01-20 08:00:00	AAPL	Stock	23.715	23.865	23.625	23.85	1376264.0
2016-01-20 09:00:00	AAPL	Stock	23.8525	23.885	23.605	23.63	33684972.0
2016-01-20 10:00:00	AAPL	Stock	23.6255	23.7025	23.355	23.375	43104568.0
2016-01-20 11:00:00	AAPL	Stock	23.3775	23.715	23.3625	23.52	34783196.0
2016-01-20 12:00:00	AAPL	Stock	23.52	23.6625	23.4237	23.6425	28014368.0
2016-01-20 13:00:00	AAPL	Stock	23.64	23.95	23.535	23.899	32916652.0
2016-01-20 14:00:00	AAPL	Stock	23.8995	24.06	23.8025	23.965	28041204.0
2016-01-20 15:00:00	AAPL	Stock	23.96	24.5475	23.9275	24.2025	51368824.0
2016-01-20 16:00:00	AAPL	Stock	24.2	24.25	24.1625	24.1875	17184448.0
2016-01-20 17:00:00	AAPL	Stock	24.1625	24.2075	24.16	24.1975	64648.0
2016-01-20 18:00:00	AAPL	Stock	24.1975	24.2875	24.1975	24.275	71872.0
2016-01-20 19:00:00	AAPL	Stock	24.28	24.315	24.25	24.3075	133160.0
2016-01-20 04:00:00	MSFT	Stock	50.01	50.01	49.6	49.64	4065.0
2016-01-20 05:00:00	MSFT	Stock	49.5	49.51	49.5	49.51	300.0
2016-01-20 06:00:00	MSFT	Stock	49.51	49.63	49.51	49.63	2193.0
2016-01-20 07:00:00	MSFT	Stock	49.6	49.61	49.45	49.53	6866.0
2016-01-20 08:00:00	MSFT	Stock	49.53	49.9	49.5	49.85	35849.0
2016-01-20 09:00:00	MSFT	Stock	49.74	50.199	49.58	49.72	5541343.0
2016-01-20 10:00:00	MSFT	Stock	49.72	50.07	49.52	49.636	7284603.0
2016-01-20 11:00:00	MSFT	Stock	49.64	50.23	49.57	49.72	6433495.0
2016-01-20 12:00:00	MSFT	Stock	49.728	49.83	49.1	49.75	6448213.0
2016-01-20 13:00:00	MSFT	Stock	49.75	50.74	49.68	50.7	9151815.0
2016-01-20 14:00:00	MSFT	Stock	50.69	50.7	50.045	50.275	6417361.0
2016-01-20 15:00:00	MSFT	Stock	50.275	51.38	50.17	50.78	13826169.0
2016-01-20 16:00:00	MSFT	Stock	50.78	50.99	50.76	50.89	3642329.0
2016-01-20 17:00:00	MSFT	Stock	50.79	51.0	50.79	51.0	44788.0
2016-01-20 18:00:00	MSFT	Stock	51.0	51.17	51.0	51.15	2819.0
2016-01-20 19:00:00	MSFT	Stock	51.15	51.25	51.15	51.25	1700.0
2016-01-20 08:00:00	NVDA	Stock	0.6738	0.674	0.6628	0.6702	136960.0
2016-01-20 09:00:00	NVDA	Stock	0.6688	0.6788	0.6675	0.6742	49419280.0
2016-01-20 10:00:00	NVDA	Stock	0.6742	0.6758	0.665	0.6668	55909960.0
2016-01-20 11:00:00	NVDA	Stock	0.667	0.6782	0.6652	0.6673	58677560.0
2016-01-20 12:00:00	NVDA	Stock	0.6673	0.6718	0.6612	0.671	43923160.0
2016-01-20 13:00:00	NVDA	Stock	0.6713	0.6785	0.6674	0.6774	37967320.0
2016-01-20 14:00:00	NVDA	Stock	0.677	0.6871	0.675	0.6841	47590080.0
2016-01-20 15:00:00	NVDA	Stock	0.684	0.6958	0.6825	0.6868	112136120.0
2016-01-20 16:00:00	NVDA	Stock	0.687	0.6875	0.687	0.6875	8779960.0
2016-01-20 17:00:00	NVDA	Stock	0.6875	0.6875	0.6875	0.6875	8000.0
2016-01-20 04:00:00	AMZN	Stock	28.2	28.2	28.0005	28.151	22400.0
2016-01-20 06:00:00	AMZN	Stock	28.145	28.2	28.145	28.15	20340.0
2016-01-20 07:00:00	AMZN	Stock	28.151	28.225	28.055	28.2	74720.0
2016-01-20 08:00:00	AMZN	Stock	28.1755	28.35	28.1105	28.33	262600.0
2016-01-20 09:00:00	AMZN	Stock	28.2755	28.35	27.5132	27.534	19718460.0
2016-01-20 10:00:00	AMZN	Stock	27.5295	27.8145	27.359	27.4293	21899300.0
2016-01-20 11:00:00	AMZN	Stock	27.425	27.696	27.4185	27.6035	13485580.0
2016-01-20 12:00:00	AMZN	Stock	27.6195	27.744	27.421	27.711	12447180.0

> showing 50 of 51,129 rows — these rows as CSV

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