PREVIEW / stock_1hour / 2020-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-20.parquet
  size:    1.2 MB
  rows:    55,016
  symbols: 2,395

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-04-20 04:00:00	AAPL	Stock	70.68	70.68	70.0	70.0875	22000.0
2020-04-20 05:00:00	AAPL	Stock	70.25	70.25	70.075	70.075	7128.0
2020-04-20 06:00:00	AAPL	Stock	69.8775	69.8775	69.55	69.655	21688.0
2020-04-20 07:00:00	AAPL	Stock	69.75	69.95	69.6375	69.7325	349572.0
2020-04-20 08:00:00	AAPL	Stock	69.825	69.948	69.5475	69.6	624204.0
2020-04-20 09:00:00	AAPL	Stock	69.58	70.0625	69.3902	69.5675	16639404.0
2020-04-20 10:00:00	AAPL	Stock	69.5725	70.42	69.48	70.2225	16265308.0
2020-04-20 11:00:00	AAPL	Stock	70.2175	70.385	69.95	70.068	10380548.0
2020-04-20 12:00:00	AAPL	Stock	70.0675	70.175	69.842	69.89	9411088.0
2020-04-20 13:00:00	AAPL	Stock	69.89	70.05	69.615	70.015	9441552.0
2020-04-20 14:00:00	AAPL	Stock	70.0075	70.075	69.4375	69.48	10970400.0
2020-04-20 15:00:00	AAPL	Stock	69.4875	69.7425	69.2125	69.2125	19772996.0
2020-04-20 16:00:00	AAPL	Stock	69.215	69.28	69.0	69.1	9915968.0
2020-04-20 17:00:00	AAPL	Stock	69.1	69.2325	69.05	69.1125	134404.0
2020-04-20 18:00:00	AAPL	Stock	69.1	69.465	69.1	69.4375	103388.0
2020-04-20 19:00:00	AAPL	Stock	69.4125	69.4725	69.2625	69.275	66048.0
2020-04-20 04:00:00	MSFT	Stock	178.1	178.1	177.0	177.3	4845.0
2020-04-20 05:00:00	MSFT	Stock	177.5	177.8	177.24	177.27	6277.0
2020-04-20 06:00:00	MSFT	Stock	177.01	177.01	175.51	176.27	6166.0
2020-04-20 07:00:00	MSFT	Stock	176.49	176.99	175.77	176.0	59164.0
2020-04-20 08:00:00	MSFT	Stock	176.35	176.87	175.75	176.2	127125.0
2020-04-20 09:00:00	MSFT	Stock	176.29	177.79	176.05	176.68	4814504.0
2020-04-20 10:00:00	MSFT	Stock	176.65	178.29	176.52	177.76	4602967.0
2020-04-20 11:00:00	MSFT	Stock	177.75	178.75	177.613	178.395	3091320.0
2020-04-20 12:00:00	MSFT	Stock	178.39	178.45	177.765	177.91	2197366.0
2020-04-20 13:00:00	MSFT	Stock	177.91	177.94	177.22	177.8	2572078.0
2020-04-20 14:00:00	MSFT	Stock	177.795	178.01	176.01	176.07	3507363.0
2020-04-20 15:00:00	MSFT	Stock	176.07	176.66	174.99	174.99	6800711.0
2020-04-20 16:00:00	MSFT	Stock	175.05	175.33	174.16	175.1	3657557.0
2020-04-20 17:00:00	MSFT	Stock	175.06	175.06	174.63	174.94	51563.0
2020-04-20 18:00:00	MSFT	Stock	174.86	175.65	174.85	175.5	27422.0
2020-04-20 19:00:00	MSFT	Stock	175.61	175.95	175.42	175.55	44131.0
2020-04-20 04:00:00	NVDA	Stock	7.325	7.325	7.2538	7.2538	96400.0
2020-04-20 05:00:00	NVDA	Stock	7.2872	7.2872	7.2525	7.2525	15920.0
2020-04-20 06:00:00	NVDA	Stock	7.2438	7.2438	7.215	7.225	72240.0
2020-04-20 07:00:00	NVDA	Stock	7.2248	7.2248	7.155	7.1972	707400.0
2020-04-20 08:00:00	NVDA	Stock	7.19	7.2445	7.175	7.23	965040.0
2020-04-20 09:00:00	NVDA	Stock	7.2268	7.2438	7.1318	7.1698	89581840.0
2020-04-20 10:00:00	NVDA	Stock	7.1675	7.325	7.15	7.3095	79558440.0
2020-04-20 11:00:00	NVDA	Stock	7.307	7.3375	7.2491	7.2922	44323040.0
2020-04-20 12:00:00	NVDA	Stock	7.2935	7.3366	7.2698	7.3175	35153080.0
2020-04-20 13:00:00	NVDA	Stock	7.3162	7.3183	7.263	7.2972	22482760.0
2020-04-20 14:00:00	NVDA	Stock	7.2975	7.3135	7.2062	7.2115	35167080.0
2020-04-20 15:00:00	NVDA	Stock	7.2112	7.224	7.16	7.1688	63823400.0
2020-04-20 16:00:00	NVDA	Stock	7.1762	7.1762	7.1513	7.1625	12131600.0
2020-04-20 17:00:00	NVDA	Stock	7.1762	7.1775	7.1675	7.1725	281880.0
2020-04-20 18:00:00	NVDA	Stock	7.1688	7.2112	7.1688	7.205	344240.0
2020-04-20 19:00:00	NVDA	Stock	7.2108	7.2112	7.189	7.2025	443520.0
2020-04-20 04:00:00	AMZN	Stock	119.1	119.2945	118.9605	119.2945	10000.0
2020-04-20 05:00:00	AMZN	Stock	119.158	119.288	119.158	119.25	16600.0

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

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