PREVIEW / stock_1hour / 2020-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-11.parquet
  size:    1.3 MB
  rows:    60,292
  symbols: 2,434

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-06-11 04:00:00	AAPL	Stock	87.235	87.235	86.6025	86.7975	98076.0
2020-06-11 05:00:00	AAPL	Stock	86.755	87.3	86.7475	87.275	34852.0
2020-06-11 06:00:00	AAPL	Stock	87.2675	87.2675	87.025	87.08	35328.0
2020-06-11 07:00:00	AAPL	Stock	87.0575	87.225	86.7175	86.8925	663464.0
2020-06-11 08:00:00	AAPL	Stock	86.9235	87.225	86.55	87.0	1079896.0
2020-06-11 09:00:00	AAPL	Stock	87.0	87.7425	86.6492	87.2625	21551312.0
2020-06-11 10:00:00	AAPL	Stock	87.2675	87.765	86.85	86.95	17156000.0
2020-06-11 11:00:00	AAPL	Stock	86.945	87.5125	86.7338	87.0688	17554860.0
2020-06-11 12:00:00	AAPL	Stock	87.065	87.085	84.8675	85.0938	23272172.0
2020-06-11 13:00:00	AAPL	Stock	85.0875	86.18	84.96	85.69	16842316.0
2020-06-11 14:00:00	AAPL	Stock	85.6925	85.6925	84.5575	84.7875	16323988.0
2020-06-11 15:00:00	AAPL	Stock	84.7775	85.05	83.87	83.9925	31334004.0
2020-06-11 16:00:00	AAPL	Stock	83.95	84.425	83.95	84.275	14318808.0
2020-06-11 17:00:00	AAPL	Stock	84.2675	84.4575	84.125	84.4475	128620.0
2020-06-11 18:00:00	AAPL	Stock	84.4125	84.6675	84.2	84.6675	183080.0
2020-06-11 19:00:00	AAPL	Stock	84.7075	85.1825	84.515	85.1825	314900.0
2020-06-11 04:00:00	MSFT	Stock	194.48	194.8	193.27	193.4	20436.0
2020-06-11 05:00:00	MSFT	Stock	193.3	194.39	193.3	194.14	12252.0
2020-06-11 06:00:00	MSFT	Stock	194.14	194.54	193.82	193.91	24935.0
2020-06-11 07:00:00	MSFT	Stock	194.0	194.4	192.15	193.57	164140.0
2020-06-11 08:00:00	MSFT	Stock	193.95	194.39	192.3	193.92	230014.0
2020-06-11 09:00:00	MSFT	Stock	193.9	195.015	191.0	194.93	5908809.0
2020-06-11 10:00:00	MSFT	Stock	194.935	195.76	193.05	193.28	5390249.0
2020-06-11 11:00:00	MSFT	Stock	193.28	193.86	192.11	192.66	4582214.0
2020-06-11 12:00:00	MSFT	Stock	192.64	192.72	188.2	188.61	5480597.0
2020-06-11 13:00:00	MSFT	Stock	188.62	190.63	188.4	189.6	3797617.0
2020-06-11 14:00:00	MSFT	Stock	189.61	189.62	187.54	188.13	4340393.0
2020-06-11 15:00:00	MSFT	Stock	188.13	189.0	186.07	186.23	9065039.0
2020-06-11 16:00:00	MSFT	Stock	186.25	190.1	186.1	186.81	5826196.0
2020-06-11 17:00:00	MSFT	Stock	186.82	187.4	186.7	187.25	30920.0
2020-06-11 18:00:00	MSFT	Stock	187.02	187.49	186.08	187.31	26939.0
2020-06-11 19:00:00	MSFT	Stock	187.48	188.43	187.15	188.43	42544.0
2020-06-11 04:00:00	NVDA	Stock	9.222	9.222	9.1505	9.1525	181600.0
2020-06-11 05:00:00	NVDA	Stock	9.152	9.2118	9.152	9.2118	24960.0
2020-06-11 06:00:00	NVDA	Stock	9.2198	9.225	9.2198	9.2222	28440.0
2020-06-11 07:00:00	NVDA	Stock	9.2	9.2322	9.1545	9.175	1607000.0
2020-06-11 08:00:00	NVDA	Stock	9.2	9.2148	9.128	9.1625	5631960.0
2020-06-11 09:00:00	NVDA	Stock	9.155	9.2025	9.0091	9.1945	82822440.0
2020-06-11 10:00:00	NVDA	Stock	9.1956	9.2612	9.1085	9.1218	79920040.0
2020-06-11 11:00:00	NVDA	Stock	9.1235	9.1673	9.0365	9.0915	53891320.0
2020-06-11 12:00:00	NVDA	Stock	9.0911	9.1031	8.9452	8.962	48374360.0
2020-06-11 13:00:00	NVDA	Stock	8.959	9.075	8.9515	9.0209	41785440.0
2020-06-11 14:00:00	NVDA	Stock	9.0172	9.0185	8.851	8.886	59890000.0
2020-06-11 15:00:00	NVDA	Stock	8.885	8.9438	8.786	8.794	95683800.0
2020-06-11 16:00:00	NVDA	Stock	8.7958	8.8243	8.7878	8.8118	39447120.0
2020-06-11 17:00:00	NVDA	Stock	8.8125	8.8375	8.807	8.825	480480.0
2020-06-11 18:00:00	NVDA	Stock	8.8043	8.875	8.8	8.875	432800.0
2020-06-11 19:00:00	NVDA	Stock	8.8948	8.9465	8.8752	8.935	976520.0
2020-06-11 04:00:00	AMZN	Stock	130.505	130.505	130.505	130.505	2840.0
2020-06-11 05:00:00	AMZN	Stock	130.6195	131.1235	130.6195	131.1235	20380.0

> showing 50 of 60,292 rows — these rows as CSV

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