PREVIEW / stock_1hour / 2022-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-12.parquet
  size:    1.4 MB
  rows:    64,386
  symbols: 2,590

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
2022-01-12 04:00:00	AAPL	Stock	174.65	175.89	174.65	175.82	26430.0
2022-01-12 05:00:00	AAPL	Stock	175.86	176.04	175.55	175.97	17637.0
2022-01-12 06:00:00	AAPL	Stock	176.0	176.0	175.76	175.76	8810.0
2022-01-12 07:00:00	AAPL	Stock	175.63	175.7	175.2	175.64	85601.0
2022-01-12 08:00:00	AAPL	Stock	175.35	176.78	175.2	176.76	533833.0
2022-01-12 09:00:00	AAPL	Stock	176.78	176.88	175.3	176.32	9583242.0
2022-01-12 10:00:00	AAPL	Stock	176.33	177.18	175.3	175.6475	12752159.0
2022-01-12 11:00:00	AAPL	Stock	175.64	176.255	174.82	175.83	9384075.0
2022-01-12 12:00:00	AAPL	Stock	175.84	176.39	175.31	176.24	6189890.0
2022-01-12 13:00:00	AAPL	Stock	176.24	176.275	175.47	175.57	4861133.0
2022-01-12 14:00:00	AAPL	Stock	175.565	175.81	175.22	175.4999	5087254.0
2022-01-12 15:00:00	AAPL	Stock	175.5	175.94	175.08	175.61	9089798.0
2022-01-12 16:00:00	AAPL	Stock	175.53	175.7	175.36	175.41	6186588.0
2022-01-12 17:00:00	AAPL	Stock	175.41	175.45	175.3	175.35	27675.0
2022-01-12 18:00:00	AAPL	Stock	175.31	175.44	175.15	175.2	33007.0
2022-01-12 19:00:00	AAPL	Stock	175.13	175.22	174.14	175.1	53957.0
2022-01-12 04:00:00	MSFT	Stock	314.0	316.56	314.0	316.4	7143.0
2022-01-12 05:00:00	MSFT	Stock	316.4	316.58	316.31	316.58	2261.0
2022-01-12 06:00:00	MSFT	Stock	316.7	316.7	316.31	316.31	3881.0
2022-01-12 07:00:00	MSFT	Stock	316.21	316.5	315.6	316.0	23191.0
2022-01-12 08:00:00	MSFT	Stock	315.8499	319.15	315.6	319.0	223833.0
2022-01-12 09:00:00	MSFT	Stock	319.0	321.98	318.0	321.895	4730029.0
2022-01-12 10:00:00	MSFT	Stock	321.91	323.41	318.54	318.88	5041424.0
2022-01-12 11:00:00	MSFT	Stock	318.87	320.19	317.81	319.51	2648851.0
2022-01-12 12:00:00	MSFT	Stock	319.55	320.24	318.26	319.82	1507567.0
2022-01-12 13:00:00	MSFT	Stock	319.83	319.99	318.43	318.585	1385352.0
2022-01-12 14:00:00	MSFT	Stock	318.55	319.15	318.0	318.12	1614061.0
2022-01-12 15:00:00	MSFT	Stock	318.12	318.8	317.08	318.29	3214723.0
2022-01-12 16:00:00	MSFT	Stock	318.27	318.7	318.08	318.4	4827781.0
2022-01-12 17:00:00	MSFT	Stock	318.4	318.6	318.2	318.4	17249.0
2022-01-12 18:00:00	MSFT	Stock	318.23	318.6	317.9	318.03	4690.0
2022-01-12 19:00:00	MSFT	Stock	318.02	318.2	317.53	317.8	16940.0
2022-01-12 04:00:00	NVDA	Stock	27.747	27.906	27.66	27.88	89920.0
2022-01-12 05:00:00	NVDA	Stock	27.924	27.962	27.85	27.962	96570.0
2022-01-12 06:00:00	NVDA	Stock	27.967	27.97	27.906	27.906	31730.0
2022-01-12 07:00:00	NVDA	Stock	27.9	27.965	27.8	27.869	364050.0
2022-01-12 08:00:00	NVDA	Stock	27.9139	28.225	27.775	28.204	1986140.0
2022-01-12 09:00:00	NVDA	Stock	28.204	28.456	27.989	28.2659	47609000.0
2022-01-12 10:00:00	NVDA	Stock	28.268	28.595	27.875	27.937	66970540.0
2022-01-12 11:00:00	NVDA	Stock	27.938	28.08	27.608	28.018	45017350.0
2022-01-12 12:00:00	NVDA	Stock	28.019	28.211	27.823	28.149	31431570.0
2022-01-12 13:00:00	NVDA	Stock	28.152	28.16	27.95	27.9965	24202160.0
2022-01-12 14:00:00	NVDA	Stock	27.995	28.082	27.891	28.0165	22933520.0
2022-01-12 15:00:00	NVDA	Stock	28.0155	28.047	27.865	28.0	30247220.0
2022-01-12 16:00:00	NVDA	Stock	28.0	28.048	27.95	27.96	16033830.0
2022-01-12 17:00:00	NVDA	Stock	27.962	27.998	27.91	27.93	140580.0
2022-01-12 18:00:00	NVDA	Stock	27.93	27.963	27.9	27.914	355070.0
2022-01-12 19:00:00	NVDA	Stock	27.914	27.938	27.88	27.915	266400.0
2022-01-12 05:00:00	AMZN	Stock	165.5975	165.5975	165.5975	165.5975	2000.0
2022-01-12 07:00:00	AMZN	Stock	165.6775	165.6775	165.6775	165.6775	2000.0

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

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