PREVIEW / stock_1hour / 2021-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-17.parquet
  size:    1.5 MB
  rows:    65,900
  symbols: 2,646

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-17 04:00:00	AAPL	Stock	171.66	171.66	170.03	170.98	61266.0
2021-12-17 05:00:00	AAPL	Stock	170.96	170.97	170.2	170.25	31296.0
2021-12-17 06:00:00	AAPL	Stock	170.3	171.0	170.3	170.95	28659.0
2021-12-17 07:00:00	AAPL	Stock	171.0	171.0	169.14	169.4	393787.0
2021-12-17 08:00:00	AAPL	Stock	170.6906	171.0	169.13	170.39	943935.0
2021-12-17 09:00:00	AAPL	Stock	170.39	173.07	169.55	171.9401	26606539.0
2021-12-17 10:00:00	AAPL	Stock	171.9401	172.81	169.76	172.52	19399293.0
2021-12-17 11:00:00	AAPL	Stock	172.51	173.47	170.3551	171.03	16053217.0
2021-12-17 12:00:00	AAPL	Stock	171.0	171.32	169.86	170.81	12154027.0
2021-12-17 13:00:00	AAPL	Stock	170.81	172.47	170.47	172.4516	11293023.0
2021-12-17 14:00:00	AAPL	Stock	172.45	173.09	171.66	172.33	11063526.0
2021-12-17 15:00:00	AAPL	Stock	172.32	172.8	170.5	170.97	18192646.0
2021-12-17 16:00:00	AAPL	Stock	171.14	171.54	171.1	171.49	51604518.0
2021-12-17 17:00:00	AAPL	Stock	171.5	171.56	171.35	171.37	44918.0
2021-12-17 18:00:00	AAPL	Stock	171.39	171.55	171.14	171.46	280250.0
2021-12-17 19:00:00	AAPL	Stock	171.5	172.26	171.46	171.89	170447.0
2021-12-17 04:00:00	MSFT	Stock	323.89	324.83	321.85	322.86	10057.0
2021-12-17 05:00:00	MSFT	Stock	323.25	323.26	321.7	321.71	7392.0
2021-12-17 06:00:00	MSFT	Stock	322.19	323.75	322.19	323.08	2571.0
2021-12-17 07:00:00	MSFT	Stock	322.72	323.11	320.81	321.62	21756.0
2021-12-17 08:00:00	MSFT	Stock	323.005	325.712	320.8	322.25	79713.0
2021-12-17 09:00:00	MSFT	Stock	322.35	323.7042	319.06	321.34	7982634.0
2021-12-17 10:00:00	MSFT	Stock	321.31	322.63	317.25	322.44	3589678.0
2021-12-17 11:00:00	MSFT	Stock	322.47	323.815	319.93	320.895	2413880.0
2021-12-17 12:00:00	MSFT	Stock	320.87	323.08	319.62	321.6413	1856569.0
2021-12-17 13:00:00	MSFT	Stock	321.6	323.88	320.94	323.73	1570223.0
2021-12-17 14:00:00	MSFT	Stock	323.76	324.438	322.33	323.8497	1637662.0
2021-12-17 15:00:00	MSFT	Stock	323.86	324.92	321.69	323.8	3541370.0
2021-12-17 16:00:00	MSFT	Stock	323.8	324.28	323.51	323.66	13695581.0
2021-12-17 17:00:00	MSFT	Stock	323.8	324.15	323.8	323.95	4017.0
2021-12-17 18:00:00	MSFT	Stock	324.12	324.12	323.8	323.85	214257.0
2021-12-17 19:00:00	MSFT	Stock	323.9	324.9	323.9	324.6	14553.0
2021-12-17 04:00:00	NVDA	Stock	28.147	28.147	27.595	27.8	387430.0
2021-12-17 05:00:00	NVDA	Stock	27.814	27.875	27.73	27.75	95290.0
2021-12-17 06:00:00	NVDA	Stock	27.868	27.99	27.826	27.957	108810.0
2021-12-17 07:00:00	NVDA	Stock	27.957	27.99	27.64	27.718	961660.0
2021-12-17 08:00:00	NVDA	Stock	27.9	28.4579	27.64	28.0451	1589210.0
2021-12-17 09:00:00	NVDA	Stock	28.05	28.745	27.82	28.5072	89397480.0
2021-12-17 10:00:00	NVDA	Stock	28.506	28.922	28.007	28.717	78663470.0
2021-12-17 11:00:00	NVDA	Stock	28.713	28.881	28.148	28.3771	51952600.0
2021-12-17 12:00:00	NVDA	Stock	28.377	28.5	28.0	28.122	39488210.0
2021-12-17 13:00:00	NVDA	Stock	28.117	28.334	28.032	28.312	29352260.0
2021-12-17 14:00:00	NVDA	Stock	28.317	28.433	28.169	28.242	34858330.0
2021-12-17 15:00:00	NVDA	Stock	28.237	28.365	27.76	27.799	73912420.0
2021-12-17 16:00:00	NVDA	Stock	27.799	27.949	27.799	27.904	156938300.0
2021-12-17 17:00:00	NVDA	Stock	27.925	27.95	27.9	27.93	211140.0
2021-12-17 18:00:00	NVDA	Stock	27.936	27.95	27.801	27.95	2092590.0
2021-12-17 19:00:00	NVDA	Stock	27.95	28.387	27.923	28.0	532690.0
2021-12-17 04:00:00	AMZN	Stock	167.2745	167.5915	167.2	167.2	12360.0
2021-12-17 07:00:00	AMZN	Stock	167.6	167.7	167.261	167.261	20920.0

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

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