PREVIEW / stock_1hour / 2017-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-23.parquet
  size:    1.1 MB
  rows:    48,479
  symbols: 3,005

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
2017-06-23 06:00:00	AAPL	Stock	36.4875	36.4875	36.365	36.38	11588.0
2017-06-23 07:00:00	AAPL	Stock	36.365	36.3925	36.355	36.355	25156.0
2017-06-23 08:00:00	AAPL	Stock	36.3625	36.3875	36.325	36.38	95116.0
2017-06-23 09:00:00	AAPL	Stock	36.38	36.4775	36.265	36.4525	8537088.0
2017-06-23 10:00:00	AAPL	Stock	36.45	36.575	36.29	36.53	9682120.0
2017-06-23 11:00:00	AAPL	Stock	36.53	36.7275	36.525	36.715	8569552.0
2017-06-23 12:00:00	AAPL	Stock	36.715	36.7562	36.6425	36.725	6856376.0
2017-06-23 13:00:00	AAPL	Stock	36.7225	36.79	36.66	36.7537	5747648.0
2017-06-23 14:00:00	AAPL	Stock	36.755	36.77	36.65	36.6675	6567632.0
2017-06-23 15:00:00	AAPL	Stock	36.6675	36.6838	36.55	36.5725	19337320.0
2017-06-23 16:00:00	AAPL	Stock	36.5925	36.6225	36.55	36.6225	51875544.0
2017-06-23 17:00:00	AAPL	Stock	36.6075	36.6175	36.5775	36.5875	62484.0
2017-06-23 18:00:00	AAPL	Stock	36.5775	36.595	36.5775	36.595	10040.0
2017-06-23 19:00:00	AAPL	Stock	36.595	36.595	36.57	36.595	20896.0
2017-06-23 06:00:00	MSFT	Stock	70.2	70.2	70.2	70.2	106.0
2017-06-23 07:00:00	MSFT	Stock	70.2	70.2	70.2	70.2	4100.0
2017-06-23 08:00:00	MSFT	Stock	70.26	70.28	70.2	70.2	812.0
2017-06-23 09:00:00	MSFT	Stock	70.35	70.35	69.92	70.22	1787056.0
2017-06-23 10:00:00	MSFT	Stock	70.225	70.58	70.09	70.46	2158843.0
2017-06-23 11:00:00	MSFT	Stock	70.46	70.6	70.43	70.51	1112563.0
2017-06-23 12:00:00	MSFT	Stock	70.51	70.856	70.475	70.76	2101635.0
2017-06-23 13:00:00	MSFT	Stock	70.77	70.99	70.75	70.975	1489056.0
2017-06-23 14:00:00	MSFT	Stock	70.975	71.06	70.94	70.95	2539663.0
2017-06-23 15:00:00	MSFT	Stock	70.95	71.25	70.78	71.23	6913370.0
2017-06-23 16:00:00	MSFT	Stock	71.23	71.23	70.99	71.1	6187723.0
2017-06-23 17:00:00	MSFT	Stock	71.08	71.21	71.02	71.21	546318.0
2017-06-23 18:00:00	MSFT	Stock	71.11	71.11	71.11	71.11	300.0
2017-06-23 19:00:00	MSFT	Stock	71.11	71.11	71.11	71.11	200.0
2017-06-23 04:00:00	NVDA	Stock	3.9695	3.9868	3.9695	3.9868	8480.0
2017-06-23 05:00:00	NVDA	Stock	3.975	3.975	3.975	3.975	48000.0
2017-06-23 06:00:00	NVDA	Stock	3.9638	3.9762	3.945	3.9625	188040.0
2017-06-23 07:00:00	NVDA	Stock	3.9553	3.9585	3.9465	3.95	131720.0
2017-06-23 08:00:00	NVDA	Stock	3.9482	3.9772	3.9482	3.9748	1422120.0
2017-06-23 09:00:00	NVDA	Stock	3.9728	3.983	3.9168	3.926	98363960.0
2017-06-23 10:00:00	NVDA	Stock	3.9275	3.9435	3.9162	3.9348	116504760.0
2017-06-23 11:00:00	NVDA	Stock	3.935	3.9375	3.8822	3.9108	124274520.0
2017-06-23 12:00:00	NVDA	Stock	3.9105	3.9298	3.8898	3.9135	72025160.0
2017-06-23 13:00:00	NVDA	Stock	3.9135	3.915	3.8975	3.9059	47438480.0
2017-06-23 14:00:00	NVDA	Stock	3.9062	3.9062	3.8305	3.8632	164923880.0
2017-06-23 15:00:00	NVDA	Stock	3.8636	3.877	3.8443	3.846	176696760.0
2017-06-23 16:00:00	NVDA	Stock	3.8455	3.8548	3.8415	3.845	93934440.0
2017-06-23 17:00:00	NVDA	Stock	3.845	3.8488	3.8438	3.8488	884080.0
2017-06-23 18:00:00	NVDA	Stock	3.847	3.853	3.8458	3.85	483040.0
2017-06-23 19:00:00	NVDA	Stock	3.8475	3.8612	3.8475	3.8575	381720.0
2017-06-23 04:00:00	AMZN	Stock	50.25	50.25	50.25	50.25	9840.0
2017-06-23 06:00:00	AMZN	Stock	50.125	50.125	50.125	50.125	2000.0
2017-06-23 08:00:00	AMZN	Stock	50.048	50.1445	50.048	50.1445	57560.0
2017-06-23 09:00:00	AMZN	Stock	50.125	50.2115	49.901	49.9935	6493500.0
2017-06-23 10:00:00	AMZN	Stock	49.9945	50.1735	49.944	50.079	5600840.0
2017-06-23 11:00:00	AMZN	Stock	50.0762	50.1405	49.9965	50.0535	3557320.0

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

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