PREVIEW / stock_1hour / 2015-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-12.parquet
  size:    1019 KB
  rows:    47,018
  symbols: 3,389

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-10-12 04:00:00	AAPL	Stock	28.03	28.1225	28.03	28.1	47728.0
2015-10-12 05:00:00	AAPL	Stock	28.09	28.1625	28.0625	28.1625	66364.0
2015-10-12 06:00:00	AAPL	Stock	28.1675	28.2	28.1475	28.2	100308.0
2015-10-12 07:00:00	AAPL	Stock	28.2	28.2925	28.165	28.18	526960.0
2015-10-12 08:00:00	AAPL	Stock	28.18	28.25	28.085	28.18	803236.0
2015-10-12 09:00:00	AAPL	Stock	28.1775	28.2	27.96	27.9712	23470492.0
2015-10-12 10:00:00	AAPL	Stock	27.97	28.1125	27.9325	28.01	19648324.0
2015-10-12 11:00:00	AAPL	Stock	28.01	28.0275	27.915	27.9525	15063528.0
2015-10-12 12:00:00	AAPL	Stock	27.9525	28.025	27.86	27.8725	12514560.0
2015-10-12 13:00:00	AAPL	Stock	27.875	28.01	27.86	27.9438	9851544.0
2015-10-12 14:00:00	AAPL	Stock	27.9425	27.995	27.9275	27.935	7517440.0
2015-10-12 15:00:00	AAPL	Stock	27.935	27.975	27.86	27.895	19264688.0
2015-10-12 16:00:00	AAPL	Stock	27.9	27.925	27.8525	27.9	4349584.0
2015-10-12 17:00:00	AAPL	Stock	27.905	27.91	27.8875	27.9	26712.0
2015-10-12 18:00:00	AAPL	Stock	27.9	27.9225	27.9	27.9	24048.0
2015-10-12 19:00:00	AAPL	Stock	27.9025	27.9125	27.9	27.9125	21096.0
2015-10-12 08:00:00	MSFT	Stock	46.97	47.13	46.8	46.8	3853.0
2015-10-12 09:00:00	MSFT	Stock	46.99	47.0	46.72	46.76	2570499.0
2015-10-12 10:00:00	MSFT	Stock	46.75	46.78	46.5	46.695	2433607.0
2015-10-12 11:00:00	MSFT	Stock	46.7	46.92	46.7	46.77	2340049.0
2015-10-12 12:00:00	MSFT	Stock	46.78	46.86	46.74	46.855	1321767.0
2015-10-12 13:00:00	MSFT	Stock	46.855	46.86	46.755	46.77	1019090.0
2015-10-12 14:00:00	MSFT	Stock	46.78	47.0	46.77	46.94	1539126.0
2015-10-12 15:00:00	MSFT	Stock	46.93	47.07	46.92	47.0	4006194.0
2015-10-12 16:00:00	MSFT	Stock	47.0	47.03	46.97	47.0	3664220.0
2015-10-12 18:00:00	MSFT	Stock	47.0	47.0	47.0	47.0	200.0
2015-10-12 19:00:00	MSFT	Stock	46.99	46.99	46.93	46.93	510.0
2015-10-12 08:00:00	NVDA	Stock	0.6598	0.6598	0.6488	0.6488	16000.0
2015-10-12 09:00:00	NVDA	Stock	0.65	0.655	0.6476	0.6505	22262120.0
2015-10-12 10:00:00	NVDA	Stock	0.6505	0.6614	0.6488	0.659	54542640.0
2015-10-12 11:00:00	NVDA	Stock	0.659	0.6602	0.654	0.6562	29864720.0
2015-10-12 12:00:00	NVDA	Stock	0.6563	0.6598	0.6556	0.6593	19895000.0
2015-10-12 13:00:00	NVDA	Stock	0.6593	0.6625	0.6582	0.6614	22501760.0
2015-10-12 14:00:00	NVDA	Stock	0.6615	0.6618	0.658	0.6592	19083200.0
2015-10-12 15:00:00	NVDA	Stock	0.659	0.6595	0.6572	0.6586	36794880.0
2015-10-12 16:00:00	NVDA	Stock	0.6588	0.6614	0.657	0.6588	10851520.0
2015-10-12 17:00:00	NVDA	Stock	0.657	0.657	0.657	0.657	20000.0
2015-10-12 18:00:00	NVDA	Stock	0.6598	0.6598	0.6595	0.6595	68000.0
2015-10-12 06:00:00	AMZN	Stock	27.049	27.1	27.049	27.099	14040.0
2015-10-12 07:00:00	AMZN	Stock	27.05	27.075	27.0	27.0	76000.0
2015-10-12 08:00:00	AMZN	Stock	27.003	27.003	26.9255	26.9595	74540.0
2015-10-12 09:00:00	AMZN	Stock	26.9895	27.2864	26.975	27.1855	7393960.0
2015-10-12 10:00:00	AMZN	Stock	27.179	27.3835	27.1645	27.3355	8620960.0
2015-10-12 11:00:00	AMZN	Stock	27.337	27.52	27.337	27.4475	7091640.0
2015-10-12 12:00:00	AMZN	Stock	27.4495	27.487	27.281	27.298	4428680.0
2015-10-12 13:00:00	AMZN	Stock	27.298	27.4486	27.2336	27.4248	4678820.0
2015-10-12 14:00:00	AMZN	Stock	27.4205	27.541	27.4033	27.4855	6524560.0
2015-10-12 15:00:00	AMZN	Stock	27.476	27.525	27.442	27.5095	8384340.0
2015-10-12 16:00:00	AMZN	Stock	27.5092	27.511	27.4658	27.5095	3174960.0
2015-10-12 17:00:00	AMZN	Stock	27.51	27.519	27.5095	27.519	33580.0

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

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