PREVIEW / stock_1hour / 2018-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-15.parquet
  size:    1.1 MB
  rows:    50,007
  symbols: 2,767

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-10-15 04:00:00	AAPL	Stock	55.195	55.195	54.825	54.825	19416.0
2018-10-15 05:00:00	AAPL	Stock	55.0	55.05	55.0	55.0	12548.0
2018-10-15 06:00:00	AAPL	Stock	55.0625	55.1	54.92	54.9575	49272.0
2018-10-15 07:00:00	AAPL	Stock	54.9575	55.4475	54.93	55.3375	446836.0
2018-10-15 08:00:00	AAPL	Stock	54.9325	55.4475	54.9312	55.28	609992.0
2018-10-15 09:00:00	AAPL	Stock	55.3	55.4575	54.6825	54.78	15102628.0
2018-10-15 10:00:00	AAPL	Stock	54.7825	55.0075	54.43	54.794	17370508.0
2018-10-15 11:00:00	AAPL	Stock	54.795	55.0125	54.4652	54.5292	12854152.0
2018-10-15 12:00:00	AAPL	Stock	54.525	54.725	54.3175	54.6688	8794312.0
2018-10-15 13:00:00	AAPL	Stock	54.67	54.8428	54.415	54.745	8734304.0
2018-10-15 14:00:00	AAPL	Stock	54.7575	54.8775	54.3975	54.795	9722708.0
2018-10-15 15:00:00	AAPL	Stock	54.7975	54.96	54.32	54.32	17375380.0
2018-10-15 16:00:00	AAPL	Stock	54.3175	54.4475	54.2525	54.2525	11008364.0
2018-10-15 17:00:00	AAPL	Stock	54.2525	54.275	54.25	54.255	99044.0
2018-10-15 18:00:00	AAPL	Stock	54.27	54.34	54.205	54.2525	130284.0
2018-10-15 19:00:00	AAPL	Stock	54.2275	54.4875	54.205	54.475	169768.0
2018-10-15 04:00:00	MSFT	Stock	108.5	108.56	108.2	108.2	5533.0
2018-10-15 05:00:00	MSFT	Stock	108.5	108.69	108.5	108.66	702.0
2018-10-15 06:00:00	MSFT	Stock	108.7	109.02	108.7	108.97	6192.0
2018-10-15 07:00:00	MSFT	Stock	108.95	109.5	108.9	109.33	37660.0
2018-10-15 08:00:00	MSFT	Stock	108.935	109.43	108.85	109.18	84215.0
2018-10-15 09:00:00	MSFT	Stock	109.21	109.28	107.71	108.25	3593958.0
2018-10-15 10:00:00	MSFT	Stock	108.25	108.29	106.947	108.19	5150842.0
2018-10-15 11:00:00	MSFT	Stock	108.19	109.48	108.13	108.31	3971363.0
2018-10-15 12:00:00	MSFT	Stock	108.31	108.91	107.965	108.76	2399405.0
2018-10-15 13:00:00	MSFT	Stock	108.77	109.17	108.32	108.84	1764748.0
2018-10-15 14:00:00	MSFT	Stock	108.85	109.035	108.08	108.8	2201091.0
2018-10-15 15:00:00	MSFT	Stock	108.8	109.15	107.54	107.54	4846977.0
2018-10-15 16:00:00	MSFT	Stock	107.6	108.0	107.35	107.52	4260486.0
2018-10-15 17:00:00	MSFT	Stock	107.6	107.65	107.5	107.53	6441.0
2018-10-15 18:00:00	MSFT	Stock	107.58	107.74	107.5	107.74	4172.0
2018-10-15 19:00:00	MSFT	Stock	107.74	108.16	107.71	108.1	7092.0
2018-10-15 04:00:00	NVDA	Stock	6.1675	6.1675	6.1675	6.1675	12000.0
2018-10-15 06:00:00	NVDA	Stock	6.1125	6.12	6.11	6.12	61680.0
2018-10-15 07:00:00	NVDA	Stock	6.1175	6.1565	6.1125	6.15	754000.0
2018-10-15 08:00:00	NVDA	Stock	6.1125	6.156	6.111	6.1393	2235320.0
2018-10-15 09:00:00	NVDA	Stock	6.1498	6.151	6.016	6.0303	58313200.0
2018-10-15 10:00:00	NVDA	Stock	6.0298	6.0333	5.931	5.9808	82623440.0
2018-10-15 11:00:00	NVDA	Stock	5.9803	6.0538	5.9665	5.9737	45210240.0
2018-10-15 12:00:00	NVDA	Stock	5.972	6.0235	5.94	5.9928	33200320.0
2018-10-15 13:00:00	NVDA	Stock	5.995	6.0108	5.953	5.966	38012480.0
2018-10-15 14:00:00	NVDA	Stock	5.966	5.976	5.919	5.9628	48489640.0
2018-10-15 15:00:00	NVDA	Stock	5.9633	5.9665	5.8835	5.8845	78904120.0
2018-10-15 16:00:00	NVDA	Stock	5.8865	5.8875	5.875	5.8808	22960520.0
2018-10-15 17:00:00	NVDA	Stock	5.8813	5.8873	5.875	5.875	446200.0
2018-10-15 18:00:00	NVDA	Stock	5.88	5.8975	5.875	5.8925	343840.0
2018-10-15 19:00:00	NVDA	Stock	5.9	5.9438	5.893	5.9438	417000.0
2018-10-15 04:00:00	AMZN	Stock	88.8245	88.8245	88.5	88.6	37620.0
2018-10-15 05:00:00	AMZN	Stock	88.6685	88.904	88.6685	88.904	9020.0
2018-10-15 06:00:00	AMZN	Stock	89.005	89.05	88.91	88.96	91640.0

> showing 50 of 50,007 rows — these rows as CSV

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