PREVIEW / stock_1hour / 2020-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-10.parquet
  size:    1.4 MB
  rows:    63,125
  symbols: 2,665

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-12-10 04:00:00	AAPL	Stock	121.26	122.0	121.26	121.74	36771.0
2020-12-10 05:00:00	AAPL	Stock	121.84	122.0	121.73	121.8	15220.0
2020-12-10 06:00:00	AAPL	Stock	121.75	121.88	121.36	121.36	10246.0
2020-12-10 07:00:00	AAPL	Stock	121.5	121.67	120.67	120.83	233157.0
2020-12-10 08:00:00	AAPL	Stock	121.05	121.68	120.3	120.42	559003.0
2020-12-10 09:00:00	AAPL	Stock	120.4	122.48	120.01	122.445	12358507.0
2020-12-10 10:00:00	AAPL	Stock	122.44	123.57	121.995	123.5	12215734.0
2020-12-10 11:00:00	AAPL	Stock	123.49	123.87	123.12	123.3	8674646.0
2020-12-10 12:00:00	AAPL	Stock	123.29	123.58	122.71	122.79	7009254.0
2020-12-10 13:00:00	AAPL	Stock	122.793	123.58	122.745	123.49	5503180.0
2020-12-10 14:00:00	AAPL	Stock	123.49	123.62	122.76	122.84	5956331.0
2020-12-10 15:00:00	AAPL	Stock	122.84	123.6	122.71	123.22	10850614.0
2020-12-10 16:00:00	AAPL	Stock	123.24	123.45	122.96	123.25	8239814.0
2020-12-10 17:00:00	AAPL	Stock	123.25	123.32	123.13	123.3	43285.0
2020-12-10 18:00:00	AAPL	Stock	123.21	123.29	122.89	123.19	104458.0
2020-12-10 19:00:00	AAPL	Stock	123.16	123.29	123.0	123.17	81537.0
2020-12-10 04:00:00	MSFT	Stock	212.2	212.5	212.0	212.31	11102.0
2020-12-10 05:00:00	MSFT	Stock	212.65	212.9	212.65	212.9	11197.0
2020-12-10 06:00:00	MSFT	Stock	212.73	212.73	212.21	212.21	2321.0
2020-12-10 07:00:00	MSFT	Stock	212.35	212.35	210.88	211.11	45618.0
2020-12-10 08:00:00	MSFT	Stock	212.2	212.49	210.72	210.87	118409.0
2020-12-10 09:00:00	MSFT	Stock	210.73	213.08	210.36	212.55	3083537.0
2020-12-10 10:00:00	MSFT	Stock	212.55	213.04	211.95	212.6	2422701.0
2020-12-10 11:00:00	MSFT	Stock	212.62	212.66	211.08	211.2	2371534.0
2020-12-10 12:00:00	MSFT	Stock	211.19	211.5	210.73	210.93	1763468.0
2020-12-10 13:00:00	MSFT	Stock	210.94	211.75	210.86	211.23	1262041.0
2020-12-10 14:00:00	MSFT	Stock	211.29	211.35	210.37	210.49	1637152.0
2020-12-10 15:00:00	MSFT	Stock	210.5	211.575	210.37	210.515	3714610.0
2020-12-10 16:00:00	MSFT	Stock	210.52	210.7	210.48	210.53	4772774.0
2020-12-10 17:00:00	MSFT	Stock	210.58	210.62	210.52	210.62	15725.0
2020-12-10 18:00:00	MSFT	Stock	210.62	210.7	210.41	210.7	19394.0
2020-12-10 19:00:00	MSFT	Stock	210.69	210.75	210.5	210.59	17591.0
2020-12-10 04:00:00	NVDA	Stock	12.9375	13.025	12.9375	13.025	49480.0
2020-12-10 06:00:00	NVDA	Stock	12.95	12.95	12.9318	12.9318	13200.0
2020-12-10 07:00:00	NVDA	Stock	12.9548	13.0	12.825	12.8375	655200.0
2020-12-10 08:00:00	NVDA	Stock	12.975	12.975	12.771	12.7812	1745200.0
2020-12-10 09:00:00	NVDA	Stock	12.775	13.0562	12.75	13.0	41130040.0
2020-12-10 10:00:00	NVDA	Stock	12.9992	13.0688	12.9555	13.0386	24915120.0
2020-12-10 11:00:00	NVDA	Stock	13.0382	13.0625	12.9156	12.9185	18232600.0
2020-12-10 12:00:00	NVDA	Stock	12.9162	12.9722	12.887	12.8931	11627200.0
2020-12-10 13:00:00	NVDA	Stock	12.8935	12.985	12.8912	12.968	16783240.0
2020-12-10 14:00:00	NVDA	Stock	12.975	12.9895	12.9301	12.9463	7695200.0
2020-12-10 15:00:00	NVDA	Stock	12.9472	13.0352	12.9305	12.968	25370720.0
2020-12-10 16:00:00	NVDA	Stock	12.972	12.9725	12.9583	12.9688	10296120.0
2020-12-10 17:00:00	NVDA	Stock	12.9528	12.9875	12.9528	12.985	176360.0
2020-12-10 18:00:00	NVDA	Stock	12.9925	12.9925	12.96	12.9778	33080.0
2020-12-10 19:00:00	NVDA	Stock	12.9825	12.9938	12.9825	12.9875	37040.0
2020-12-10 07:00:00	AMZN	Stock	155.0	155.0625	154.25	154.5075	38720.0
2020-12-10 08:00:00	AMZN	Stock	155.05	155.05	153.954	154.05	132360.0
2020-12-10 09:00:00	AMZN	Stock	154.044	156.3495	153.75	155.935	5676260.0

> showing 50 of 63,125 rows — these rows as CSV

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