PREVIEW / stock_1hour / 2021-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-30.parquet
  size:    1.4 MB
  rows:    64,477
  symbols: 2,824

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-07-30 04:00:00	AAPL	Stock	144.1	144.7	144.0	144.4	34558.0
2021-07-30 05:00:00	AAPL	Stock	144.32	144.5	144.1	144.4	50151.0
2021-07-30 06:00:00	AAPL	Stock	144.45	144.9	144.4	144.8	23312.0
2021-07-30 07:00:00	AAPL	Stock	144.83	144.93	144.33	144.52	111189.0
2021-07-30 08:00:00	AAPL	Stock	144.7701	145.276	144.21	144.48	324416.0
2021-07-30 09:00:00	AAPL	Stock	144.51	145.33	144.11	145.1	10394898.0
2021-07-30 10:00:00	AAPL	Stock	145.12	145.3	144.525	144.8	8983729.0
2021-07-30 11:00:00	AAPL	Stock	144.79	145.18	144.665	145.12	5589983.0
2021-07-30 12:00:00	AAPL	Stock	145.11	145.5	144.95	145.4776	4731291.0
2021-07-30 13:00:00	AAPL	Stock	145.4793	145.905	145.35	145.748	4584932.0
2021-07-30 14:00:00	AAPL	Stock	145.745	146.32	145.66	146.21	6133558.0
2021-07-30 15:00:00	AAPL	Stock	146.21	146.33	145.775	145.86	9906718.0
2021-07-30 16:00:00	AAPL	Stock	145.86	145.95	145.75	145.88	7541096.0
2021-07-30 17:00:00	AAPL	Stock	145.9128	145.93	145.5336	145.88	31030.0
2021-07-30 18:00:00	AAPL	Stock	145.85	145.88	145.81	145.83	12769.0
2021-07-30 19:00:00	AAPL	Stock	145.83	146.0	145.81	145.95	40064.0
2021-07-30 04:00:00	MSFT	Stock	284.5	284.78	284.21	284.3	6094.0
2021-07-30 05:00:00	MSFT	Stock	284.6	284.6	284.36	284.36	5005.0
2021-07-30 06:00:00	MSFT	Stock	284.5	285.0	284.43	285.0	1882.0
2021-07-30 07:00:00	MSFT	Stock	285.0	285.44	284.76	284.76	12439.0
2021-07-30 08:00:00	MSFT	Stock	284.61	285.18	284.26	284.45	19939.0
2021-07-30 09:00:00	MSFT	Stock	284.48	286.66	284.0	284.8	2057068.0
2021-07-30 10:00:00	MSFT	Stock	284.805	285.77	284.59	285.38	1946900.0
2021-07-30 11:00:00	MSFT	Stock	285.37	285.6	284.46	284.74	1444855.0
2021-07-30 12:00:00	MSFT	Stock	284.73	285.48	284.68	285.105	1051776.0
2021-07-30 13:00:00	MSFT	Stock	285.14	285.1827	284.44	284.48	992355.0
2021-07-30 14:00:00	MSFT	Stock	284.48	284.955	283.91	284.89	1824413.0
2021-07-30 15:00:00	MSFT	Stock	284.9	285.2879	284.51	284.95	3163051.0
2021-07-30 16:00:00	MSFT	Stock	284.95	285.2	284.91	285.02	3156698.0
2021-07-30 17:00:00	MSFT	Stock	284.8953	285.1	284.8953	285.0	17165.0
2021-07-30 18:00:00	MSFT	Stock	285.0	285.05	284.94	284.94	1680.0
2021-07-30 19:00:00	MSFT	Stock	284.92	285.1	284.92	285.1	1429.0
2021-07-30 04:00:00	NVDA	Stock	19.378	19.486	19.199	19.4	88490.0
2021-07-30 05:00:00	NVDA	Stock	19.394	19.457	19.355	19.418	44470.0
2021-07-30 06:00:00	NVDA	Stock	19.44	19.49	19.403	19.465	213680.0
2021-07-30 07:00:00	NVDA	Stock	19.439	19.463	19.381	19.395	162920.0
2021-07-30 08:00:00	NVDA	Stock	19.4	19.485	19.328	19.472	636090.0
2021-07-30 09:00:00	NVDA	Stock	19.46	19.535	19.025	19.5022	29679050.0
2021-07-30 10:00:00	NVDA	Stock	19.51	19.63	19.378	19.4	27512290.0
2021-07-30 11:00:00	NVDA	Stock	19.4	19.475	19.358	19.44	14655270.0
2021-07-30 12:00:00	NVDA	Stock	19.435	19.478	19.381	19.45	8287140.0
2021-07-30 13:00:00	NVDA	Stock	19.45	19.536	19.387	19.4595	10563510.0
2021-07-30 14:00:00	NVDA	Stock	19.462	19.528	19.427	19.484	8801110.0
2021-07-30 15:00:00	NVDA	Stock	19.481	19.514	19.452	19.49	16469370.0
2021-07-30 16:00:00	NVDA	Stock	19.499	19.52	19.487	19.505	16568980.0
2021-07-30 17:00:00	NVDA	Stock	19.505	19.51	19.48	19.489	295500.0
2021-07-30 18:00:00	NVDA	Stock	19.49	19.519	19.482	19.499	83550.0
2021-07-30 19:00:00	NVDA	Stock	19.485	19.5	19.388	19.449	211300.0
2021-07-30 04:00:00	AMZN	Stock	168.05	168.8095	167.5	168.7	93960.0
2021-07-30 05:00:00	AMZN	Stock	168.8205	169.25	168.8205	169.0	25880.0

> showing 50 of 64,477 rows — these rows as CSV

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