PREVIEW / stock_1hour / 2021-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-09.parquet
  size:    1.5 MB
  rows:    68,412
  symbols: 2,875

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-03-09 04:00:00	AAPL	Stock	118.16	119.25	118.11	119.0	98005.0
2021-03-09 05:00:00	AAPL	Stock	119.0	119.29	118.74	119.05	60336.0
2021-03-09 06:00:00	AAPL	Stock	119.14	119.78	119.1	119.55	90542.0
2021-03-09 07:00:00	AAPL	Stock	119.48	119.62	118.54	118.58	605514.0
2021-03-09 08:00:00	AAPL	Stock	119.1299	119.24	118.5	118.9	1315203.0
2021-03-09 09:00:00	AAPL	Stock	118.9	120.48	118.63	120.28	19828096.0
2021-03-09 10:00:00	AAPL	Stock	120.28	121.5599	120.07	120.2799	21779762.0
2021-03-09 11:00:00	AAPL	Stock	120.27	120.68	120.05	120.5559	10172892.0
2021-03-09 12:00:00	AAPL	Stock	120.56	121.2399	120.465	120.875	8556732.0
2021-03-09 13:00:00	AAPL	Stock	120.88	121.95	120.88	121.63	10520922.0
2021-03-09 14:00:00	AAPL	Stock	121.635	121.73	121.065	121.5548	8244675.0
2021-03-09 15:00:00	AAPL	Stock	121.55	122.06	120.82	121.08	17173812.0
2021-03-09 16:00:00	AAPL	Stock	121.085	121.1	120.75	121.05	12701172.0
2021-03-09 17:00:00	AAPL	Stock	121.0	121.36	121.0	121.22	136094.0
2021-03-09 18:00:00	AAPL	Stock	121.23	121.3	121.05	121.25	183812.0
2021-03-09 19:00:00	AAPL	Stock	121.23	121.28	120.95	121.09	190076.0
2021-03-09 04:00:00	MSFT	Stock	230.3	232.46	230.3	232.22	13554.0
2021-03-09 05:00:00	MSFT	Stock	232.16	232.94	231.5	232.2	6439.0
2021-03-09 06:00:00	MSFT	Stock	232.04	232.9	232.04	232.88	24423.0
2021-03-09 07:00:00	MSFT	Stock	232.475	232.475	231.55	231.72	31922.0
2021-03-09 08:00:00	MSFT	Stock	232.0699	232.76	231.5	232.39	84160.0
2021-03-09 09:00:00	MSFT	Stock	232.39	234.09	231.66	233.74	3751750.0
2021-03-09 10:00:00	MSFT	Stock	233.74	234.67	233.35	233.47	3952075.0
2021-03-09 11:00:00	MSFT	Stock	233.46	233.92	232.56	232.9199	2087511.0
2021-03-09 12:00:00	MSFT	Stock	232.92	234.42	232.84	233.82	1778004.0
2021-03-09 13:00:00	MSFT	Stock	233.85	235.11	233.85	234.84	2224455.0
2021-03-09 14:00:00	MSFT	Stock	234.84	234.86	234.1	234.51	2018926.0
2021-03-09 15:00:00	MSFT	Stock	234.51	235.3839	233.36	233.68	3885964.0
2021-03-09 16:00:00	MSFT	Stock	233.68	233.88	233.25	233.54	5341601.0
2021-03-09 17:00:00	MSFT	Stock	233.57	234.05	233.32	233.8	21020.0
2021-03-09 18:00:00	MSFT	Stock	233.78	234.32	233.65	233.85	11878.0
2021-03-09 19:00:00	MSFT	Stock	233.76	233.97	233.22	233.6	14873.0
2021-03-09 04:00:00	NVDA	Stock	11.9	11.95	11.8495	11.9495	110080.0
2021-03-09 05:00:00	NVDA	Stock	11.9475	11.9575	11.9192	11.95	349160.0
2021-03-09 06:00:00	NVDA	Stock	11.9498	12.0088	11.9308	11.9748	215440.0
2021-03-09 07:00:00	NVDA	Stock	11.975	11.975	11.9	11.925	1029640.0
2021-03-09 08:00:00	NVDA	Stock	11.9525	12.0372	11.9	12.0372	1620040.0
2021-03-09 09:00:00	NVDA	Stock	12.0372	12.3298	12.0372	12.3117	63963600.0
2021-03-09 10:00:00	NVDA	Stock	12.311	12.4188	12.225	12.291	54663840.0
2021-03-09 11:00:00	NVDA	Stock	12.2942	12.4625	12.2518	12.4582	23173680.0
2021-03-09 12:00:00	NVDA	Stock	12.459	12.4973	12.3873	12.4208	20502200.0
2021-03-09 13:00:00	NVDA	Stock	12.425	12.5619	12.425	12.5472	29928440.0
2021-03-09 14:00:00	NVDA	Stock	12.5465	12.5713	12.4518	12.522	28510560.0
2021-03-09 15:00:00	NVDA	Stock	12.524	12.6168	12.45	12.519	48665320.0
2021-03-09 16:00:00	NVDA	Stock	12.5203	12.5203	12.175	12.5	42889040.0
2021-03-09 17:00:00	NVDA	Stock	12.5498	12.58	12.5425	12.545	194080.0
2021-03-09 18:00:00	NVDA	Stock	12.5622	12.5892	12.5505	12.5892	87440.0
2021-03-09 19:00:00	NVDA	Stock	12.575	12.575	12.525	12.5312	245040.0
2021-03-09 04:00:00	AMZN	Stock	150.525	150.525	150.1	150.25	19000.0
2021-03-09 05:00:00	AMZN	Stock	150.6325	150.6325	150.6325	150.6325	5260.0

> showing 50 of 68,412 rows — these rows as CSV

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