PREVIEW / stock_1hour / 2021-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-08.parquet
  size:    1.4 MB
  rows:    65,462
  symbols: 2,688

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-01-08 04:00:00	AAPL	Stock	131.72	132.14	131.13	131.97	29065.0
2021-01-08 05:00:00	AAPL	Stock	131.98	132.16	131.96	132.16	57122.0
2021-01-08 06:00:00	AAPL	Stock	132.13	132.16	131.83	132.02	38155.0
2021-01-08 07:00:00	AAPL	Stock	132.03	132.849	132.0	132.24	524810.0
2021-01-08 08:00:00	AAPL	Stock	132.15	132.85	132.01	132.04	813930.0
2021-01-08 09:00:00	AAPL	Stock	132.04	132.64	130.35	131.549	16072341.0
2021-01-08 10:00:00	AAPL	Stock	131.545	131.98	130.26	131.02	14365512.0
2021-01-08 11:00:00	AAPL	Stock	131.02	132.25	130.62	132.24	11792057.0
2021-01-08 12:00:00	AAPL	Stock	132.241	132.57	131.52	131.67	10306135.0
2021-01-08 13:00:00	AAPL	Stock	131.67	131.795	130.23	131.01	10418411.0
2021-01-08 14:00:00	AAPL	Stock	131.005	131.555	130.97	131.44	7142365.0
2021-01-08 15:00:00	AAPL	Stock	131.44	132.21	131.39	131.99	11943024.0
2021-01-08 16:00:00	AAPL	Stock	132.05	132.2	131.757	132.15	8465493.0
2021-01-08 17:00:00	AAPL	Stock	132.13	132.13	131.95	131.95	99952.0
2021-01-08 18:00:00	AAPL	Stock	131.99	132.0	131.9	131.9	65723.0
2021-01-08 19:00:00	AAPL	Stock	131.93	131.93	131.72	131.75	120698.0
2021-01-08 04:00:00	MSFT	Stock	218.7	218.7	218.02	218.51	1797.0
2021-01-08 05:00:00	MSFT	Stock	218.69	218.69	217.63	218.16	4789.0
2021-01-08 06:00:00	MSFT	Stock	218.2	218.62	217.83	217.88	6844.0
2021-01-08 07:00:00	MSFT	Stock	218.08	218.33	217.4	217.6	40842.0
2021-01-08 08:00:00	MSFT	Stock	218.29	218.3	217.56	218.1	64382.0
2021-01-08 09:00:00	MSFT	Stock	218.0	220.58	217.81	218.886	2634297.0
2021-01-08 10:00:00	MSFT	Stock	218.9	219.96	217.93	218.83	2206343.0
2021-01-08 11:00:00	MSFT	Stock	218.84	219.4	217.52	218.245	1758620.0
2021-01-08 12:00:00	MSFT	Stock	218.255	218.94	217.79	218.14	1495257.0
2021-01-08 13:00:00	MSFT	Stock	218.14	218.32	217.026	217.96	1415145.0
2021-01-08 14:00:00	MSFT	Stock	217.94	219.33	217.89	219.18	1428707.0
2021-01-08 15:00:00	MSFT	Stock	219.17	220.2	219.1	219.55	3010168.0
2021-01-08 16:00:00	MSFT	Stock	219.62	220.05	219.425	220.04	4497650.0
2021-01-08 17:00:00	MSFT	Stock	219.85	220.06	219.85	219.95	8570.0
2021-01-08 18:00:00	MSFT	Stock	219.72	219.95	219.72	219.8	4560.0
2021-01-08 19:00:00	MSFT	Stock	219.8	219.8	219.62	219.63	1687.0
2021-01-08 05:00:00	NVDA	Stock	13.328	13.3498	13.328	13.3498	35480.0
2021-01-08 07:00:00	NVDA	Stock	13.367	13.4118	13.344	13.3993	1034840.0
2021-01-08 08:00:00	NVDA	Stock	13.344	13.4	13.2833	13.3375	1556400.0
2021-01-08 09:00:00	NVDA	Stock	13.3378	13.421	13.1908	13.2863	39563360.0
2021-01-08 10:00:00	NVDA	Stock	13.2923	13.3455	13.089	13.1927	51418160.0
2021-01-08 11:00:00	NVDA	Stock	13.1975	13.2235	13.13	13.1794	19011320.0
2021-01-08 12:00:00	NVDA	Stock	13.1803	13.2508	13.1608	13.2168	17648280.0
2021-01-08 13:00:00	NVDA	Stock	13.2204	13.2204	13.042	13.1085	25446240.0
2021-01-08 14:00:00	NVDA	Stock	13.11	13.208	13.1	13.1872	16257800.0
2021-01-08 15:00:00	NVDA	Stock	13.1906	13.2942	13.1742	13.279	45122760.0
2021-01-08 16:00:00	NVDA	Stock	13.2768	13.3	13.2011	13.2815	27127480.0
2021-01-08 17:00:00	NVDA	Stock	13.3	13.3	13.2918	13.3	153760.0
2021-01-08 18:00:00	NVDA	Stock	13.2925	13.2925	13.281	13.281	48840.0
2021-01-08 19:00:00	NVDA	Stock	13.2818	13.2818	13.2678	13.2795	104000.0
2021-01-08 04:00:00	AMZN	Stock	159.0	159.0	159.0	159.0	4460.0
2021-01-08 05:00:00	AMZN	Stock	159.05	159.0645	158.515	158.535	15520.0
2021-01-08 06:00:00	AMZN	Stock	158.65	158.8	158.6285	158.8	27540.0
2021-01-08 07:00:00	AMZN	Stock	158.85	159.325	158.85	159.1115	183160.0

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

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