PREVIEW / stock_1hour / 2021-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-22.parquet
  size:    1.4 MB
  rows:    64,171
  symbols: 2,957

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-04-22 04:00:00	AAPL	Stock	133.4	133.6	133.36	133.45	7091.0
2021-04-22 05:00:00	AAPL	Stock	133.4	133.5	133.3	133.36	3922.0
2021-04-22 06:00:00	AAPL	Stock	133.31	133.55	133.31	133.44	7726.0
2021-04-22 07:00:00	AAPL	Stock	133.4	133.4	133.01	133.11	80156.0
2021-04-22 08:00:00	AAPL	Stock	133.23	133.46	133.0	133.3	260759.0
2021-04-22 09:00:00	AAPL	Stock	133.3	133.4	132.52	132.96	7978686.0
2021-04-22 10:00:00	AAPL	Stock	132.9599	134.15	132.61	133.965	11289450.0
2021-04-22 11:00:00	AAPL	Stock	133.97	134.11	133.62	133.8117	6245289.0
2021-04-22 12:00:00	AAPL	Stock	133.82	134.1	133.54	134.03	5051191.0
2021-04-22 13:00:00	AAPL	Stock	134.025	134.08	131.62	131.805	14764733.0
2021-04-22 14:00:00	AAPL	Stock	131.7976	132.6	131.41	132.25	11118154.0
2021-04-22 15:00:00	AAPL	Stock	132.25	132.52	131.8616	131.94	11124918.0
2021-04-22 16:00:00	AAPL	Stock	131.94	132.7582	131.84	131.96	7304696.0
2021-04-22 17:00:00	AAPL	Stock	131.93	131.99	131.84	131.88	42938.0
2021-04-22 18:00:00	AAPL	Stock	131.88	132.02	131.88	132.02	47155.0
2021-04-22 19:00:00	AAPL	Stock	132.02	132.08	131.88	131.88	49013.0
2021-04-22 04:00:00	MSFT	Stock	260.6	260.77	260.34	260.77	2359.0
2021-04-22 05:00:00	MSFT	Stock	260.4	260.4	260.0	260.0	3607.0
2021-04-22 06:00:00	MSFT	Stock	260.0	260.34	259.97	260.03	5281.0
2021-04-22 07:00:00	MSFT	Stock	260.25	260.5	260.0	260.01	15084.0
2021-04-22 08:00:00	MSFT	Stock	260.5	260.57	259.81	260.4	23437.0
2021-04-22 09:00:00	MSFT	Stock	260.2	261.78	259.71	260.25	2144376.0
2021-04-22 10:00:00	MSFT	Stock	260.22	261.7	259.74	261.12	1956752.0
2021-04-22 11:00:00	MSFT	Stock	261.14	261.33	260.18	260.48	1321626.0
2021-04-22 12:00:00	MSFT	Stock	260.49	261.02	260.31	260.815	1013800.0
2021-04-22 13:00:00	MSFT	Stock	260.815	260.89	255.7	255.97	3924651.0
2021-04-22 14:00:00	MSFT	Stock	255.9644	257.1	255.64	256.685	2563675.0
2021-04-22 15:00:00	MSFT	Stock	256.69	257.48	255.9507	257.2	2982570.0
2021-04-22 16:00:00	MSFT	Stock	257.17	258.0949	256.1089	257.4	3259489.0
2021-04-22 17:00:00	MSFT	Stock	257.3982	257.4	257.0	257.0	8097.0
2021-04-22 18:00:00	MSFT	Stock	257.25	257.48	257.15	257.3	9078.0
2021-04-22 19:00:00	MSFT	Stock	257.4	257.5	257.2	257.25	7613.0
2021-04-22 04:00:00	NVDA	Stock	15.398	15.4128	15.398	15.4128	10520.0
2021-04-22 05:00:00	NVDA	Stock	15.4	15.45	15.4	15.4248	30600.0
2021-04-22 06:00:00	NVDA	Stock	15.42	15.42	15.42	15.42	4400.0
2021-04-22 07:00:00	NVDA	Stock	15.3775	15.38	15.3625	15.3638	61640.0
2021-04-22 08:00:00	NVDA	Stock	15.3775	15.3875	15.3375	15.3838	179920.0
2021-04-22 09:00:00	NVDA	Stock	15.3578	15.4386	15.2175	15.2605	18171400.0
2021-04-22 10:00:00	NVDA	Stock	15.2613	15.3255	15.2273	15.3032	12634400.0
2021-04-22 11:00:00	NVDA	Stock	15.3035	15.3112	15.2303	15.2408	9445240.0
2021-04-22 12:00:00	NVDA	Stock	15.24	15.2875	15.218	15.257	9908360.0
2021-04-22 13:00:00	NVDA	Stock	15.2541	15.2702	14.8598	14.887	35764240.0
2021-04-22 14:00:00	NVDA	Stock	14.8812	14.999	14.8038	14.9272	29750800.0
2021-04-22 15:00:00	NVDA	Stock	14.9315	14.9688	14.7835	14.8502	35825560.0
2021-04-22 16:00:00	NVDA	Stock	14.8502	14.859	14.8125	14.8172	17157160.0
2021-04-22 17:00:00	NVDA	Stock	14.815	14.815	14.7962	14.7962	290960.0
2021-04-22 18:00:00	NVDA	Stock	14.8	14.8388	14.7995	14.8375	164480.0
2021-04-22 19:00:00	NVDA	Stock	14.8488	14.8562	14.8378	14.8562	244920.0
2021-04-22 04:00:00	AMZN	Stock	167.787	167.787	167.787	167.787	2000.0
2021-04-22 06:00:00	AMZN	Stock	168.2	168.2	168.2	168.2	7900.0

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

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