PREVIEW / stock_1hour / 2021-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-27.parquet
  size:    1.4 MB
  rows:    65,353
  symbols: 2,630

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-12-27 04:00:00	AAPL	Stock	176.4	176.41	175.88	176.0	26981.0
2021-12-27 05:00:00	AAPL	Stock	176.0	176.64	176.0	176.4	16093.0
2021-12-27 06:00:00	AAPL	Stock	176.46	176.46	176.38	176.44	2864.0
2021-12-27 07:00:00	AAPL	Stock	176.43	177.07	176.39	176.95	64432.0
2021-12-27 08:00:00	AAPL	Stock	176.47	177.31	176.365	177.07	366626.0
2021-12-27 09:00:00	AAPL	Stock	177.09	178.47	176.9	177.2889	9301992.0
2021-12-27 10:00:00	AAPL	Stock	177.3	178.47	177.13	178.4599	9712500.0
2021-12-27 11:00:00	AAPL	Stock	178.455	178.87	178.17	178.836	6990437.0
2021-12-27 12:00:00	AAPL	Stock	178.84	179.3699	178.78	179.25	7129873.0
2021-12-27 13:00:00	AAPL	Stock	179.25	179.97	179.07	179.895	6529193.0
2021-12-27 14:00:00	AAPL	Stock	179.89	180.23	179.535	179.91	7459310.0
2021-12-27 15:00:00	AAPL	Stock	179.91	180.42	179.56	180.33	10769240.0
2021-12-27 16:00:00	AAPL	Stock	180.33	180.55	180.14	180.2594	6584909.0
2021-12-27 17:00:00	AAPL	Stock	180.25	180.5	180.25	180.3	61025.0
2021-12-27 18:00:00	AAPL	Stock	180.3	180.34	180.1	180.11	46064.0
2021-12-27 19:00:00	AAPL	Stock	180.1	180.11	179.8	179.8	68465.0
2021-12-27 04:00:00	MSFT	Stock	335.55	335.63	335.13	335.2	1950.0
2021-12-27 05:00:00	MSFT	Stock	336.21	336.34	336.15	336.33	1431.0
2021-12-27 06:00:00	MSFT	Stock	336.13	336.13	335.43	335.5	1336.0
2021-12-27 07:00:00	MSFT	Stock	335.51	336.44	335.41	336.3	5285.0
2021-12-27 08:00:00	MSFT	Stock	335.65	336.88	335.41	336.61	15897.0
2021-12-27 09:00:00	MSFT	Stock	336.7	339.305	335.43	339.19	2005696.0
2021-12-27 10:00:00	MSFT	Stock	339.21	340.69	339.21	340.3	1980344.0
2021-12-27 11:00:00	MSFT	Stock	340.34	340.69	339.63	339.9	1259603.0
2021-12-27 12:00:00	MSFT	Stock	339.9	340.98	339.87	340.62	1412681.0
2021-12-27 13:00:00	MSFT	Stock	340.61	341.2327	340.41	341.22	1067517.0
2021-12-27 14:00:00	MSFT	Stock	341.225	341.35	340.87	340.93	1194276.0
2021-12-27 15:00:00	MSFT	Stock	340.92	342.48	340.66	342.45	2292209.0
2021-12-27 16:00:00	MSFT	Stock	342.41	342.9	342.35	342.61	3081700.0
2021-12-27 17:00:00	MSFT	Stock	342.7	342.8	342.46	342.55	8004.0
2021-12-27 18:00:00	MSFT	Stock	342.45	342.48	341.56	342.2	8748.0
2021-12-27 19:00:00	MSFT	Stock	342.06	342.06	341.51	341.7	13055.0
2021-12-27 04:00:00	NVDA	Stock	29.7	29.7	29.55	29.629	85130.0
2021-12-27 05:00:00	NVDA	Stock	29.65	29.65	29.601	29.65	21410.0
2021-12-27 06:00:00	NVDA	Stock	29.653	29.675	29.63	29.65	36500.0
2021-12-27 07:00:00	NVDA	Stock	29.658	29.783	29.64	29.783	544230.0
2021-12-27 08:00:00	NVDA	Stock	29.7158	29.785	29.64	29.765	688080.0
2021-12-27 09:00:00	NVDA	Stock	29.765	30.502	29.634	30.49	54120060.0
2021-12-27 10:00:00	NVDA	Stock	30.495	30.984	30.432	30.758	64922050.0
2021-12-27 11:00:00	NVDA	Stock	30.757	30.859	30.625	30.8351	37080190.0
2021-12-27 12:00:00	NVDA	Stock	30.838	30.951	30.779	30.839	24023030.0
2021-12-27 13:00:00	NVDA	Stock	30.839	30.925	30.759	30.9066	20232530.0
2021-12-27 14:00:00	NVDA	Stock	30.909	31.0865	30.85	30.89	37771280.0
2021-12-27 15:00:00	NVDA	Stock	30.894	30.96	30.735	30.952	50004200.0
2021-12-27 16:00:00	NVDA	Stock	30.95	30.999	30.932	30.98	16812320.0
2021-12-27 17:00:00	NVDA	Stock	30.977	31.029	30.977	31.024	403700.0
2021-12-27 18:00:00	NVDA	Stock	31.024	31.075	31.02	31.035	446680.0
2021-12-27 19:00:00	NVDA	Stock	31.025	31.031	30.93	31.01	312680.0
2021-12-27 07:00:00	AMZN	Stock	171.4	171.5	171.4	171.5	4280.0
2021-12-27 08:00:00	AMZN	Stock	171.3402	171.775	171.3402	171.775	38540.0

> showing 50 of 65,353 rows — these rows as CSV

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