PREVIEW / stock_1hour / 2020-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-24.parquet
  size:    1.2 MB
  rows:    54,930
  symbols: 2,456

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
2020-02-24 04:00:00	AAPL	Stock	75.0	75.47	74.4775	74.9775	433376.0
2020-02-24 05:00:00	AAPL	Stock	74.9725	75.25	74.625	74.75	269768.0
2020-02-24 06:00:00	AAPL	Stock	74.685	75.255	74.5875	75.1	237564.0
2020-02-24 07:00:00	AAPL	Stock	75.0575	75.825	75.0	75.45	1063816.0
2020-02-24 08:00:00	AAPL	Stock	75.4825	75.825	75.0	75.3125	1676532.0
2020-02-24 09:00:00	AAPL	Stock	75.3275	76.045	72.3075	75.69	49880348.0
2020-02-24 10:00:00	AAPL	Stock	75.6925	75.92	74.6	75.2712	28210540.0
2020-02-24 11:00:00	AAPL	Stock	75.27	75.34	74.6025	74.925	17078216.0
2020-02-24 12:00:00	AAPL	Stock	74.915	75.245	74.5	75.03	13394400.0
2020-02-24 13:00:00	AAPL	Stock	75.015	75.1675	74.6675	75.0875	10822724.0
2020-02-24 14:00:00	AAPL	Stock	75.0925	75.625	74.7775	75.5425	12754000.0
2020-02-24 15:00:00	AAPL	Stock	75.55	75.8225	74.52	74.5425	25587280.0
2020-02-24 16:00:00	AAPL	Stock	74.5425	74.62	74.4375	74.5975	20094336.0
2020-02-24 17:00:00	AAPL	Stock	74.55	74.5625	74.4	74.455	166000.0
2020-02-24 18:00:00	AAPL	Stock	74.4225	74.8375	74.315	74.825	305476.0
2020-02-24 19:00:00	AAPL	Stock	74.825	75.325	74.8125	75.275	307472.0
2020-02-24 04:00:00	MSFT	Stock	172.8	172.8	171.3	171.8	83971.0
2020-02-24 05:00:00	MSFT	Stock	172.05	172.3	171.42	171.44	37203.0
2020-02-24 06:00:00	MSFT	Stock	171.44	173.16	171.44	172.71	39726.0
2020-02-24 07:00:00	MSFT	Stock	172.99	173.98	171.8	172.02	200854.0
2020-02-24 08:00:00	MSFT	Stock	173.7	173.98	168.65	169.771	761641.0
2020-02-24 09:00:00	MSFT	Stock	169.8	174.3	163.23	174.26	15528468.0
2020-02-24 10:00:00	MSFT	Stock	174.22	174.55	171.18	172.95	9552022.0
2020-02-24 11:00:00	MSFT	Stock	172.94	173.18	171.07	171.86	5587589.0
2020-02-24 12:00:00	MSFT	Stock	171.83	172.43	170.7	171.71	3869766.0
2020-02-24 13:00:00	MSFT	Stock	171.69	172.395	170.68	172.19	3650788.0
2020-02-24 14:00:00	MSFT	Stock	172.18	173.99	171.23	173.86	4201386.0
2020-02-24 15:00:00	MSFT	Stock	173.844	174.25	170.7	170.88	8558469.0
2020-02-24 16:00:00	MSFT	Stock	170.88	171.27	170.54	170.87	6157010.0
2020-02-24 17:00:00	MSFT	Stock	170.81	171.1	170.36	170.74	29803.0
2020-02-24 18:00:00	MSFT	Stock	170.5	172.45	170.5	172.45	29819.0
2020-02-24 19:00:00	MSFT	Stock	172.45	173.09	172.0	172.86	40825.0
2020-02-24 04:00:00	NVDA	Stock	7.0	7.0	6.8302	6.941	1017960.0
2020-02-24 05:00:00	NVDA	Stock	6.9312	6.9312	6.8568	6.8568	534680.0
2020-02-24 06:00:00	NVDA	Stock	6.855	6.95	6.841	6.925	701600.0
2020-02-24 07:00:00	NVDA	Stock	6.925	7.01	6.875	6.8812	5122400.0
2020-02-24 08:00:00	NVDA	Stock	6.9829	7.0	6.8375	6.872	8294760.0
2020-02-24 09:00:00	NVDA	Stock	6.8725	7.0172	6.7	6.9624	191324440.0
2020-02-24 10:00:00	NVDA	Stock	6.959	7.0468	6.8762	6.9775	147866720.0
2020-02-24 11:00:00	NVDA	Stock	6.9782	7.0	6.9008	6.9249	71162080.0
2020-02-24 12:00:00	NVDA	Stock	6.9232	6.9232	6.8642	6.8775	66160040.0
2020-02-24 13:00:00	NVDA	Stock	6.875	6.8765	6.8152	6.8698	64542720.0
2020-02-24 14:00:00	NVDA	Stock	6.8698	6.943	6.8172	6.9398	64830360.0
2020-02-24 15:00:00	NVDA	Stock	6.9412	6.975	6.8258	6.83	108233000.0
2020-02-24 16:00:00	NVDA	Stock	6.8298	6.8358	6.7998	6.825	38922680.0
2020-02-24 17:00:00	NVDA	Stock	6.825	6.8308	6.7972	6.8	1736640.0
2020-02-24 18:00:00	NVDA	Stock	6.8128	6.8375	6.775	6.825	2870160.0
2020-02-24 19:00:00	NVDA	Stock	6.8222	6.9	6.8125	6.9	2049520.0
2020-02-24 04:00:00	AMZN	Stock	101.3	101.3	100.299	100.61	73980.0
2020-02-24 05:00:00	AMZN	Stock	100.9455	101.1	100.654	100.75	25040.0

> showing 50 of 54,930 rows — these rows as CSV

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