PREVIEW / stock_1hour / 2020-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-28.parquet
  size:    1.3 MB
  rows:    59,527
  symbols: 2,523

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-10-28 04:00:00	AAPL	Stock	115.9	116.25	115.2	115.6	65443.0
2020-10-28 05:00:00	AAPL	Stock	115.54	115.87	115.34	115.56	55538.0
2020-10-28 06:00:00	AAPL	Stock	115.62	115.82	115.13	115.17	48754.0
2020-10-28 07:00:00	AAPL	Stock	115.28	115.7	115.13	115.2	237502.0
2020-10-28 08:00:00	AAPL	Stock	115.5	116.89	114.51	114.88	598351.0
2020-10-28 09:00:00	AAPL	Stock	114.88	115.43	112.44	112.98	16377136.0
2020-10-28 10:00:00	AAPL	Stock	112.99	113.12	111.95	112.535	20346083.0
2020-10-28 11:00:00	AAPL	Stock	112.53	113.07	112.0	112.91	15005444.0
2020-10-28 12:00:00	AAPL	Stock	112.9	113.37	112.5	112.51	11575917.0
2020-10-28 13:00:00	AAPL	Stock	112.5	113.24	112.05	113.178	11229426.0
2020-10-28 14:00:00	AAPL	Stock	113.175	113.38	112.48	112.91	11839904.0
2020-10-28 15:00:00	AAPL	Stock	112.91	113.2	111.1	111.15	22192241.0
2020-10-28 16:00:00	AAPL	Stock	111.15	111.91	111.13	111.7	12888606.0
2020-10-28 17:00:00	AAPL	Stock	111.74	112.0	111.2	111.99	246531.0
2020-10-28 18:00:00	AAPL	Stock	111.98	112.18	111.77	112.13	206979.0
2020-10-28 19:00:00	AAPL	Stock	112.14	112.2	111.88	112.09	193674.0
2020-10-28 04:00:00	MSFT	Stock	209.82	210.5	209.01	209.89	20163.0
2020-10-28 05:00:00	MSFT	Stock	209.83	210.27	209.52	209.8	10222.0
2020-10-28 06:00:00	MSFT	Stock	209.8	209.82	208.7	209.04	10246.0
2020-10-28 07:00:00	MSFT	Stock	209.0	209.5	208.53	208.53	81184.0
2020-10-28 08:00:00	MSFT	Stock	209.09	210.13	207.0	207.41	286680.0
2020-10-28 09:00:00	MSFT	Stock	207.41	208.84	205.33	206.165	6721529.0
2020-10-28 10:00:00	MSFT	Stock	206.14	206.64	204.4	205.07	7645694.0
2020-10-28 11:00:00	MSFT	Stock	205.05	205.88	204.49	205.265	4492350.0
2020-10-28 12:00:00	MSFT	Stock	205.26	205.54	204.6	204.7	2920245.0
2020-10-28 13:00:00	MSFT	Stock	204.69	205.36	204.01	205.26	3175511.0
2020-10-28 14:00:00	MSFT	Stock	205.26	205.26	204.1	205.18	3130758.0
2020-10-28 15:00:00	MSFT	Stock	205.18	205.92	202.1	202.71	7530030.0
2020-10-28 16:00:00	MSFT	Stock	202.68	203.2	202.39	203.1	5971884.0
2020-10-28 17:00:00	MSFT	Stock	203.07	203.24	203.0	203.0	35238.0
2020-10-28 18:00:00	MSFT	Stock	203.05	204.0	202.95	203.85	86747.0
2020-10-28 19:00:00	MSFT	Stock	203.9	203.97	203.0	203.32	54174.0
2020-10-28 05:00:00	NVDA	Stock	13.2068	13.2068	13.2	13.2	75800.0
2020-10-28 06:00:00	NVDA	Stock	13.2132	13.2132	13.2132	13.2132	10000.0
2020-10-28 07:00:00	NVDA	Stock	13.2	13.2648	13.2	13.2375	477960.0
2020-10-28 08:00:00	NVDA	Stock	13.2365	13.2733	13.1898	13.2025	2630600.0
2020-10-28 09:00:00	NVDA	Stock	13.2	13.26	12.9178	12.96	45823840.0
2020-10-28 10:00:00	NVDA	Stock	12.9569	13.198	12.8433	12.905	53773440.0
2020-10-28 11:00:00	NVDA	Stock	12.9008	12.9625	12.8396	12.8653	33783280.0
2020-10-28 12:00:00	NVDA	Stock	12.8635	12.9072	12.8202	12.8343	25224480.0
2020-10-28 13:00:00	NVDA	Stock	12.834	12.8505	12.7328	12.8088	35885160.0
2020-10-28 14:00:00	NVDA	Stock	12.8102	12.825	12.7005	12.759	29879640.0
2020-10-28 15:00:00	NVDA	Stock	12.7638	12.849	12.609	12.6262	63947800.0
2020-10-28 16:00:00	NVDA	Stock	12.627	12.7125	12.6025	12.6769	4268800.0
2020-10-28 17:00:00	NVDA	Stock	12.6938	12.7058	12.675	12.7	311840.0
2020-10-28 18:00:00	NVDA	Stock	12.7	12.775	12.7	12.7332	561200.0
2020-10-28 19:00:00	NVDA	Stock	12.7388	12.75	12.705	12.715	284120.0
2020-10-28 07:00:00	AMZN	Stock	162.65	163.5	162.5	163.138	305940.0
2020-10-28 08:00:00	AMZN	Stock	163.155	163.3455	161.994	162.25	398720.0
2020-10-28 09:00:00	AMZN	Stock	162.2	163.201	159.05	160.2	16597360.0

> showing 50 of 59,527 rows — these rows as CSV

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