PREVIEW / stock_1hour / 2020-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-02.parquet
  size:    1.3 MB
  rows:    59,063
  symbols: 2,504

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-02 04:00:00	AAPL	Stock	114.65	114.7	113.62	114.27	139233.0
2020-10-02 05:00:00	AAPL	Stock	114.2	114.57	113.23	113.46	136692.0
2020-10-02 06:00:00	AAPL	Stock	113.5	114.38	113.0	114.0	142771.0
2020-10-02 07:00:00	AAPL	Stock	114.0	114.2	112.8	112.92	1003917.0
2020-10-02 08:00:00	AAPL	Stock	112.96	117.08	112.79	113.28	2053972.0
2020-10-02 09:00:00	AAPL	Stock	113.25	114.62	112.22	114.161	20676952.0
2020-10-02 10:00:00	AAPL	Stock	114.17	115.37	114.06	115.12	17743782.0
2020-10-02 11:00:00	AAPL	Stock	115.115	115.18	113.13	113.3	18560986.0
2020-10-02 12:00:00	AAPL	Stock	113.31	114.56	112.56	114.092	19253692.0
2020-10-02 13:00:00	AAPL	Stock	114.08	114.17	113.28	113.59	11527951.0
2020-10-02 14:00:00	AAPL	Stock	113.58	114.278	113.18	113.73	11911796.0
2020-10-02 15:00:00	AAPL	Stock	113.73	113.95	112.97	113.02	17393624.0
2020-10-02 16:00:00	AAPL	Stock	113.02	113.42	112.96	113.19	8356325.0
2020-10-02 17:00:00	AAPL	Stock	113.18	113.18	112.3	112.59	541835.0
2020-10-02 18:00:00	AAPL	Stock	112.6	112.6	112.42	112.5	168779.0
2020-10-02 19:00:00	AAPL	Stock	112.52	112.65	112.48	112.58	209890.0
2020-10-02 04:00:00	MSFT	Stock	209.49	209.49	208.18	208.98	11847.0
2020-10-02 05:00:00	MSFT	Stock	208.99	209.19	207.0	207.74	14488.0
2020-10-02 06:00:00	MSFT	Stock	207.5	208.2	207.2	207.9	14233.0
2020-10-02 07:00:00	MSFT	Stock	208.06	208.19	206.69	206.7	122032.0
2020-10-02 08:00:00	MSFT	Stock	208.007	208.7	206.7	208.08	188107.0
2020-10-02 09:00:00	MSFT	Stock	208.11	209.98	207.5	209.55	3443856.0
2020-10-02 10:00:00	MSFT	Stock	209.55	210.99	208.77	209.62	3099845.0
2020-10-02 11:00:00	MSFT	Stock	209.6	209.74	206.69	206.85	3513745.0
2020-10-02 12:00:00	MSFT	Stock	206.85	208.02	205.54	207.42	3949863.0
2020-10-02 13:00:00	MSFT	Stock	207.4	207.75	206.47	207.26	2468417.0
2020-10-02 14:00:00	MSFT	Stock	207.21	208.263	206.78	207.625	2248628.0
2020-10-02 15:00:00	MSFT	Stock	207.64	208.08	206.04	206.18	3944380.0
2020-10-02 16:00:00	MSFT	Stock	206.19	206.88	206.03	206.55	4020517.0
2020-10-02 17:00:00	MSFT	Stock	206.62	206.62	205.6	205.6	32000.0
2020-10-02 18:00:00	MSFT	Stock	205.6	205.75	205.25	205.65	20742.0
2020-10-02 19:00:00	MSFT	Stock	205.6	205.89	205.55	205.8	13653.0
2020-10-02 04:00:00	NVDA	Stock	13.23	13.325	13.225	13.225	338440.0
2020-10-02 05:00:00	NVDA	Stock	13.275	13.295	13.177	13.1995	211160.0
2020-10-02 06:00:00	NVDA	Stock	13.1752	13.2475	13.1275	13.2475	132320.0
2020-10-02 07:00:00	NVDA	Stock	13.2438	13.2748	13.1625	13.1655	2118920.0
2020-10-02 08:00:00	NVDA	Stock	13.2052	13.6485	13.1625	13.205	5273640.0
2020-10-02 09:00:00	NVDA	Stock	13.2088	13.4622	13.1475	13.4531	71102480.0
2020-10-02 10:00:00	NVDA	Stock	13.4558	13.5195	13.3875	13.442	68462280.0
2020-10-02 11:00:00	NVDA	Stock	13.4445	13.45	13.2	13.2119	61881040.0
2020-10-02 12:00:00	NVDA	Stock	13.2095	13.3258	13.1275	13.2574	66861080.0
2020-10-02 13:00:00	NVDA	Stock	13.256	13.265	13.1645	13.2094	42492880.0
2020-10-02 14:00:00	NVDA	Stock	13.208	13.273	13.1395	13.1985	48073080.0
2020-10-02 15:00:00	NVDA	Stock	13.1972	13.2195	13.051	13.062	71127640.0
2020-10-02 16:00:00	NVDA	Stock	13.0622	13.0738	13.053	13.068	7514240.0
2020-10-02 17:00:00	NVDA	Stock	13.068	13.068	13.0003	13.0038	883920.0
2020-10-02 18:00:00	NVDA	Stock	13.0048	13.0123	13.0	13.0063	403160.0
2020-10-02 19:00:00	NVDA	Stock	13.0105	13.0388	13.01	13.021	335840.0
2020-10-02 04:00:00	AMZN	Stock	158.45	158.6	157.5	158.6	29800.0
2020-10-02 05:00:00	AMZN	Stock	158.0	158.0	158.0	158.0	2420.0

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

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