PREVIEW / stock_1hour / 2020-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-14.parquet
  size:    1.4 MB
  rows:    64,461
  symbols: 2,689

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-12-14 04:00:00	AAPL	Stock	122.2	122.47	122.09	122.45	23402.0
2020-12-14 05:00:00	AAPL	Stock	122.45	122.69	122.38	122.65	8336.0
2020-12-14 06:00:00	AAPL	Stock	122.6	122.8	122.59	122.73	20699.0
2020-12-14 07:00:00	AAPL	Stock	122.73	123.25	122.55	123.25	210762.0
2020-12-14 08:00:00	AAPL	Stock	123.23	123.26	122.33	123.06	608973.0
2020-12-14 09:00:00	AAPL	Stock	123.1	123.35	122.5	122.941	9086386.0
2020-12-14 10:00:00	AAPL	Stock	122.95	123.11	122.49	122.82	9931370.0
2020-12-14 11:00:00	AAPL	Stock	122.81	123.19	122.63	122.956	6632024.0
2020-12-14 12:00:00	AAPL	Stock	122.959	122.99	122.29	122.44	5694830.0
2020-12-14 13:00:00	AAPL	Stock	122.45	122.62	122.12	122.408	5795375.0
2020-12-14 14:00:00	AAPL	Stock	122.41	122.54	121.87	122.24	5804744.0
2020-12-14 15:00:00	AAPL	Stock	122.245	122.49	121.54	121.77	10065720.0
2020-12-14 16:00:00	AAPL	Stock	121.77	122.0	121.62	121.81	13598070.0
2020-12-14 17:00:00	AAPL	Stock	121.81	121.85	121.75	121.8	29564.0
2020-12-14 18:00:00	AAPL	Stock	121.8	121.92	121.8	121.85	51656.0
2020-12-14 19:00:00	AAPL	Stock	121.9	121.93	121.77	121.89	55063.0
2020-12-14 04:00:00	MSFT	Stock	213.38	213.38	212.99	213.06	1575.0
2020-12-14 05:00:00	MSFT	Stock	213.4	214.01	213.4	213.8	5268.0
2020-12-14 06:00:00	MSFT	Stock	213.81	213.93	213.81	213.93	804.0
2020-12-14 07:00:00	MSFT	Stock	213.93	214.0	213.79	213.81	6081.0
2020-12-14 08:00:00	MSFT	Stock	213.8	213.99	212.73	213.38	59333.0
2020-12-14 09:00:00	MSFT	Stock	213.38	214.79	212.85	214.74	3031331.0
2020-12-14 10:00:00	MSFT	Stock	214.73	215.67	214.54	214.57	3434459.0
2020-12-14 11:00:00	MSFT	Stock	214.57	216.2	214.51	216.15	2849423.0
2020-12-14 12:00:00	MSFT	Stock	216.16	216.21	214.382	214.57	1865257.0
2020-12-14 13:00:00	MSFT	Stock	214.58	215.23	214.02	215.058	1573513.0
2020-12-14 14:00:00	MSFT	Stock	215.08	215.27	214.4	215.14	1393327.0
2020-12-14 15:00:00	MSFT	Stock	215.135	215.2	213.51	214.19	3099004.0
2020-12-14 16:00:00	MSFT	Stock	214.2	214.2	213.9	214.07	5600745.0
2020-12-14 17:00:00	MSFT	Stock	213.96	214.08	213.77	214.0	7926.0
2020-12-14 18:00:00	MSFT	Stock	214.0	214.18	213.98	214.01	4678.0
2020-12-14 19:00:00	MSFT	Stock	214.1	214.21	213.9	214.19	3545.0
2020-12-14 04:00:00	NVDA	Stock	13.0173	13.05	13.0173	13.05	14400.0
2020-12-14 05:00:00	NVDA	Stock	13.0643	13.0643	13.05	13.05	18480.0
2020-12-14 06:00:00	NVDA	Stock	13.05	13.075	13.05	13.075	48800.0
2020-12-14 07:00:00	NVDA	Stock	13.0942	13.1198	13.08	13.1	313800.0
2020-12-14 08:00:00	NVDA	Stock	13.1122	13.1245	13.05	13.1125	898760.0
2020-12-14 09:00:00	NVDA	Stock	13.1125	13.2688	13.0775	13.2675	34579040.0
2020-12-14 10:00:00	NVDA	Stock	13.2675	13.325	13.1928	13.1966	36147800.0
2020-12-14 11:00:00	NVDA	Stock	13.1942	13.31	13.1898	13.3052	27732520.0
2020-12-14 12:00:00	NVDA	Stock	13.3064	13.317	13.2625	13.2733	31194720.0
2020-12-14 13:00:00	NVDA	Stock	13.275	13.295	13.1928	13.2849	21604120.0
2020-12-14 14:00:00	NVDA	Stock	13.2928	13.372	13.2832	13.3544	20468040.0
2020-12-14 15:00:00	NVDA	Stock	13.3519	13.3888	13.2673	13.3088	35743040.0
2020-12-14 16:00:00	NVDA	Stock	13.3088	13.327	13.267	13.3185	2093200.0
2020-12-14 17:00:00	NVDA	Stock	13.3022	13.3028	13.2778	13.2875	129040.0
2020-12-14 18:00:00	NVDA	Stock	13.309	13.325	13.306	13.325	313240.0
2020-12-14 19:00:00	NVDA	Stock	13.3018	13.325	13.29	13.325	233400.0
2020-12-14 04:00:00	AMZN	Stock	156.625	157.0025	156.625	156.75	22820.0
2020-12-14 05:00:00	AMZN	Stock	156.75	156.75	156.75	156.75	2000.0

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

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