PREVIEW / stock_1hour / 2020-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-09.parquet
  size:    1.2 MB
  rows:    57,748
  symbols: 2,441

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
2020-03-09 04:00:00	AAPL	Stock	67.8325	67.975	66.625	67.0	296460.0
2020-03-09 05:00:00	AAPL	Stock	67.0425	68.15	67.0425	67.9	224852.0
2020-03-09 06:00:00	AAPL	Stock	67.875	68.1225	67.58	67.7425	256624.0
2020-03-09 07:00:00	AAPL	Stock	67.6925	68.1075	67.0425	67.275	730732.0
2020-03-09 08:00:00	AAPL	Stock	67.875	68.05	66.1225	66.1225	2141984.0
2020-03-09 09:00:00	AAPL	Stock	66.075	68.775	65.325	68.1755	29302660.0
2020-03-09 10:00:00	AAPL	Stock	68.16	69.345	67.3275	67.86	41059948.0
2020-03-09 11:00:00	AAPL	Stock	67.8575	69.405	67.5075	69.0325	31377872.0
2020-03-09 12:00:00	AAPL	Stock	69.02	69.5225	68.2975	68.7125	22671896.0
2020-03-09 13:00:00	AAPL	Stock	68.709	69.0875	67.6	67.7002	19878272.0
2020-03-09 14:00:00	AAPL	Stock	67.71	67.975	66.98	67.5325	27006400.0
2020-03-09 15:00:00	AAPL	Stock	67.55	68.45	66.4675	66.5225	42869736.0
2020-03-09 16:00:00	AAPL	Stock	66.5425	67.1375	66.28	66.3725	17066808.0
2020-03-09 17:00:00	AAPL	Stock	66.3775	66.5425	65.75	66.125	428032.0
2020-03-09 18:00:00	AAPL	Stock	66.125	67.375	65.545	67.3125	506524.0
2020-03-09 19:00:00	AAPL	Stock	67.3125	68.4575	67.3125	68.425	1138736.0
2020-03-09 04:00:00	MSFT	Stock	152.07	152.07	148.6	151.0	54353.0
2020-03-09 05:00:00	MSFT	Stock	150.99	153.12	150.99	152.6	42124.0
2020-03-09 06:00:00	MSFT	Stock	152.5	152.77	151.6	152.2	46382.0
2020-03-09 07:00:00	MSFT	Stock	152.5	152.88	150.24	150.87	144367.0
2020-03-09 08:00:00	MSFT	Stock	152.58	152.88	149.7	150.9	328791.0
2020-03-09 09:00:00	MSFT	Stock	150.38	156.93	150.0	155.11	8111473.0
2020-03-09 10:00:00	MSFT	Stock	155.14	157.75	153.48	154.32	10619936.0
2020-03-09 11:00:00	MSFT	Stock	154.31	157.43	154.31	156.49	6754763.0
2020-03-09 12:00:00	MSFT	Stock	156.49	157.33	154.36	154.9	4445995.0
2020-03-09 13:00:00	MSFT	Stock	154.98	155.68	152.05	152.5	4485571.0
2020-03-09 14:00:00	MSFT	Stock	152.54	153.98	151.32	153.055	5987806.0
2020-03-09 15:00:00	MSFT	Stock	153.08	154.94	150.5	150.62	12557179.0
2020-03-09 16:00:00	MSFT	Stock	150.59	154.456	150.01	150.12	7244844.0
2020-03-09 17:00:00	MSFT	Stock	150.15	150.62	150.0	150.25	77585.0
2020-03-09 18:00:00	MSFT	Stock	150.25	152.8	149.24	152.8	93515.0
2020-03-09 19:00:00	MSFT	Stock	152.75	156.0	152.5	155.4	108348.0
2020-03-09 04:00:00	NVDA	Stock	6.3185	6.3185	6.05	6.0838	765400.0
2020-03-09 05:00:00	NVDA	Stock	6.0875	6.1973	6.0875	6.1925	204280.0
2020-03-09 06:00:00	NVDA	Stock	6.1875	6.19	6.1403	6.19	103120.0
2020-03-09 07:00:00	NVDA	Stock	6.1895	6.2083	6.0712	6.0875	2672520.0
2020-03-09 08:00:00	NVDA	Stock	6.2	6.212	5.9865	6.0188	5556960.0
2020-03-09 09:00:00	NVDA	Stock	6.0188	6.318	5.8848	6.3143	76457320.0
2020-03-09 10:00:00	NVDA	Stock	6.3072	6.3185	6.1313	6.2158	90719640.0
2020-03-09 11:00:00	NVDA	Stock	6.215	6.4552	6.1625	6.428	74629120.0
2020-03-09 12:00:00	NVDA	Stock	6.4259	6.485	6.375	6.3819	54209720.0
2020-03-09 13:00:00	NVDA	Stock	6.379	6.4225	6.2323	6.2403	46766600.0
2020-03-09 14:00:00	NVDA	Stock	6.2375	6.2674	6.15	6.2156	53189240.0
2020-03-09 15:00:00	NVDA	Stock	6.2146	6.2733	6.125	6.1252	85800720.0
2020-03-09 16:00:00	NVDA	Stock	6.136	6.3036	6.0	6.0	37780160.0
2020-03-09 17:00:00	NVDA	Stock	5.9965	6.022	5.975	5.9988	1341680.0
2020-03-09 18:00:00	NVDA	Stock	5.9833	6.1713	5.9762	6.1553	2452320.0
2020-03-09 19:00:00	NVDA	Stock	6.1678	6.345	6.1625	6.3315	2886080.0
2020-03-09 04:00:00	AMZN	Stock	90.4905	90.4905	88.3085	88.827	20840.0
2020-03-09 05:00:00	AMZN	Stock	89.2625	90.4	89.2625	90.215	61040.0

> showing 50 of 57,748 rows — these rows as CSV

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