PREVIEW / stock_1hour / 2020-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-10.parquet
  size:    1.2 MB
  rows:    50,758
  symbols: 2,470

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-01-10 04:00:00	AAPL	Stock	77.805	77.975	77.805	77.97	39564.0
2020-01-10 05:00:00	AAPL	Stock	77.975	77.9925	77.9225	77.96	30460.0
2020-01-10 06:00:00	AAPL	Stock	77.9425	77.96	77.8725	77.8875	54652.0
2020-01-10 07:00:00	AAPL	Stock	77.925	78.0875	77.78	78.0475	600816.0
2020-01-10 08:00:00	AAPL	Stock	78.045	78.085	77.5	77.6875	1618424.0
2020-01-10 09:00:00	AAPL	Stock	77.7	78.0438	77.425	78.0165	22295956.0
2020-01-10 10:00:00	AAPL	Stock	78.02	78.1675	77.9175	78.0112	20044856.0
2020-01-10 11:00:00	AAPL	Stock	78.0125	78.0825	77.61	77.7675	15433168.0
2020-01-10 12:00:00	AAPL	Stock	77.7775	77.7775	77.0625	77.4425	19164168.0
2020-01-10 13:00:00	AAPL	Stock	77.4425	77.735	77.425	77.6765	8453976.0
2020-01-10 14:00:00	AAPL	Stock	77.675	77.7375	77.32	77.5162	10667532.0
2020-01-10 15:00:00	AAPL	Stock	77.515	77.605	77.3075	77.5925	17472396.0
2020-01-10 16:00:00	AAPL	Stock	77.5825	77.6375	77.5525	77.6025	5967696.0
2020-01-10 17:00:00	AAPL	Stock	77.595	77.6725	77.595	77.6625	65508.0
2020-01-10 18:00:00	AAPL	Stock	77.665	77.6775	77.625	77.6275	91492.0
2020-01-10 19:00:00	AAPL	Stock	77.6275	77.7125	77.625	77.6675	122864.0
2020-01-10 04:00:00	MSFT	Stock	162.54	162.83	162.5	162.77	4404.0
2020-01-10 05:00:00	MSFT	Stock	162.9	162.9	162.81	162.81	2201.0
2020-01-10 06:00:00	MSFT	Stock	162.8	163.19	162.72	162.99	7801.0
2020-01-10 07:00:00	MSFT	Stock	162.86	162.98	162.79	162.88	15904.0
2020-01-10 08:00:00	MSFT	Stock	162.85	163.03	162.53	162.7	79992.0
2020-01-10 09:00:00	MSFT	Stock	162.651	162.91	162.09	162.625	2502078.0
2020-01-10 10:00:00	MSFT	Stock	162.635	163.22	162.542	162.81	2784970.0
2020-01-10 11:00:00	MSFT	Stock	162.81	162.949	162.3	162.485	1592984.0
2020-01-10 12:00:00	MSFT	Stock	162.49	162.5	161.825	162.18	1785310.0
2020-01-10 13:00:00	MSFT	Stock	162.183	162.36	162.05	162.36	1028088.0
2020-01-10 14:00:00	MSFT	Stock	162.35	162.39	161.9	162.155	1111542.0
2020-01-10 15:00:00	MSFT	Stock	162.15	162.17	161.18	161.32	3483586.0
2020-01-10 16:00:00	MSFT	Stock	161.34	162.104	161.18	161.26	3718717.0
2020-01-10 17:00:00	MSFT	Stock	161.2	161.28	161.18	161.28	4849.0
2020-01-10 18:00:00	MSFT	Stock	161.28	161.28	161.21	161.28	2961.0
2020-01-10 19:00:00	MSFT	Stock	161.28	161.3	161.24	161.3	3088.0
2020-01-10 04:00:00	NVDA	Stock	6.1218	6.1363	6.1125	6.1363	39040.0
2020-01-10 05:00:00	NVDA	Stock	6.1182	6.136	6.1182	6.1345	72560.0
2020-01-10 06:00:00	NVDA	Stock	6.132	6.212	6.132	6.1938	209040.0
2020-01-10 07:00:00	NVDA	Stock	6.1815	6.2	6.1765	6.2	890960.0
2020-01-10 08:00:00	NVDA	Stock	6.1875	6.2	6.1553	6.172	2044280.0
2020-01-10 09:00:00	NVDA	Stock	6.169	6.2138	6.1403	6.1615	74542000.0
2020-01-10 10:00:00	NVDA	Stock	6.1618	6.2003	6.1502	6.1788	64326560.0
2020-01-10 11:00:00	NVDA	Stock	6.1798	6.1839	6.1483	6.1575	28129400.0
2020-01-10 12:00:00	NVDA	Stock	6.1575	6.1592	6.1038	6.1258	34026560.0
2020-01-10 13:00:00	NVDA	Stock	6.1259	6.144	6.1228	6.1332	14824600.0
2020-01-10 14:00:00	NVDA	Stock	6.1334	6.1345	6.1115	6.1272	16613480.0
2020-01-10 15:00:00	NVDA	Stock	6.1275	6.1292	6.0938	6.1083	38580960.0
2020-01-10 16:00:00	NVDA	Stock	6.108	6.1125	6.1053	6.1075	10134080.0
2020-01-10 17:00:00	NVDA	Stock	6.1075	6.108	6.1062	6.108	117720.0
2020-01-10 18:00:00	NVDA	Stock	6.108	6.1083	6.1075	6.1078	70880.0
2020-01-10 19:00:00	NVDA	Stock	6.1095	6.11	6.1075	6.1075	67320.0
2020-01-10 06:00:00	AMZN	Stock	95.25	95.25	95.25	95.25	2480.0
2020-01-10 07:00:00	AMZN	Stock	95.2975	95.35	95.25	95.33	62640.0

> showing 50 of 50,758 rows — these rows as CSV

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