PREVIEW / stock_1hour / 2018-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-03.parquet
  size:    754 KB
  rows:    31,387
  symbols: 2,763

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-07-03 04:00:00	AAPL	Stock	46.8175	46.8175	46.8175	46.8175	3884.0
2018-07-03 05:00:00	AAPL	Stock	46.8225	46.925	46.8225	46.825	15024.0
2018-07-03 06:00:00	AAPL	Stock	46.925	46.975	46.9175	46.9175	15760.0
2018-07-03 07:00:00	AAPL	Stock	46.925	46.9975	46.8925	46.965	193828.0
2018-07-03 08:00:00	AAPL	Stock	46.975	46.9975	46.8875	46.9125	190392.0
2018-07-03 09:00:00	AAPL	Stock	46.9075	46.9875	46.5775	46.675	10558052.0
2018-07-03 10:00:00	AAPL	Stock	46.675	46.86	46.585	46.7425	9810808.0
2018-07-03 11:00:00	AAPL	Stock	46.7475	46.755	46.545	46.6108	5189252.0
2018-07-03 12:00:00	AAPL	Stock	46.6125	46.65	45.885	45.91	18239276.0
2018-07-03 13:00:00	AAPL	Stock	45.91	45.98	45.89	45.945	5745288.0
2018-07-03 14:00:00	AAPL	Stock	45.945	45.975	45.94	45.965	72960.0
2018-07-03 15:00:00	AAPL	Stock	45.975	46.0085	45.975	46.0	54852.0
2018-07-03 16:00:00	AAPL	Stock	46.0	46.0	45.9525	45.99	13292.0
2018-07-03 04:00:00	MSFT	Stock	100.1	100.3	100.1	100.3	2146.0
2018-07-03 05:00:00	MSFT	Stock	100.54	100.54	100.54	100.54	1100.0
2018-07-03 06:00:00	MSFT	Stock	100.6	100.7	100.6	100.7	506.0
2018-07-03 07:00:00	MSFT	Stock	100.64	101.04	100.64	100.8	14567.0
2018-07-03 08:00:00	MSFT	Stock	100.674	100.98	100.36	100.65	11789.0
2018-07-03 09:00:00	MSFT	Stock	100.68	100.69	99.47	99.96	3220435.0
2018-07-03 10:00:00	MSFT	Stock	99.96	100.16	99.62	99.7	2690267.0
2018-07-03 11:00:00	MSFT	Stock	99.7	99.91	99.58	99.685	1799147.0
2018-07-03 12:00:00	MSFT	Stock	99.69	99.72	98.94	99.07	3625778.0
2018-07-03 13:00:00	MSFT	Stock	99.07	99.09	98.78	99.05	1712814.0
2018-07-03 14:00:00	MSFT	Stock	99.0	99.0	98.88	98.88	3975.0
2018-07-03 15:00:00	MSFT	Stock	99.05	99.05	98.922	98.965	6721.0
2018-07-03 16:00:00	MSFT	Stock	98.97	98.97	98.95	98.95	1350.0
2018-07-03 04:00:00	NVDA	Stock	6.06	6.0675	6.06	6.065	45520.0
2018-07-03 06:00:00	NVDA	Stock	6.0875	6.1	6.0875	6.0915	212200.0
2018-07-03 07:00:00	NVDA	Stock	6.0858	6.0875	6.0688	6.0813	382200.0
2018-07-03 08:00:00	NVDA	Stock	6.075	6.0886	6.075	6.0775	850280.0
2018-07-03 09:00:00	NVDA	Stock	6.0822	6.097	5.9855	6.0103	47395640.0
2018-07-03 10:00:00	NVDA	Stock	6.0113	6.0438	6.0035	6.019	41438360.0
2018-07-03 11:00:00	NVDA	Stock	6.02	6.0263	5.9724	5.9892	23762360.0
2018-07-03 12:00:00	NVDA	Stock	5.9873	5.9938	5.9125	5.9218	46632400.0
2018-07-03 13:00:00	NVDA	Stock	5.921	5.9286	5.9202	5.9248	10000120.0
2018-07-03 14:00:00	NVDA	Stock	5.9145	5.925	5.9138	5.9218	328840.0
2018-07-03 15:00:00	NVDA	Stock	5.925	5.9275	5.9225	5.9275	74360.0
2018-07-03 16:00:00	NVDA	Stock	5.9263	5.9275	5.923	5.9231	100240.0
2018-07-03 04:00:00	AMZN	Stock	86.2	86.2265	86.1895	86.1895	12880.0
2018-07-03 05:00:00	AMZN	Stock	86.1	86.1	86.1	86.1	6000.0
2018-07-03 06:00:00	AMZN	Stock	86.1	86.166	86.1	86.166	13380.0
2018-07-03 07:00:00	AMZN	Stock	86.166	86.25	86.1	86.25	109400.0
2018-07-03 08:00:00	AMZN	Stock	86.1662	86.25	86.125	86.125	317760.0
2018-07-03 09:00:00	AMZN	Stock	86.1	86.25	85.292	85.5411	11616060.0
2018-07-03 10:00:00	AMZN	Stock	85.564	85.8615	85.2404	85.5502	8729620.0
2018-07-03 11:00:00	AMZN	Stock	85.5875	85.6265	85.1	85.264	5098820.0
2018-07-03 12:00:00	AMZN	Stock	85.2815	85.3	84.624	84.744	9577620.0
2018-07-03 13:00:00	AMZN	Stock	84.698	84.8255	84.698	84.79	2032160.0
2018-07-03 14:00:00	AMZN	Stock	84.773	84.773	84.698	84.7245	29780.0
2018-07-03 15:00:00	AMZN	Stock	84.7955	84.847	84.698	84.7995	18040.0

> showing 50 of 31,387 rows — these rows as CSV

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