PREVIEW / stock_1hour / 2020-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-20.parquet
  size:    1.2 MB
  rows:    55,853
  symbols: 2,455

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-20 04:00:00	AAPL	Stock	63.525	64.6	63.25	64.35	218140.0
2020-03-20 05:00:00	AAPL	Stock	64.35	64.625	64.2475	64.575	101344.0
2020-03-20 06:00:00	AAPL	Stock	64.5375	64.6425	63.8875	63.9525	148156.0
2020-03-20 07:00:00	AAPL	Stock	63.9475	64.0	62.5	62.995	950688.0
2020-03-20 08:00:00	AAPL	Stock	63.6725	63.6725	61.195	62.0525	1470780.0
2020-03-20 09:00:00	AAPL	Stock	62.0125	62.6825	61.54	62.095	43613224.0
2020-03-20 10:00:00	AAPL	Stock	62.09	62.9575	62.0225	62.905	31960464.0
2020-03-20 11:00:00	AAPL	Stock	62.9075	62.9425	62.0075	62.14	27803048.0
2020-03-20 12:00:00	AAPL	Stock	62.125	62.258	61.085	61.92	26146664.0
2020-03-20 13:00:00	AAPL	Stock	61.9205	62.42	61.5775	61.7775	20245432.0
2020-03-20 14:00:00	AAPL	Stock	61.7775	62.025	60.235	60.39	28726444.0
2020-03-20 15:00:00	AAPL	Stock	60.39	60.7625	57.0	57.185	82898500.0
2020-03-20 16:00:00	AAPL	Stock	57.1825	57.485	57.0475	57.3225	66724764.0
2020-03-20 17:00:00	AAPL	Stock	57.3625	57.425	57.125	57.25	412228.0
2020-03-20 18:00:00	AAPL	Stock	57.225	57.29	57.125	57.15	193948.0
2020-03-20 19:00:00	AAPL	Stock	57.15	57.2875	57.0	57.0	333064.0
2020-03-20 04:00:00	MSFT	Stock	148.19	152.63	147.05	151.8	48882.0
2020-03-20 05:00:00	MSFT	Stock	151.8	152.3	151.1	152.3	24574.0
2020-03-20 06:00:00	MSFT	Stock	152.01	153.0	150.9	151.18	19296.0
2020-03-20 07:00:00	MSFT	Stock	151.0	151.23	148.01	149.45	171098.0
2020-03-20 08:00:00	MSFT	Stock	150.89	150.89	142.71	146.9	388183.0
2020-03-20 09:00:00	MSFT	Stock	146.62	147.99	143.13	144.79	14209344.0
2020-03-20 10:00:00	MSFT	Stock	144.82	147.1	144.06	146.875	8092000.0
2020-03-20 11:00:00	MSFT	Stock	146.85	146.98	143.42	144.18	7574616.0
2020-03-20 12:00:00	MSFT	Stock	144.165	144.925	141.0	142.755	7190398.0
2020-03-20 13:00:00	MSFT	Stock	142.75	144.0	142.11	142.589	4279480.0
2020-03-20 14:00:00	MSFT	Stock	142.575	143.53	138.96	139.5	7222446.0
2020-03-20 15:00:00	MSFT	Stock	139.54	141.4	135.86	136.77	13707345.0
2020-03-20 16:00:00	MSFT	Stock	136.77	141.301	136.46	137.28	10540756.0
2020-03-20 17:00:00	MSFT	Stock	137.33	137.68	137.02	137.16	47909.0
2020-03-20 18:00:00	MSFT	Stock	137.2	137.2	137.01	137.02	34215.0
2020-03-20 19:00:00	MSFT	Stock	137.09	137.09	136.5	136.5	22927.0
2020-03-20 04:00:00	NVDA	Stock	5.525	5.775	5.525	5.6998	146600.0
2020-03-20 05:00:00	NVDA	Stock	5.75	5.75	5.735	5.7443	114800.0
2020-03-20 06:00:00	NVDA	Stock	5.7328	5.7375	5.675	5.7	145360.0
2020-03-20 07:00:00	NVDA	Stock	5.6878	5.702	5.55	5.6188	1420440.0
2020-03-20 08:00:00	NVDA	Stock	5.6888	5.6975	5.3242	5.5	3763720.0
2020-03-20 09:00:00	NVDA	Stock	5.5058	5.6942	5.47	5.5856	114585680.0
2020-03-20 10:00:00	NVDA	Stock	5.5828	5.758	5.5805	5.7	124032400.0
2020-03-20 11:00:00	NVDA	Stock	5.6962	5.7042	5.4878	5.5375	89862400.0
2020-03-20 12:00:00	NVDA	Stock	5.5405	5.5558	5.3131	5.4131	90176040.0
2020-03-20 13:00:00	NVDA	Stock	5.4088	5.4882	5.3953	5.459	42929520.0
2020-03-20 14:00:00	NVDA	Stock	5.4565	5.4925	5.168	5.1942	82268200.0
2020-03-20 15:00:00	NVDA	Stock	5.1932	5.3081	5.1283	5.1428	120120880.0
2020-03-20 16:00:00	NVDA	Stock	5.1438	5.175	5.1128	5.125	51161680.0
2020-03-20 17:00:00	NVDA	Stock	5.1175	5.125	5.115	5.115	269200.0
2020-03-20 18:00:00	NVDA	Stock	5.102	5.115	5.0938	5.1	327640.0
2020-03-20 19:00:00	NVDA	Stock	5.1	5.1125	5.08	5.08	375440.0
2020-03-20 04:00:00	AMZN	Stock	98.25	99.5	98.25	99.3	52220.0
2020-03-20 05:00:00	AMZN	Stock	99.7	99.8	99.3005	99.8	73320.0

> showing 50 of 55,853 rows — these rows as CSV

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