PREVIEW / stock_1hour / 2020-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-15.parquet
  size:    1.4 MB
  rows:    63,206
  symbols: 2,687

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-15 04:00:00	AAPL	Stock	122.65	123.09	122.0	123.01	33871.0
2020-12-15 05:00:00	AAPL	Stock	123.0	123.18	122.16	123.18	43578.0
2020-12-15 06:00:00	AAPL	Stock	123.12	123.35	122.4	123.03	84303.0
2020-12-15 07:00:00	AAPL	Stock	123.01	124.2	122.87	123.91	608888.0
2020-12-15 08:00:00	AAPL	Stock	123.14	124.2	122.88	123.98	905714.0
2020-12-15 09:00:00	AAPL	Stock	123.99	126.96	123.8	126.49	29129739.0
2020-12-15 10:00:00	AAPL	Stock	126.485	126.58	125.27	125.945	18809373.0
2020-12-15 11:00:00	AAPL	Stock	125.93	126.24	125.13	125.955	12106592.0
2020-12-15 12:00:00	AAPL	Stock	125.955	126.8	125.9	126.55	16337904.0
2020-12-15 13:00:00	AAPL	Stock	126.55	126.98	126.3	126.72	11498054.0
2020-12-15 14:00:00	AAPL	Stock	126.72	127.5	126.481	127.23	15506942.0
2020-12-15 15:00:00	AAPL	Stock	127.225	127.9	127.03	127.89	18862363.0
2020-12-15 16:00:00	AAPL	Stock	127.88	128.0	127.66	127.7	12362785.0
2020-12-15 17:00:00	AAPL	Stock	127.68	127.95	127.31	127.64	249934.0
2020-12-15 18:00:00	AAPL	Stock	127.66	127.93	127.65	127.85	206456.0
2020-12-15 19:00:00	AAPL	Stock	127.86	127.97	127.57	127.57	141874.0
2020-12-15 04:00:00	MSFT	Stock	215.0	215.3	214.8	214.8	777.0
2020-12-15 05:00:00	MSFT	Stock	215.18	215.18	215.18	215.18	1000.0
2020-12-15 06:00:00	MSFT	Stock	214.33	214.49	213.52	214.16	4424.0
2020-12-15 07:00:00	MSFT	Stock	214.35	215.13	214.16	214.7	29733.0
2020-12-15 08:00:00	MSFT	Stock	214.214	215.033	213.67	214.99	27414.0
2020-12-15 09:00:00	MSFT	Stock	215.0	215.42	213.58	213.635	2231923.0
2020-12-15 10:00:00	MSFT	Stock	213.655	214.2	212.76	212.89	3192396.0
2020-12-15 11:00:00	MSFT	Stock	212.882	213.03	212.24	212.8	2254512.0
2020-12-15 12:00:00	MSFT	Stock	212.81	213.46	212.69	213.4	1763775.0
2020-12-15 13:00:00	MSFT	Stock	213.39	213.77	212.91	213.113	2300866.0
2020-12-15 14:00:00	MSFT	Stock	213.11	213.53	212.935	213.41	1686229.0
2020-12-15 15:00:00	MSFT	Stock	213.415	214.21	213.33	214.16	3253795.0
2020-12-15 16:00:00	MSFT	Stock	214.13	214.24	214.0	214.1	6100165.0
2020-12-15 17:00:00	MSFT	Stock	214.464	214.464	214.04	214.2	6049.0
2020-12-15 18:00:00	MSFT	Stock	214.19	214.3	214.03	214.09	8255.0
2020-12-15 19:00:00	MSFT	Stock	214.1	214.19	214.0	214.1	8945.0
2020-12-15 04:00:00	NVDA	Stock	13.3685	13.3782	13.3685	13.375	20960.0
2020-12-15 05:00:00	NVDA	Stock	13.3875	13.3875	13.3875	13.3875	8000.0
2020-12-15 06:00:00	NVDA	Stock	13.3875	13.42	13.3875	13.42	31360.0
2020-12-15 07:00:00	NVDA	Stock	13.39	13.4625	13.39	13.4305	473080.0
2020-12-15 08:00:00	NVDA	Stock	13.42	13.4665	13.375	13.46	1071440.0
2020-12-15 09:00:00	NVDA	Stock	13.4625	13.4725	13.3025	13.3482	27899280.0
2020-12-15 10:00:00	NVDA	Stock	13.3485	13.4105	13.3055	13.3272	24969520.0
2020-12-15 11:00:00	NVDA	Stock	13.3321	13.3321	13.1868	13.2312	20837440.0
2020-12-15 12:00:00	NVDA	Stock	13.2292	13.2875	13.228	13.247	11104800.0
2020-12-15 13:00:00	NVDA	Stock	13.2463	13.2562	13.2	13.242	11606640.0
2020-12-15 14:00:00	NVDA	Stock	13.239	13.3125	13.217	13.3112	10021600.0
2020-12-15 15:00:00	NVDA	Stock	13.3086	13.3628	13.2778	13.3622	27732200.0
2020-12-15 16:00:00	NVDA	Stock	13.3605	13.365	13.3575	13.3643	6344000.0
2020-12-15 17:00:00	NVDA	Stock	13.361	13.365	13.3512	13.3512	86600.0
2020-12-15 18:00:00	NVDA	Stock	13.3555	13.3562	13.3488	13.3488	32360.0
2020-12-15 19:00:00	NVDA	Stock	13.3485	13.3538	13.32	13.32	318600.0
2020-12-15 04:00:00	AMZN	Stock	158.75	158.75	158.75	158.75	3840.0
2020-12-15 07:00:00	AMZN	Stock	158.75	159.0065	158.75	158.95	78860.0

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

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