PREVIEW / stock_1hour / 2018-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-17.parquet
  size:    1.1 MB
  rows:    49,869
  symbols: 2,781

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-17 04:00:00	AAPL	Stock	55.975	55.975	55.8875	55.91	16152.0
2018-09-17 05:00:00	AAPL	Stock	55.945	55.95	55.8	55.825	19188.0
2018-09-17 06:00:00	AAPL	Stock	55.825	55.825	55.575	55.675	42952.0
2018-09-17 07:00:00	AAPL	Stock	55.695	55.72	55.3275	55.4675	384752.0
2018-09-17 08:00:00	AAPL	Stock	55.675	55.7125	55.3875	55.485	443796.0
2018-09-17 09:00:00	AAPL	Stock	55.475	55.7375	54.9328	55.3	19220636.0
2018-09-17 10:00:00	AAPL	Stock	55.3	55.36	54.81	54.9425	19806692.0
2018-09-17 11:00:00	AAPL	Stock	54.9388	55.1075	54.8895	54.9875	11284896.0
2018-09-17 12:00:00	AAPL	Stock	54.989	55.1375	54.9375	54.9842	8783060.0
2018-09-17 13:00:00	AAPL	Stock	54.98	55.15	54.6675	54.8758	16623864.0
2018-09-17 14:00:00	AAPL	Stock	54.8762	55.09	54.825	54.93	11388040.0
2018-09-17 15:00:00	AAPL	Stock	54.935	54.945	54.3175	54.4725	26600820.0
2018-09-17 16:00:00	AAPL	Stock	54.47	54.525	54.4325	54.47	10388296.0
2018-09-17 17:00:00	AAPL	Stock	54.4875	54.52	54.46	54.4625	90352.0
2018-09-17 18:00:00	AAPL	Stock	54.475	54.4875	54.195	54.23	193184.0
2018-09-17 19:00:00	AAPL	Stock	54.2025	54.2325	54.0	54.0625	342564.0
2018-09-17 04:00:00	MSFT	Stock	113.2	113.2	113.2	113.2	133.0
2018-09-17 06:00:00	MSFT	Stock	113.3	113.32	113.3	113.32	675.0
2018-09-17 07:00:00	MSFT	Stock	113.0	113.25	112.87	113.18	11241.0
2018-09-17 08:00:00	MSFT	Stock	113.23	113.58	113.02	113.45	18787.0
2018-09-17 09:00:00	MSFT	Stock	113.43	113.7	112.92	113.515	2366155.0
2018-09-17 10:00:00	MSFT	Stock	113.52	113.52	112.4	112.48	2857154.0
2018-09-17 11:00:00	MSFT	Stock	112.485	112.75	112.39	112.6	1762512.0
2018-09-17 12:00:00	MSFT	Stock	112.6	112.749	112.43	112.73	1400870.0
2018-09-17 13:00:00	MSFT	Stock	112.72	112.89	112.475	112.66	1209951.0
2018-09-17 14:00:00	MSFT	Stock	112.652	112.85	112.53	112.575	1217096.0
2018-09-17 15:00:00	MSFT	Stock	112.575	112.615	111.86	112.18	4036929.0
2018-09-17 16:00:00	MSFT	Stock	112.14	112.14	111.86	112.03	3151443.0
2018-09-17 17:00:00	MSFT	Stock	111.97	112.03	111.95	111.95	4109.0
2018-09-17 18:00:00	MSFT	Stock	111.95	112.02	111.48	111.48	6099.0
2018-09-17 19:00:00	MSFT	Stock	111.35	111.57	111.32	111.4	9133.0
2018-09-17 06:00:00	NVDA	Stock	6.8958	6.9278	6.8958	6.9212	165760.0
2018-09-17 07:00:00	NVDA	Stock	6.922	6.922	6.9058	6.9075	246480.0
2018-09-17 08:00:00	NVDA	Stock	6.9088	6.9298	6.891	6.896	790000.0
2018-09-17 09:00:00	NVDA	Stock	6.903	6.9345	6.8288	6.9037	34015320.0
2018-09-17 10:00:00	NVDA	Stock	6.904	6.9055	6.8482	6.8638	33874560.0
2018-09-17 11:00:00	NVDA	Stock	6.8628	6.9175	6.8585	6.9175	18808440.0
2018-09-17 12:00:00	NVDA	Stock	6.9175	6.9342	6.9	6.915	17473720.0
2018-09-17 13:00:00	NVDA	Stock	6.917	6.924	6.8815	6.9085	10675280.0
2018-09-17 14:00:00	NVDA	Stock	6.9062	6.919	6.875	6.8818	11735800.0
2018-09-17 15:00:00	NVDA	Stock	6.882	6.89	6.8325	6.8482	40846680.0
2018-09-17 16:00:00	NVDA	Stock	6.8482	6.8562	6.8465	6.853	585680.0
2018-09-17 17:00:00	NVDA	Stock	6.8515	6.8572	6.85	6.8538	548040.0
2018-09-17 18:00:00	NVDA	Stock	6.8535	6.8548	6.825	6.825	325560.0
2018-09-17 19:00:00	NVDA	Stock	6.825	6.825	6.8002	6.8028	412840.0
2018-09-17 04:00:00	AMZN	Stock	98.15	98.2	98.15	98.2	5660.0
2018-09-17 05:00:00	AMZN	Stock	98.168	98.168	98.168	98.168	2000.0
2018-09-17 06:00:00	AMZN	Stock	98.1995	98.1995	98.0455	98.1	12940.0
2018-09-17 07:00:00	AMZN	Stock	98.184	98.187	97.8	97.875	46280.0
2018-09-17 08:00:00	AMZN	Stock	98.15	98.2	97.7	97.763	175520.0

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

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