PREVIEW / stock_1hour / 2020-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-02.parquet
  size:    1.2 MB
  rows:    54,969
  symbols: 2,447

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-03-02 04:00:00	AAPL	Stock	70.75	71.21	69.75	70.0	517864.0
2020-03-02 05:00:00	AAPL	Stock	70.1	70.3525	69.81	69.81	256144.0
2020-03-02 06:00:00	AAPL	Stock	69.7675	69.7675	68.25	68.4325	212744.0
2020-03-02 07:00:00	AAPL	Stock	68.425	69.6025	68.16	69.5375	968544.0
2020-03-02 08:00:00	AAPL	Stock	68.875	69.8125	68.625	69.75	2166804.0
2020-03-02 09:00:00	AAPL	Stock	69.8125	71.0575	69.43	70.41	40629324.0
2020-03-02 10:00:00	AAPL	Stock	70.39	71.6025	69.9475	71.2718	40965292.0
2020-03-02 11:00:00	AAPL	Stock	71.26	73.225	71.2325	73.1775	49795016.0
2020-03-02 12:00:00	AAPL	Stock	73.1825	73.3875	72.2625	73.0075	35687324.0
2020-03-02 13:00:00	AAPL	Stock	73.0075	73.07	71.875	72.6575	22140632.0
2020-03-02 14:00:00	AAPL	Stock	72.6512	72.9825	71.716	72.085	23279972.0
2020-03-02 15:00:00	AAPL	Stock	72.081	75.36	72.015	74.705	44678768.0
2020-03-02 16:00:00	AAPL	Stock	74.705	74.72	74.135	74.4125	17460856.0
2020-03-02 17:00:00	AAPL	Stock	74.3625	74.7025	74.2425	74.3875	319452.0
2020-03-02 18:00:00	AAPL	Stock	74.3625	74.575	74.2125	74.495	284268.0
2020-03-02 19:00:00	AAPL	Stock	74.5	74.8	74.39	74.7475	364380.0
2020-03-02 04:00:00	MSFT	Stock	166.15	166.43	163.83	164.2	96013.0
2020-03-02 05:00:00	MSFT	Stock	163.8	164.46	163.23	163.54	27537.0
2020-03-02 06:00:00	MSFT	Stock	163.36	163.36	159.91	161.25	36790.0
2020-03-02 07:00:00	MSFT	Stock	160.9	162.4	160.0	162.2	125055.0
2020-03-02 08:00:00	MSFT	Stock	161.3	163.6	160.5	163.6	276905.0
2020-03-02 09:00:00	MSFT	Stock	163.52	166.57	163.37	165.23	9244321.0
2020-03-02 10:00:00	MSFT	Stock	165.23	165.9	162.31	164.78	7939685.0
2020-03-02 11:00:00	MSFT	Stock	164.78	168.53	164.4	168.51	8253916.0
2020-03-02 12:00:00	MSFT	Stock	168.51	168.8	166.84	168.65	5137723.0
2020-03-02 13:00:00	MSFT	Stock	168.65	168.75	166.43	167.13	3526668.0
2020-03-02 14:00:00	MSFT	Stock	167.13	167.6	164.14	165.58	4536190.0
2020-03-02 15:00:00	MSFT	Stock	165.61	172.92	165.53	172.85	10898747.0
2020-03-02 16:00:00	MSFT	Stock	172.8	172.88	171.65	172.17	9447032.0
2020-03-02 17:00:00	MSFT	Stock	172.29	172.79	172.17	172.4	94360.0
2020-03-02 18:00:00	MSFT	Stock	172.47	172.7	171.51	172.68	55455.0
2020-03-02 19:00:00	MSFT	Stock	172.68	173.36	172.68	173.2	72952.0
2020-03-02 04:00:00	NVDA	Stock	7.0	7.0012	6.8325	6.8608	533880.0
2020-03-02 05:00:00	NVDA	Stock	6.8525	6.8525	6.8135	6.8248	199080.0
2020-03-02 06:00:00	NVDA	Stock	6.8002	6.8002	6.675	6.675	300920.0
2020-03-02 07:00:00	NVDA	Stock	6.65	6.775	6.6375	6.775	1364200.0
2020-03-02 08:00:00	NVDA	Stock	6.7155	6.914	6.65	6.914	5870960.0
2020-03-02 09:00:00	NVDA	Stock	6.9025	6.9425	6.6553	6.661	149257560.0
2020-03-02 10:00:00	NVDA	Stock	6.6603	6.7718	6.525	6.7225	182601760.0
2020-03-02 11:00:00	NVDA	Stock	6.7195	6.88	6.7112	6.8765	139446600.0
2020-03-02 12:00:00	NVDA	Stock	6.8778	6.8788	6.7208	6.8318	71571520.0
2020-03-02 13:00:00	NVDA	Stock	6.8325	6.842	6.7338	6.7684	43652040.0
2020-03-02 14:00:00	NVDA	Stock	6.7672	6.791	6.6625	6.6954	51288200.0
2020-03-02 15:00:00	NVDA	Stock	6.6952	6.92	6.6938	6.9142	113048360.0
2020-03-02 16:00:00	NVDA	Stock	6.9108	6.9108	6.8512	6.8702	6338800.0
2020-03-02 17:00:00	NVDA	Stock	6.883	6.9108	6.875	6.8873	479720.0
2020-03-02 18:00:00	NVDA	Stock	6.892	6.9	6.87	6.8875	271680.0
2020-03-02 19:00:00	NVDA	Stock	6.9	6.9235	6.88	6.9132	814840.0
2020-03-02 04:00:00	AMZN	Stock	96.7	96.7	95.5	95.5	68720.0
2020-03-02 05:00:00	AMZN	Stock	94.8495	95.2495	94.75	94.75	32180.0

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

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