PREVIEW / stock_1hour / 2018-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-27.parquet
  size:    1.1 MB
  rows:    49,445
  symbols: 2,775

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
2018-09-27 04:00:00	AAPL	Stock	55.37	55.6125	55.37	55.6125	9160.0
2018-09-27 05:00:00	AAPL	Stock	55.625	55.6925	55.6	55.6925	37672.0
2018-09-27 06:00:00	AAPL	Stock	55.65	55.75	55.6275	55.7175	50908.0
2018-09-27 07:00:00	AAPL	Stock	55.725	55.9475	55.65	55.94	548316.0
2018-09-27 08:00:00	AAPL	Stock	55.9375	55.975	55.66	55.95	953500.0
2018-09-27 09:00:00	AAPL	Stock	55.9375	56.47	55.84	56.275	22622112.0
2018-09-27 10:00:00	AAPL	Stock	56.2798	56.485	56.225	56.335	15339680.0
2018-09-27 11:00:00	AAPL	Stock	56.3375	56.42	56.2275	56.3375	7666824.0
2018-09-27 12:00:00	AAPL	Stock	56.3325	56.46	56.275	56.4575	6293660.0
2018-09-27 13:00:00	AAPL	Stock	56.4578	56.61	56.415	56.515	8724404.0
2018-09-27 14:00:00	AAPL	Stock	56.5152	56.52	56.2325	56.2605	8903864.0
2018-09-27 15:00:00	AAPL	Stock	56.2625	56.375	56.155	56.2725	18009864.0
2018-09-27 16:00:00	AAPL	Stock	56.29	56.29	56.175	56.2175	12690900.0
2018-09-27 17:00:00	AAPL	Stock	56.2125	56.2225	56.1825	56.21	36696.0
2018-09-27 18:00:00	AAPL	Stock	56.205	56.2225	56.1775	56.1875	72320.0
2018-09-27 19:00:00	AAPL	Stock	56.2125	56.235	56.18	56.2	108208.0
2018-09-27 04:00:00	MSFT	Stock	114.04	114.04	114.04	114.04	108.0
2018-09-27 06:00:00	MSFT	Stock	114.01	114.02	114.01	114.01	923.0
2018-09-27 07:00:00	MSFT	Stock	114.08	114.22	114.05	114.12	6475.0
2018-09-27 08:00:00	MSFT	Stock	114.2	114.5	114.06	114.29	27238.0
2018-09-27 09:00:00	MSFT	Stock	114.35	114.889	114.2	114.545	1741246.0
2018-09-27 10:00:00	MSFT	Stock	114.55	114.83	114.38	114.69	2033216.0
2018-09-27 11:00:00	MSFT	Stock	114.69	114.9	114.57	114.748	1414441.0
2018-09-27 12:00:00	MSFT	Stock	114.745	114.82	114.59	114.719	914283.0
2018-09-27 13:00:00	MSFT	Stock	114.71	114.79	114.6	114.78	807114.0
2018-09-27 14:00:00	MSFT	Stock	114.775	114.91	114.6	114.62	1276278.0
2018-09-27 15:00:00	MSFT	Stock	114.615	114.71	114.3	114.44	3593496.0
2018-09-27 16:00:00	MSFT	Stock	114.46	114.636	114.3	114.41	5328606.0
2018-09-27 17:00:00	MSFT	Stock	114.4	114.41	114.32	114.41	3077.0
2018-09-27 18:00:00	MSFT	Stock	114.41	114.67	114.4	114.6	2394.0
2018-09-27 19:00:00	MSFT	Stock	114.41	114.48	114.41	114.48	1186.0
2018-09-27 04:00:00	NVDA	Stock	6.6988	6.6988	6.6988	6.6988	7200.0
2018-09-27 06:00:00	NVDA	Stock	6.6818	6.6818	6.679	6.6802	58000.0
2018-09-27 07:00:00	NVDA	Stock	6.692	6.6963	6.69	6.69	58440.0
2018-09-27 08:00:00	NVDA	Stock	6.69	6.7	6.6742	6.6842	423160.0
2018-09-27 09:00:00	NVDA	Stock	6.6775	6.73	6.676	6.6882	33233200.0
2018-09-27 10:00:00	NVDA	Stock	6.683	6.7268	6.683	6.6938	25190080.0
2018-09-27 11:00:00	NVDA	Stock	6.6975	6.7052	6.6767	6.6926	16362560.0
2018-09-27 12:00:00	NVDA	Stock	6.6922	6.6928	6.6532	6.6719	22965840.0
2018-09-27 13:00:00	NVDA	Stock	6.6712	6.6853	6.663	6.685	22330000.0
2018-09-27 14:00:00	NVDA	Stock	6.6853	6.6853	6.665	6.6774	15799920.0
2018-09-27 15:00:00	NVDA	Stock	6.6778	6.6952	6.67	6.685	30303640.0
2018-09-27 16:00:00	NVDA	Stock	6.685	6.697	6.6778	6.6915	5296800.0
2018-09-27 17:00:00	NVDA	Stock	6.692	6.6952	6.685	6.6862	80120.0
2018-09-27 19:00:00	NVDA	Stock	6.6875	6.6875	6.6825	6.6838	68560.0
2018-09-27 04:00:00	AMZN	Stock	99.02	99.1	99.02	99.1	5000.0
2018-09-27 05:00:00	AMZN	Stock	99.1055	99.25	99.1055	99.25	17720.0
2018-09-27 06:00:00	AMZN	Stock	99.35	99.35	99.35	99.35	6340.0
2018-09-27 07:00:00	AMZN	Stock	99.3395	99.625	99.3395	99.532	256520.0
2018-09-27 08:00:00	AMZN	Stock	99.4495	99.6	99.4	99.48	249040.0

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

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