PREVIEW / stock_1hour / 2020-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-29.parquet
  size:    1.2 MB
  rows:    56,757
  symbols: 2,489

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-09-29 04:00:00	AAPL	Stock	115.0	115.0	114.2	114.61	35119.0
2020-09-29 05:00:00	AAPL	Stock	114.6	114.89	114.22	114.8	27584.0
2020-09-29 06:00:00	AAPL	Stock	114.77	115.11	114.62	114.9	34873.0
2020-09-29 07:00:00	AAPL	Stock	114.92	115.2	114.48	114.48	409346.0
2020-09-29 08:00:00	AAPL	Stock	115.12	115.2	114.42	114.94	685774.0
2020-09-29 09:00:00	AAPL	Stock	114.91	115.31	113.76	113.935	15083286.0
2020-09-29 10:00:00	AAPL	Stock	113.93	114.8	113.57	113.95	17724263.0
2020-09-29 11:00:00	AAPL	Stock	113.95	114.48	113.78	113.95	11369318.0
2020-09-29 12:00:00	AAPL	Stock	113.95	114.27	113.79	114.245	8482917.0
2020-09-29 13:00:00	AAPL	Stock	114.25	114.53	113.68	114.32	8984824.0
2020-09-29 14:00:00	AAPL	Stock	114.322	114.67	114.2	114.395	8784602.0
2020-09-29 15:00:00	AAPL	Stock	114.39	114.695	113.85	114.11	13392414.0
2020-09-29 16:00:00	AAPL	Stock	114.17	114.39	114.05	114.08	5647416.0
2020-09-29 17:00:00	AAPL	Stock	114.08	114.08	113.85	114.02	126527.0
2020-09-29 18:00:00	AAPL	Stock	114.08	114.29	114.0	114.16	112891.0
2020-09-29 19:00:00	AAPL	Stock	114.18	114.35	114.09	114.3	567305.0
2020-09-29 04:00:00	MSFT	Stock	209.61	210.22	209.1	210.19	3068.0
2020-09-29 05:00:00	MSFT	Stock	210.21	210.49	209.6	210.28	4060.0
2020-09-29 06:00:00	MSFT	Stock	210.18	210.75	210.18	210.49	3252.0
2020-09-29 07:00:00	MSFT	Stock	210.33	210.63	209.51	209.61	28148.0
2020-09-29 08:00:00	MSFT	Stock	210.366	210.582	209.15	209.88	47580.0
2020-09-29 09:00:00	MSFT	Stock	209.95	210.07	208.1	209.33	2718923.0
2020-09-29 10:00:00	MSFT	Stock	209.37	209.55	208.24	208.69	2474470.0
2020-09-29 11:00:00	MSFT	Stock	208.72	209.32	207.64	208.05	2436028.0
2020-09-29 12:00:00	MSFT	Stock	208.07	208.475	207.73	208.07	1706958.0
2020-09-29 13:00:00	MSFT	Stock	208.07	208.29	206.81	207.835	2134503.0
2020-09-29 14:00:00	MSFT	Stock	207.85	208.24	207.24	207.678	1618383.0
2020-09-29 15:00:00	MSFT	Stock	207.68	207.865	207.01	207.16	3239113.0
2020-09-29 16:00:00	MSFT	Stock	207.34	207.84	207.19	207.51	3340991.0
2020-09-29 17:00:00	MSFT	Stock	207.6	207.65	207.51	207.54	7219.0
2020-09-29 18:00:00	MSFT	Stock	207.77	207.82	207.53	207.57	18703.0
2020-09-29 19:00:00	MSFT	Stock	207.55	207.79	207.26	207.63	219209.0
2020-09-29 04:00:00	NVDA	Stock	12.96	12.9975	12.96	12.9975	19040.0
2020-09-29 05:00:00	NVDA	Stock	13.0	13.0	13.0	13.0	12120.0
2020-09-29 06:00:00	NVDA	Stock	13.029	13.029	13.025	13.025	9920.0
2020-09-29 07:00:00	NVDA	Stock	13.0235	13.035	12.9375	12.94	812680.0
2020-09-29 08:00:00	NVDA	Stock	13.0134	13.0675	12.925	13.0	1308480.0
2020-09-29 09:00:00	NVDA	Stock	12.9878	13.1232	12.9333	13.0336	59054480.0
2020-09-29 10:00:00	NVDA	Stock	13.0338	13.1735	13.0003	13.0849	95552760.0
2020-09-29 11:00:00	NVDA	Stock	13.0868	13.1905	13.0662	13.1564	56704880.0
2020-09-29 12:00:00	NVDA	Stock	13.1598	13.297	13.1258	13.2928	68342480.0
2020-09-29 13:00:00	NVDA	Stock	13.292	13.3898	13.2035	13.3282	86768360.0
2020-09-29 14:00:00	NVDA	Stock	13.331	13.4428	13.3125	13.3633	68740680.0
2020-09-29 15:00:00	NVDA	Stock	13.3624	13.4075	13.2008	13.218	86611080.0
2020-09-29 16:00:00	NVDA	Stock	13.2258	13.2645	13.2038	13.2038	4293600.0
2020-09-29 17:00:00	NVDA	Stock	13.2025	13.221	13.1875	13.2188	256600.0
2020-09-29 18:00:00	NVDA	Stock	13.2188	13.25	13.207	13.25	358520.0
2020-09-29 19:00:00	NVDA	Stock	13.23	13.2625	13.2258	13.2572	1016840.0
2020-09-29 04:00:00	AMZN	Stock	158.45	158.45	158.45	158.45	4000.0
2020-09-29 06:00:00	AMZN	Stock	158.95	159.19	158.95	159.19	9380.0

> showing 50 of 56,757 rows — these rows as CSV

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