PREVIEW / stock_1hour / 2016-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-04.parquet
  size:    1.0 MB
  rows:    49,025
  symbols: 3,350

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-03-04 04:00:00	AAPL	Stock	25.4	25.4	25.4	25.4	3600.0
2016-03-04 05:00:00	AAPL	Stock	25.4125	25.475	25.39	25.445	31516.0
2016-03-04 06:00:00	AAPL	Stock	25.4725	25.475	25.4575	25.475	4600.0
2016-03-04 07:00:00	AAPL	Stock	25.475	25.52	25.4725	25.4725	63972.0
2016-03-04 08:00:00	AAPL	Stock	25.475	25.6225	25.4	25.4975	935248.0
2016-03-04 09:00:00	AAPL	Stock	25.4875	25.595	25.3425	25.45	23304744.0
2016-03-04 10:00:00	AAPL	Stock	25.45	25.6675	25.3475	25.6475	24278232.0
2016-03-04 11:00:00	AAPL	Stock	25.645	25.7725	25.6275	25.741	26455508.0
2016-03-04 12:00:00	AAPL	Stock	25.74	25.8625	25.68	25.8475	19101828.0
2016-03-04 13:00:00	AAPL	Stock	25.8475	25.9375	25.7775	25.8825	18218936.0
2016-03-04 14:00:00	AAPL	Stock	25.8838	25.8975	25.6175	25.6858	22385992.0
2016-03-04 15:00:00	AAPL	Stock	25.685	25.795	25.645	25.7525	28261820.0
2016-03-04 16:00:00	AAPL	Stock	25.7525	25.7525	25.457	25.7425	7291176.0
2016-03-04 17:00:00	AAPL	Stock	25.7425	25.75	25.725	25.7275	66216.0
2016-03-04 18:00:00	AAPL	Stock	25.74	25.745	25.7275	25.73	16428.0
2016-03-04 19:00:00	AAPL	Stock	25.7475	25.7475	25.735	25.7475	26984.0
2016-03-04 05:00:00	MSFT	Stock	52.0	52.3	52.0	52.3	400.0
2016-03-04 07:00:00	MSFT	Stock	52.4	52.4	52.4	52.4	1000.0
2016-03-04 08:00:00	MSFT	Stock	52.32	52.65	52.32	52.4	28547.0
2016-03-04 09:00:00	MSFT	Stock	52.31	52.45	51.71	51.935	3967285.0
2016-03-04 10:00:00	MSFT	Stock	51.94	52.14	51.75	51.99	4298983.0
2016-03-04 11:00:00	MSFT	Stock	51.99	52.14	51.83	51.965	4367067.0
2016-03-04 12:00:00	MSFT	Stock	51.97	52.07	51.86	52.03	2996743.0
2016-03-04 13:00:00	MSFT	Stock	52.02	52.2	51.94	52.155	3439811.0
2016-03-04 14:00:00	MSFT	Stock	52.153	52.24	51.91	51.94	2433901.0
2016-03-04 15:00:00	MSFT	Stock	51.94	52.06	51.8	52.03	5377862.0
2016-03-04 16:00:00	MSFT	Stock	52.03	52.03	51.93	51.98	3845707.0
2016-03-04 18:00:00	MSFT	Stock	51.98	51.98	51.95	51.95	450.0
2016-03-04 19:00:00	MSFT	Stock	51.95	51.95	51.95	51.95	690.0
2016-03-04 08:00:00	NVDA	Stock	0.8188	0.825	0.8188	0.8242	120000.0
2016-03-04 09:00:00	NVDA	Stock	0.8212	0.8232	0.8075	0.8132	16992760.0
2016-03-04 10:00:00	NVDA	Stock	0.8132	0.8152	0.811	0.8145	20484560.0
2016-03-04 11:00:00	NVDA	Stock	0.8145	0.8212	0.8145	0.8175	19254400.0
2016-03-04 12:00:00	NVDA	Stock	0.8175	0.8193	0.8165	0.8193	21828160.0
2016-03-04 13:00:00	NVDA	Stock	0.8193	0.8195	0.8159	0.8172	17527120.0
2016-03-04 14:00:00	NVDA	Stock	0.8175	0.818	0.81	0.8113	23775040.0
2016-03-04 15:00:00	NVDA	Stock	0.8115	0.815	0.8102	0.8138	36245480.0
2016-03-04 16:00:00	NVDA	Stock	0.8135	0.8155	0.8128	0.8155	2230800.0
2016-03-04 04:00:00	AMZN	Stock	28.9	28.9	28.9	28.9	4000.0
2016-03-04 07:00:00	AMZN	Stock	28.9595	29.0495	28.9475	29.0495	44600.0
2016-03-04 08:00:00	AMZN	Stock	29.039	29.0895	28.9025	28.905	499200.0
2016-03-04 09:00:00	AMZN	Stock	28.883	29.07	28.6	28.709	9338220.0
2016-03-04 10:00:00	AMZN	Stock	28.688	28.9436	28.5533	28.8668	13511580.0
2016-03-04 11:00:00	AMZN	Stock	28.8825	29.01	28.8125	28.9195	7441560.0
2016-03-04 12:00:00	AMZN	Stock	28.9131	28.9375	28.8415	28.885	3877020.0
2016-03-04 13:00:00	AMZN	Stock	28.8865	28.9975	28.78	28.9585	5288580.0
2016-03-04 14:00:00	AMZN	Stock	28.9525	28.9666	28.7285	28.78	8459020.0
2016-03-04 15:00:00	AMZN	Stock	28.7645	28.796	28.7005	28.757	10178440.0
2016-03-04 16:00:00	AMZN	Stock	28.773	28.7855	28.728	28.7415	235560.0
2016-03-04 17:00:00	AMZN	Stock	28.74	28.74	28.74	28.74	4500.0

> showing 50 of 49,025 rows — these rows as CSV

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