PREVIEW / stock_1hour / 2021-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-28.parquet
  size:    1.4 MB
  rows:    64,666
  symbols: 2,972

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
2021-04-28 04:00:00	AAPL	Stock	134.31	134.7	134.0	134.32	13277.0
2021-04-28 05:00:00	AAPL	Stock	134.28	134.28	133.92	134.11	19947.0
2021-04-28 06:00:00	AAPL	Stock	134.14	134.27	134.06	134.17	21840.0
2021-04-28 07:00:00	AAPL	Stock	134.17	134.7	134.14	134.4	291499.0
2021-04-28 08:00:00	AAPL	Stock	134.5199	134.7	134.21	134.37	427642.0
2021-04-28 09:00:00	AAPL	Stock	134.37	134.93	133.933	134.69	9997874.0
2021-04-28 10:00:00	AAPL	Stock	134.69	135.02	133.795	134.1116	12171580.0
2021-04-28 11:00:00	AAPL	Stock	134.115	134.225	133.08	133.23	8873243.0
2021-04-28 12:00:00	AAPL	Stock	133.234	133.808	133.09	133.64	8459080.0
2021-04-28 13:00:00	AAPL	Stock	133.645	134.03	133.51	133.9699	5780943.0
2021-04-28 14:00:00	AAPL	Stock	133.97	134.775	133.65	134.3077	11061222.0
2021-04-28 15:00:00	AAPL	Stock	134.31	134.4	133.31	133.82	15562872.0
2021-04-28 16:00:00	AAPL	Stock	133.735	139.5	133.58	137.87	16662474.0
2021-04-28 17:00:00	AAPL	Stock	137.85	138.27	135.51	136.72	4309424.0
2021-04-28 18:00:00	AAPL	Stock	136.72	137.24	136.45	136.59	962236.0
2021-04-28 19:00:00	AAPL	Stock	136.61	137.0	136.51	136.7	503748.0
2021-04-28 04:00:00	MSFT	Stock	255.18	256.58	255.18	256.3	11701.0
2021-04-28 05:00:00	MSFT	Stock	256.5	256.5	256.16	256.24	7893.0
2021-04-28 06:00:00	MSFT	Stock	256.27	256.38	255.55	255.85	9506.0
2021-04-28 07:00:00	MSFT	Stock	255.72	256.0	254.7	254.85	131020.0
2021-04-28 08:00:00	MSFT	Stock	255.47	256.7	254.55	256.0	457025.0
2021-04-28 09:00:00	MSFT	Stock	256.01	256.87	253.1	254.6699	8245554.0
2021-04-28 10:00:00	MSFT	Stock	254.66	254.9	253.54	253.68	5735109.0
2021-04-28 11:00:00	MSFT	Stock	253.6827	254.55	253.08	253.09	4218453.0
2021-04-28 12:00:00	MSFT	Stock	253.08	254.91	252.95	254.835	3821755.0
2021-04-28 13:00:00	MSFT	Stock	254.821	255.23	254.114	254.2499	2634848.0
2021-04-28 14:00:00	MSFT	Stock	254.24	255.71	254.0	255.56	3208594.0
2021-04-28 15:00:00	MSFT	Stock	255.57	256.16	245.85	254.81	5016589.0
2021-04-28 16:00:00	MSFT	Stock	254.33	254.88	254.0	254.3	2440571.0
2021-04-28 17:00:00	MSFT	Stock	254.39	254.5	254.21	254.4	31881.0
2021-04-28 18:00:00	MSFT	Stock	254.42	254.48	254.01	254.48	35400.0
2021-04-28 19:00:00	MSFT	Stock	254.42	254.5	254.25	254.42	30007.0
2021-04-28 04:00:00	NVDA	Stock	15.2888	15.32	15.2888	15.32	12000.0
2021-04-28 06:00:00	NVDA	Stock	15.325	15.325	15.325	15.325	4000.0
2021-04-28 07:00:00	NVDA	Stock	15.3215	15.3215	15.2775	15.2808	95920.0
2021-04-28 08:00:00	NVDA	Stock	15.275	15.3005	15.275	15.3	122600.0
2021-04-28 09:00:00	NVDA	Stock	15.29	15.495	15.289	15.4899	17420240.0
2021-04-28 10:00:00	NVDA	Stock	15.493	15.5322	15.2893	15.3147	23633120.0
2021-04-28 11:00:00	NVDA	Stock	15.316	15.34	15.2155	15.2998	16713400.0
2021-04-28 12:00:00	NVDA	Stock	15.2984	15.3431	15.2692	15.2878	11696760.0
2021-04-28 13:00:00	NVDA	Stock	15.2898	15.35	15.2762	15.3226	9623120.0
2021-04-28 14:00:00	NVDA	Stock	15.3318	15.3948	15.2912	15.3558	14562880.0
2021-04-28 15:00:00	NVDA	Stock	15.361	15.3812	15.255	15.283	19816440.0
2021-04-28 16:00:00	NVDA	Stock	15.2768	15.3078	15.2583	15.2875	10940120.0
2021-04-28 17:00:00	NVDA	Stock	15.2952	15.3245	15.2935	15.3245	267320.0
2021-04-28 18:00:00	NVDA	Stock	15.308	15.317	15.3075	15.3075	58560.0
2021-04-28 19:00:00	NVDA	Stock	15.3088	15.3245	15.295	15.3245	75120.0
2021-04-28 05:00:00	AMZN	Stock	170.85	170.85	170.85	170.85	9140.0
2021-04-28 06:00:00	AMZN	Stock	171.1415	171.187	171.1415	171.187	4700.0
2021-04-28 07:00:00	AMZN	Stock	171.3	171.433	171.1	171.1	44700.0

> showing 50 of 64,666 rows — these rows as CSV

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