PREVIEW / stock_1hour / 2019-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-05.parquet
  size:    1.1 MB
  rows:    49,699
  symbols: 2,592

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
2019-06-05 04:00:00	AAPL	Stock	45.4975	45.5	45.42	45.5	30112.0
2019-06-05 05:00:00	AAPL	Stock	45.495	45.675	45.415	45.625	104880.0
2019-06-05 06:00:00	AAPL	Stock	45.6875	45.75	45.595	45.665	54288.0
2019-06-05 07:00:00	AAPL	Stock	45.6675	45.97	45.6375	45.9575	508172.0
2019-06-05 08:00:00	AAPL	Stock	45.725	46.0875	45.6355	45.8725	1286640.0
2019-06-05 09:00:00	AAPL	Stock	45.875	46.2475	45.695	46.0625	24491540.0
2019-06-05 10:00:00	AAPL	Stock	46.065	46.125	45.285	45.4225	21537376.0
2019-06-05 11:00:00	AAPL	Stock	45.4225	45.8775	45.3475	45.735	13766840.0
2019-06-05 12:00:00	AAPL	Stock	45.725	45.775	45.475	45.5025	7952128.0
2019-06-05 13:00:00	AAPL	Stock	45.51	45.6775	45.49	45.5725	5710596.0
2019-06-05 14:00:00	AAPL	Stock	45.57	45.6705	45.5	45.58	5489660.0
2019-06-05 15:00:00	AAPL	Stock	45.58	45.735	45.395	45.6352	13451432.0
2019-06-05 16:00:00	AAPL	Stock	45.6325	45.7228	45.6	45.665	9464508.0
2019-06-05 17:00:00	AAPL	Stock	45.6812	45.6825	45.5	45.5	37700.0
2019-06-05 18:00:00	AAPL	Stock	45.56	45.56	45.305	45.365	96912.0
2019-06-05 19:00:00	AAPL	Stock	45.4025	45.5	45.4	45.46	28356.0
2019-06-05 04:00:00	MSFT	Stock	124.35	124.35	123.99	124.08	800.0
2019-06-05 05:00:00	MSFT	Stock	123.97	124.53	123.9	124.53	5413.0
2019-06-05 06:00:00	MSFT	Stock	124.67	124.89	124.64	124.66	7752.0
2019-06-05 07:00:00	MSFT	Stock	124.69	124.73	124.42	124.58	26880.0
2019-06-05 08:00:00	MSFT	Stock	124.65	124.83	124.11	124.4	61054.0
2019-06-05 09:00:00	MSFT	Stock	124.3	125.46	124.29	125.41	3179583.0
2019-06-05 10:00:00	MSFT	Stock	125.415	125.67	124.21	124.52	3395492.0
2019-06-05 11:00:00	MSFT	Stock	124.53	125.42	124.39	125.25	2145620.0
2019-06-05 12:00:00	MSFT	Stock	125.24	125.37	124.69	124.85	1777872.0
2019-06-05 13:00:00	MSFT	Stock	124.84	125.18	124.662	125.16	2142617.0
2019-06-05 14:00:00	MSFT	Stock	125.15	125.48	125.08	125.35	1718608.0
2019-06-05 15:00:00	MSFT	Stock	125.34	125.87	125.12	125.83	3673298.0
2019-06-05 16:00:00	MSFT	Stock	125.83	125.873	125.168	125.8	3533952.0
2019-06-05 17:00:00	MSFT	Stock	125.72	125.76	125.61	125.61	4472.0
2019-06-05 18:00:00	MSFT	Stock	125.4	125.67	124.88	125.33	11765.0
2019-06-05 19:00:00	MSFT	Stock	125.17	125.42	125.03	125.03	4839.0
2019-06-05 04:00:00	NVDA	Stock	3.6272	3.6295	3.6225	3.6275	21160.0
2019-06-05 05:00:00	NVDA	Stock	3.6358	3.678	3.6358	3.6778	322120.0
2019-06-05 06:00:00	NVDA	Stock	3.6772	3.6772	3.6568	3.67	292240.0
2019-06-05 07:00:00	NVDA	Stock	3.6702	3.6788	3.6498	3.6625	2454520.0
2019-06-05 08:00:00	NVDA	Stock	3.6738	3.6792	3.635	3.6502	5262640.0
2019-06-05 09:00:00	NVDA	Stock	3.655	3.6562	3.5315	3.5685	120872800.0
2019-06-05 10:00:00	NVDA	Stock	3.5705	3.5745	3.4955	3.5088	108365760.0
2019-06-05 11:00:00	NVDA	Stock	3.5082	3.538	3.5029	3.5233	52136120.0
2019-06-05 12:00:00	NVDA	Stock	3.523	3.536	3.5088	3.5184	43494880.0
2019-06-05 13:00:00	NVDA	Stock	3.518	3.537	3.513	3.52	28978960.0
2019-06-05 14:00:00	NVDA	Stock	3.5194	3.523	3.5008	3.506	47261720.0
2019-06-05 15:00:00	NVDA	Stock	3.5055	3.5352	3.498	3.5333	70846920.0
2019-06-05 16:00:00	NVDA	Stock	3.532	3.5355	3.525	3.5355	2741480.0
2019-06-05 17:00:00	NVDA	Stock	3.533	3.5362	3.52	3.52	1692120.0
2019-06-05 18:00:00	NVDA	Stock	3.519	3.521	3.5075	3.51	470120.0
2019-06-05 19:00:00	NVDA	Stock	3.513	3.5175	3.51	3.5172	179600.0
2019-06-05 04:00:00	AMZN	Stock	87.311	87.311	87.165	87.165	6000.0
2019-06-05 05:00:00	AMZN	Stock	87.1	87.55	87.1	87.55	34880.0

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

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