PREVIEW / stock_1hour / 2022-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-15.parquet
  size:    1.4 MB
  rows:    64,399
  symbols: 2,540

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-02-15 04:00:00	AAPL	Stock	168.9	171.56	168.9	171.19	37868.0
2022-02-15 05:00:00	AAPL	Stock	171.25	171.7	171.01	171.58	23478.0
2022-02-15 06:00:00	AAPL	Stock	171.65	172.16	171.55	171.82	26807.0
2022-02-15 07:00:00	AAPL	Stock	171.74	172.03	171.52	171.81	131231.0
2022-02-15 08:00:00	AAPL	Stock	171.93	172.03	168.88	171.05	436913.0
2022-02-15 09:00:00	AAPL	Stock	171.05	171.4506	170.25	170.88	7703672.0
2022-02-15 10:00:00	AAPL	Stock	170.89	171.36	170.48	171.18	7266255.0
2022-02-15 11:00:00	AAPL	Stock	171.19	171.72	171.02	171.521	5304837.0
2022-02-15 12:00:00	AAPL	Stock	171.52	171.65	170.34	170.5699	5317405.0
2022-02-15 13:00:00	AAPL	Stock	170.57	172.04	170.53	171.77	5081458.0
2022-02-15 14:00:00	AAPL	Stock	171.77	172.27	171.38	171.985	4914124.0
2022-02-15 15:00:00	AAPL	Stock	171.99	172.95	171.72	172.8	10778140.0
2022-02-15 16:00:00	AAPL	Stock	172.79	172.96	172.22	172.3	7666921.0
2022-02-15 17:00:00	AAPL	Stock	172.26	172.79	172.25	172.28	704072.0
2022-02-15 18:00:00	AAPL	Stock	172.37	172.4	172.2	172.22	20276.0
2022-02-15 19:00:00	AAPL	Stock	172.25	172.3	171.88	171.9	97040.0
2022-02-15 04:00:00	MSFT	Stock	295.75	300.49	295.75	300.12	4833.0
2022-02-15 05:00:00	MSFT	Stock	300.45	300.95	300.0	300.53	7394.0
2022-02-15 06:00:00	MSFT	Stock	300.7	301.69	300.32	301.16	5663.0
2022-02-15 07:00:00	MSFT	Stock	301.16	301.87	300.75	301.44	30848.0
2022-02-15 08:00:00	MSFT	Stock	300.9996	301.88	299.65	299.75	99112.0
2022-02-15 09:00:00	MSFT	Stock	300.0	300.8	298.88	299.34	2613418.0
2022-02-15 10:00:00	MSFT	Stock	299.38	300.7	298.24	299.88	2890459.0
2022-02-15 11:00:00	MSFT	Stock	299.9	300.33	299.19	299.46	1506015.0
2022-02-15 12:00:00	MSFT	Stock	299.51	299.72	297.02	298.02	1805985.0
2022-02-15 13:00:00	MSFT	Stock	298.03	299.07	297.88	298.98	1300575.0
2022-02-15 14:00:00	MSFT	Stock	299.01	299.69	298.23	299.54	1493946.0
2022-02-15 15:00:00	MSFT	Stock	299.54	300.75	298.7	300.53	3797769.0
2022-02-15 16:00:00	MSFT	Stock	300.47	300.47	299.25	300.01	4216960.0
2022-02-15 17:00:00	MSFT	Stock	300.1	300.47	299.62	300.08	297183.0
2022-02-15 18:00:00	MSFT	Stock	300.1	300.12	299.5	299.5	3205.0
2022-02-15 19:00:00	MSFT	Stock	299.5	299.5	299.25	299.45	13176.0
2022-02-15 04:00:00	NVDA	Stock	24.6	25.293	24.6	25.19	688880.0
2022-02-15 05:00:00	NVDA	Stock	25.199	25.28	25.107	25.23	267250.0
2022-02-15 06:00:00	NVDA	Stock	25.22	25.37	25.202	25.3	222390.0
2022-02-15 07:00:00	NVDA	Stock	25.27	25.293	25.137	25.204	1186460.0
2022-02-15 08:00:00	NVDA	Stock	25.2	25.28	24.305	24.977	2956840.0
2022-02-15 09:00:00	NVDA	Stock	24.97	25.56	24.784	25.5434	62494140.0
2022-02-15 10:00:00	NVDA	Stock	25.544	26.084	25.5333	25.9749	115153200.0
2022-02-15 11:00:00	NVDA	Stock	25.979	26.385	25.929	26.332	72463470.0
2022-02-15 12:00:00	NVDA	Stock	26.333	26.36	25.836	26.0164	66447260.0
2022-02-15 13:00:00	NVDA	Stock	26.017	26.325	25.995	26.297	43696720.0
2022-02-15 14:00:00	NVDA	Stock	26.305	26.449	26.14	26.434	49892530.0
2022-02-15 15:00:00	NVDA	Stock	26.4364	26.545	26.271	26.52	76744910.0
2022-02-15 16:00:00	NVDA	Stock	26.495	26.625	26.413	26.523	22134550.0
2022-02-15 17:00:00	NVDA	Stock	26.52	26.65	26.495	26.6	2243390.0
2022-02-15 18:00:00	NVDA	Stock	26.61	26.629	26.402	26.42	769730.0
2022-02-15 19:00:00	NVDA	Stock	26.439	26.439	26.325	26.385	707960.0
2022-02-15 04:00:00	AMZN	Stock	156.388	158.05	156.388	157.875	14380.0
2022-02-15 06:00:00	AMZN	Stock	158.25	158.75	158.25	158.75	20460.0

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

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