PREVIEW / stock_1hour / 2023-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-19.parquet
  size:    1.4 MB
  rows:    61,078
  symbols: 1,911

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
2023-01-19 04:00:00	AAPL	Stock	134.52	134.9	134.31	134.4	33530.0
2023-01-19 05:00:00	AAPL	Stock	134.45	134.53	134.22	134.31	19012.0
2023-01-19 06:00:00	AAPL	Stock	134.29	134.3	133.63	133.79	50169.0
2023-01-19 07:00:00	AAPL	Stock	133.78	133.89	133.38	133.52	82807.0
2023-01-19 08:00:00	AAPL	Stock	133.69	134.872	133.22	133.82	302729.0
2023-01-19 09:00:00	AAPL	Stock	133.82	135.325	133.65	135.06	6992475.0
2023-01-19 10:00:00	AAPL	Stock	135.05	135.0686	133.77	134.0999	7422677.0
2023-01-19 11:00:00	AAPL	Stock	134.11	135.39	134.05	134.4	7024134.0
2023-01-19 12:00:00	AAPL	Stock	134.39	134.83	134.27	134.598	3795424.0
2023-01-19 13:00:00	AAPL	Stock	134.6	135.55	134.5873	135.28	4990854.0
2023-01-19 14:00:00	AAPL	Stock	135.27	136.25	135.06	135.925	5611405.0
2023-01-19 15:00:00	AAPL	Stock	135.94	136.05	135.1	135.2822	7952283.0
2023-01-19 16:00:00	AAPL	Stock	135.27	136.0	135.26	135.72	6785422.0
2023-01-19 17:00:00	AAPL	Stock	135.73	135.74	135.51	135.72	23094.0
2023-01-19 18:00:00	AAPL	Stock	135.78	135.86	135.42	135.55	31796.0
2023-01-19 19:00:00	AAPL	Stock	135.56	135.56	135.16	135.55	53055.0
2023-01-19 04:00:00	MSFT	Stock	235.33	235.66	234.94	234.99	14948.0
2023-01-19 05:00:00	MSFT	Stock	235.1	235.21	233.82	234.47	11712.0
2023-01-19 06:00:00	MSFT	Stock	234.44	234.44	233.8	234.15	12510.0
2023-01-19 07:00:00	MSFT	Stock	234.28	234.62	233.88	234.05	23450.0
2023-01-19 08:00:00	MSFT	Stock	234.3	235.221	233.32	234.32	50472.0
2023-01-19 09:00:00	MSFT	Stock	234.36	235.52	231.94	232.8901	2924354.0
2023-01-19 10:00:00	MSFT	Stock	232.88	233.38	230.83	231.1066	2957573.0
2023-01-19 11:00:00	MSFT	Stock	231.1	232.08	230.68	231.03	2389576.0
2023-01-19 12:00:00	MSFT	Stock	231.04	231.83	230.93	231.6214	1278612.0
2023-01-19 13:00:00	MSFT	Stock	231.65	233.99	231.59	233.23	1965962.0
2023-01-19 14:00:00	MSFT	Stock	233.22	234.4	232.9	233.85	1752826.0
2023-01-19 15:00:00	MSFT	Stock	233.88	234.08	231.58	232.04	3414255.0
2023-01-19 16:00:00	MSFT	Stock	231.96	233.43	231.44	232.27	4656549.0
2023-01-19 17:00:00	MSFT	Stock	232.27	232.4225	231.93	232.32	26740.0
2023-01-19 18:00:00	MSFT	Stock	232.35	232.5	232.23	232.24	13675.0
2023-01-19 19:00:00	MSFT	Stock	232.21	232.51	232.21	232.38	2135.0
2023-01-19 04:00:00	NVDA	Stock	17.279	17.284	17.202	17.218	40240.0
2023-01-19 05:00:00	NVDA	Stock	17.212	17.212	17.119	17.153	130480.0
2023-01-19 06:00:00	NVDA	Stock	17.15	17.15	16.88	17.017	421320.0
2023-01-19 07:00:00	NVDA	Stock	17.024	17.044	16.93	16.969	824840.0
2023-01-19 08:00:00	NVDA	Stock	17.02	17.377	16.8952	16.98	1407340.0
2023-01-19 09:00:00	NVDA	Stock	16.9811	17.197	16.763	17.0544	76491820.0
2023-01-19 10:00:00	NVDA	Stock	17.057	17.182	16.86	16.943	70366490.0
2023-01-19 11:00:00	NVDA	Stock	16.943	16.996	16.731	16.817	52207510.0
2023-01-19 12:00:00	NVDA	Stock	16.8185	16.963	16.801	16.86	42824410.0
2023-01-19 13:00:00	NVDA	Stock	16.861	16.975	16.8301	16.9451	34494070.0
2023-01-19 14:00:00	NVDA	Stock	16.9462	17.052	16.891	16.9613	33821830.0
2023-01-19 15:00:00	NVDA	Stock	16.963	17.0085	16.751	16.765	43562040.0
2023-01-19 16:00:00	NVDA	Stock	16.7645	16.847	16.759	16.811	31081900.0
2023-01-19 17:00:00	NVDA	Stock	16.8199	16.829	16.765	16.829	670850.0
2023-01-19 18:00:00	NVDA	Stock	16.819	16.831	16.818	16.825	90010.0
2023-01-19 19:00:00	NVDA	Stock	16.816	16.88	16.816	16.86	263880.0
2023-01-19 04:00:00	AMZN	Stock	95.19	95.3	94.6	94.7	40270.0
2023-01-19 05:00:00	AMZN	Stock	94.72	94.75	94.25	94.34	21113.0

> showing 50 of 61,078 rows — these rows as CSV

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