PREVIEW / stock_1hour / 2021-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-15.parquet
  size:    1.5 MB
  rows:    68,893
  symbols: 2,896

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-15 04:00:00	AAPL	Stock	121.0	121.59	120.61	121.55	26271.0
2021-03-15 05:00:00	AAPL	Stock	121.49	121.94	121.49	121.7	22273.0
2021-03-15 06:00:00	AAPL	Stock	121.72	121.77	121.25	121.5	21408.0
2021-03-15 07:00:00	AAPL	Stock	121.51	121.88	121.4	121.42	243183.0
2021-03-15 08:00:00	AAPL	Stock	121.51	121.86	121.09	121.32	463814.0
2021-03-15 09:00:00	AAPL	Stock	121.32	123.64	120.42	123.2501	13496728.0
2021-03-15 10:00:00	AAPL	Stock	123.25	123.47	122.235	123.11	13762759.0
2021-03-15 11:00:00	AAPL	Stock	123.115	123.23	122.04	122.34	7981146.0
2021-03-15 12:00:00	AAPL	Stock	122.34	122.62	122.2001	122.5299	5729939.0
2021-03-15 13:00:00	AAPL	Stock	122.53	123.16	122.441	123.1	5649722.0
2021-03-15 14:00:00	AAPL	Stock	123.1	123.64	123.0902	123.37	8345625.0
2021-03-15 15:00:00	AAPL	Stock	123.365	124.0	123.06	124.0	13108840.0
2021-03-15 16:00:00	AAPL	Stock	123.99	124.2	123.7	124.2	12197577.0
2021-03-15 17:00:00	AAPL	Stock	124.19	124.56	124.17	124.47	248290.0
2021-03-15 18:00:00	AAPL	Stock	124.45	124.49	124.11	124.23	121253.0
2021-03-15 19:00:00	AAPL	Stock	124.23	124.25	124.1	124.12	83372.0
2021-03-15 04:00:00	MSFT	Stock	234.96	235.75	234.96	235.4	566.0
2021-03-15 05:00:00	MSFT	Stock	235.84	236.47	235.84	236.47	507.0
2021-03-15 06:00:00	MSFT	Stock	236.4	236.42	235.88	236.42	1284.0
2021-03-15 07:00:00	MSFT	Stock	236.21	236.25	235.31	235.45	15390.0
2021-03-15 08:00:00	MSFT	Stock	235.4	236.0	235.1	235.76	16683.0
2021-03-15 09:00:00	MSFT	Stock	235.76	236.49	233.41	234.02	2349014.0
2021-03-15 10:00:00	MSFT	Stock	234.02	234.14	232.25	233.23	3385387.0
2021-03-15 11:00:00	MSFT	Stock	233.235	233.4016	231.81	232.79	2295067.0
2021-03-15 12:00:00	MSFT	Stock	232.77	233.12	232.495	232.86	1508311.0
2021-03-15 13:00:00	MSFT	Stock	232.875	233.16	232.55	233.0201	1242633.0
2021-03-15 14:00:00	MSFT	Stock	233.03	233.67	232.93	233.49	1469767.0
2021-03-15 15:00:00	MSFT	Stock	233.49	235.03	233.1886	234.81	3427553.0
2021-03-15 16:00:00	MSFT	Stock	234.81	235.2	234.76	234.93	4402275.0
2021-03-15 17:00:00	MSFT	Stock	234.93	234.99	234.79	234.9	22241.0
2021-03-15 18:00:00	MSFT	Stock	234.81	234.9	234.59	234.73	2128.0
2021-03-15 19:00:00	MSFT	Stock	234.7	234.7	234.5	234.5	2280.0
2021-03-15 04:00:00	NVDA	Stock	12.875	12.8795	12.875	12.8795	8000.0
2021-03-15 05:00:00	NVDA	Stock	12.95	12.95	12.95	12.95	4000.0
2021-03-15 06:00:00	NVDA	Stock	12.925	12.925	12.925	12.925	12000.0
2021-03-15 07:00:00	NVDA	Stock	12.9182	12.9925	12.9075	12.9132	269680.0
2021-03-15 08:00:00	NVDA	Stock	12.98	12.98	12.7512	12.825	721400.0
2021-03-15 09:00:00	NVDA	Stock	12.824	12.9968	12.7671	12.964	17471760.0
2021-03-15 10:00:00	NVDA	Stock	12.9532	13.1132	12.939	13.0818	25217560.0
2021-03-15 11:00:00	NVDA	Stock	13.086	13.0895	12.9339	13.0161	15589480.0
2021-03-15 12:00:00	NVDA	Stock	13.0135	13.0475	12.9625	13.01	9882560.0
2021-03-15 13:00:00	NVDA	Stock	13.0125	13.0238	12.9783	13.0075	6766600.0
2021-03-15 14:00:00	NVDA	Stock	13.0098	13.137	13.0098	13.1255	11792160.0
2021-03-15 15:00:00	NVDA	Stock	13.1252	13.2068	13.0792	13.203	27457920.0
2021-03-15 16:00:00	NVDA	Stock	13.1912	13.2062	13.19	13.2062	25134120.0
2021-03-15 17:00:00	NVDA	Stock	13.205	13.2173	13.2025	13.2162	107600.0
2021-03-15 18:00:00	NVDA	Stock	13.2235	13.2262	13.2125	13.2165	151600.0
2021-03-15 19:00:00	NVDA	Stock	13.2082	13.2225	13.1912	13.1912	157400.0
2021-03-15 07:00:00	AMZN	Stock	154.9	154.9	154.0	154.05	75920.0
2021-03-15 08:00:00	AMZN	Stock	154.05	154.05	153.7	153.8	139020.0

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

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