PREVIEW / stock_1hour / 2021-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-27.parquet
  size:    1.5 MB
  rows:    71,168
  symbols: 2,731

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-01-27 04:00:00	AAPL	Stock	144.72	145.08	144.4	145.04	45933.0
2021-01-27 05:00:00	AAPL	Stock	145.04	145.07	144.38	144.59	138718.0
2021-01-27 06:00:00	AAPL	Stock	144.58	144.58	143.21	143.32	134770.0
2021-01-27 07:00:00	AAPL	Stock	143.37	144.52	142.84	142.88	996804.0
2021-01-27 08:00:00	AAPL	Stock	142.88	144.5	142.6	143.39	1292215.0
2021-01-27 09:00:00	AAPL	Stock	143.35	143.82	141.43	142.78	13355176.0
2021-01-27 10:00:00	AAPL	Stock	142.78	144.3	142.77	143.33	14989781.0
2021-01-27 11:00:00	AAPL	Stock	143.33	143.37	141.84	141.927	11037864.0
2021-01-27 12:00:00	AAPL	Stock	141.92	143.54	141.775	143.33	9789831.0
2021-01-27 13:00:00	AAPL	Stock	143.33	143.65	142.92	143.395	8790099.0
2021-01-27 14:00:00	AAPL	Stock	143.4	143.99	141.26	141.76	16160123.0
2021-01-27 15:00:00	AAPL	Stock	141.766	142.89	140.41	142.53	21568026.0
2021-01-27 16:00:00	AAPL	Stock	142.42	145.0	137.0	141.71	18550650.0
2021-01-27 17:00:00	AAPL	Stock	141.71	143.15	137.0	138.0	3314544.0
2021-01-27 18:00:00	AAPL	Stock	138.0	138.85	137.03	137.3	1033784.0
2021-01-27 19:00:00	AAPL	Stock	137.32	142.06	136.75	137.43	678369.0
2021-01-27 04:00:00	MSFT	Stock	240.0	240.65	238.88	240.25	60665.0
2021-01-27 05:00:00	MSFT	Stock	240.25	240.9	239.2	239.6	39662.0
2021-01-27 06:00:00	MSFT	Stock	239.39	239.69	236.4	237.98	114326.0
2021-01-27 07:00:00	MSFT	Stock	237.98	238.14	234.9	236.29	586091.0
2021-01-27 08:00:00	MSFT	Stock	236.28	241.68	235.55	237.85	865122.0
2021-01-27 09:00:00	MSFT	Stock	237.82	239.24	230.74	235.78	10590332.0
2021-01-27 10:00:00	MSFT	Stock	235.74	240.44	235.31	238.648	10657932.0
2021-01-27 11:00:00	MSFT	Stock	238.642	239.48	234.622	234.93	6094341.0
2021-01-27 12:00:00	MSFT	Stock	234.92	237.89	234.3	237.55	3577013.0
2021-01-27 13:00:00	MSFT	Stock	237.56	237.65	233.89	234.089	3033228.0
2021-01-27 14:00:00	MSFT	Stock	234.08	235.65	231.02	231.29	5904675.0
2021-01-27 15:00:00	MSFT	Stock	231.32	233.68	230.14	233.09	8019299.0
2021-01-27 16:00:00	MSFT	Stock	232.9	234.0	230.0	233.13	4630312.0
2021-01-27 17:00:00	MSFT	Stock	233.0	233.9	232.0	232.5	144159.0
2021-01-27 18:00:00	MSFT	Stock	232.48	233.0	231.25	231.8	52490.0
2021-01-27 19:00:00	MSFT	Stock	231.79	232.86	231.65	232.5	55027.0
2021-01-27 04:00:00	NVDA	Stock	13.55	13.6138	13.5102	13.5102	61480.0
2021-01-27 05:00:00	NVDA	Stock	13.425	13.425	13.425	13.425	5280.0
2021-01-27 06:00:00	NVDA	Stock	13.3635	13.3635	13.2875	13.2878	26200.0
2021-01-27 07:00:00	NVDA	Stock	13.3135	13.3363	13.2058	13.2058	992160.0
2021-01-27 08:00:00	NVDA	Stock	13.3	13.3375	13.1895	13.225	1372080.0
2021-01-27 09:00:00	NVDA	Stock	13.2205	13.2375	12.858	13.0558	65388880.0
2021-01-27 10:00:00	NVDA	Stock	13.0598	13.2188	13.0428	13.123	36752640.0
2021-01-27 11:00:00	NVDA	Stock	13.1278	13.1292	12.9375	12.9422	27804280.0
2021-01-27 12:00:00	NVDA	Stock	12.9433	13.125	12.9165	13.097	21759120.0
2021-01-27 13:00:00	NVDA	Stock	13.0906	13.0968	12.9965	13.0125	12437800.0
2021-01-27 14:00:00	NVDA	Stock	13.0118	13.0838	12.8875	12.8903	33021720.0
2021-01-27 15:00:00	NVDA	Stock	12.8878	12.947	12.7938	12.9262	65454680.0
2021-01-27 16:00:00	NVDA	Stock	12.9178	12.95	12.7812	12.928	28337280.0
2021-01-27 17:00:00	NVDA	Stock	12.9387	12.9425	12.8375	12.8428	280000.0
2021-01-27 18:00:00	NVDA	Stock	12.935	12.935	12.85	12.85	435120.0
2021-01-27 19:00:00	NVDA	Stock	12.853	12.905	12.85	12.8955	502560.0
2021-01-27 04:00:00	AMZN	Stock	168.0245	168.026	168.0245	168.026	5240.0
2021-01-27 05:00:00	AMZN	Stock	167.7515	167.7515	167.5	167.5	10700.0

> showing 50 of 71,168 rows — these rows as CSV

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