PREVIEW / stock_1hour / 2021-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-31.parquet
  size:    1.4 MB
  rows:    66,434
  symbols: 2,956

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-31 04:00:00	AAPL	Stock	121.66	121.99	121.2	121.75	71229.0
2021-03-31 05:00:00	AAPL	Stock	121.74	121.87	121.45	121.76	25742.0
2021-03-31 06:00:00	AAPL	Stock	121.75	122.25	121.65	121.87	51440.0
2021-03-31 07:00:00	AAPL	Stock	121.83	122.0	121.61	121.66	330780.0
2021-03-31 08:00:00	AAPL	Stock	121.69	122.0	121.57	121.71	642263.0
2021-03-31 09:00:00	AAPL	Stock	121.73	123.05	121.15	122.969	17344476.0
2021-03-31 10:00:00	AAPL	Stock	122.96	123.25	122.53	122.8155	15384433.0
2021-03-31 11:00:00	AAPL	Stock	122.81	123.31	122.647	123.28	9918380.0
2021-03-31 12:00:00	AAPL	Stock	123.2813	123.52	123.07	123.0799	9001152.0
2021-03-31 13:00:00	AAPL	Stock	123.075	123.38	122.78	122.83	6616369.0
2021-03-31 14:00:00	AAPL	Stock	122.83	122.9199	122.43	122.78	7902228.0
2021-03-31 15:00:00	AAPL	Stock	122.78	122.88	122.0	122.17	18608268.0
2021-03-31 16:00:00	AAPL	Stock	122.17	122.8808	121.9	122.0	16246851.0
2021-03-31 17:00:00	AAPL	Stock	122.01	122.1	122.0	122.09	56967.0
2021-03-31 18:00:00	AAPL	Stock	122.08	122.25	122.07	122.24	63984.0
2021-03-31 19:00:00	AAPL	Stock	122.2499	122.45	122.14	122.45	90858.0
2021-03-31 04:00:00	MSFT	Stock	232.0	232.6	231.66	232.27	2097.0
2021-03-31 05:00:00	MSFT	Stock	232.1	232.49	231.94	232.49	3116.0
2021-03-31 06:00:00	MSFT	Stock	232.51	233.01	232.51	232.96	2479.0
2021-03-31 07:00:00	MSFT	Stock	232.87	233.02	232.71	232.98	11782.0
2021-03-31 08:00:00	MSFT	Stock	233.0094	233.05	231.271	232.86	42016.0
2021-03-31 09:00:00	MSFT	Stock	232.85	233.85	232.39	233.8	2540541.0
2021-03-31 10:00:00	MSFT	Stock	233.79	236.07	233.79	235.56	3046679.0
2021-03-31 11:00:00	MSFT	Stock	235.54	236.265	235.06	236.245	1811811.0
2021-03-31 12:00:00	MSFT	Stock	236.245	236.85	236.21	236.24	1683668.0
2021-03-31 13:00:00	MSFT	Stock	236.24	236.56	235.62	235.64	1275785.0
2021-03-31 14:00:00	MSFT	Stock	235.65	235.675	234.11	234.5	1875221.0
2021-03-31 15:00:00	MSFT	Stock	234.49	239.1	234.47	235.77	13974842.0
2021-03-31 16:00:00	MSFT	Stock	235.84	237.6798	235.77	237.26	7777313.0
2021-03-31 17:00:00	MSFT	Stock	237.41	238.0	237.0	237.5	68632.0
2021-03-31 18:00:00	MSFT	Stock	237.67	237.75	237.5	237.5	20762.0
2021-03-31 19:00:00	MSFT	Stock	237.5	237.54	237.03	237.53	30009.0
2021-03-31 05:00:00	NVDA	Stock	12.8625	12.8625	12.8625	12.8625	6760.0
2021-03-31 07:00:00	NVDA	Stock	12.9218	12.96	12.9218	12.955	197160.0
2021-03-31 08:00:00	NVDA	Stock	12.9875	12.9883	12.9218	12.9883	116120.0
2021-03-31 09:00:00	NVDA	Stock	12.975	13.2606	12.9648	13.259	25665360.0
2021-03-31 10:00:00	NVDA	Stock	13.262	13.3085	13.2046	13.2765	30781680.0
2021-03-31 11:00:00	NVDA	Stock	13.2768	13.3168	13.2588	13.3082	13748480.0
2021-03-31 12:00:00	NVDA	Stock	13.3108	13.4205	13.3048	13.3775	23869400.0
2021-03-31 13:00:00	NVDA	Stock	13.3795	13.4705	13.3738	13.4362	17886840.0
2021-03-31 14:00:00	NVDA	Stock	13.4332	13.4482	13.3788	13.4415	15246480.0
2021-03-31 15:00:00	NVDA	Stock	13.4389	13.4673	13.318	13.3482	34798720.0
2021-03-31 16:00:00	NVDA	Stock	13.3482	13.4346	13.3482	13.3502	35547760.0
2021-03-31 17:00:00	NVDA	Stock	13.3502	13.3502	13.3363	13.3378	108200.0
2021-03-31 18:00:00	NVDA	Stock	13.3472	13.355	13.3472	13.355	78520.0
2021-03-31 19:00:00	NVDA	Stock	13.356	13.375	13.356	13.3725	147840.0
2021-03-31 07:00:00	AMZN	Stock	153.2	153.2	153.05	153.125	42660.0
2021-03-31 08:00:00	AMZN	Stock	153.1744	153.75	153.1744	153.45	68640.0
2021-03-31 09:00:00	AMZN	Stock	153.5	154.0894	153.125	154.0428	2926980.0
2021-03-31 10:00:00	AMZN	Stock	154.0515	155.65	154.0445	155.25	4927900.0

> showing 50 of 66,434 rows — these rows as CSV

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