PREVIEW / stock_1hour / 2020-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-16.parquet
  size:    1.3 MB
  rows:    58,209
  symbols: 2,419

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-16 04:00:00	AAPL	Stock	86.575	86.9075	86.575	86.9	51224.0
2020-06-16 05:00:00	AAPL	Stock	86.835	87.0675	86.5025	86.8	83672.0
2020-06-16 06:00:00	AAPL	Stock	86.7975	87.115	86.7975	86.8875	46100.0
2020-06-16 07:00:00	AAPL	Stock	86.82	87.375	86.6875	87.2875	471808.0
2020-06-16 08:00:00	AAPL	Stock	86.775	88.125	86.6925	87.762	1165452.0
2020-06-16 09:00:00	AAPL	Stock	87.76	88.255	87.2625	87.9538	21632360.0
2020-06-16 10:00:00	AAPL	Stock	87.95	88.1425	86.54	86.625	21867788.0
2020-06-16 11:00:00	AAPL	Stock	86.5775	87.905	86.18	87.595	19634856.0
2020-06-16 12:00:00	AAPL	Stock	87.61	87.9975	87.2825	87.7675	12686384.0
2020-06-16 13:00:00	AAPL	Stock	87.79	88.0	87.6825	87.8725	10826372.0
2020-06-16 14:00:00	AAPL	Stock	87.8718	88.3	87.6975	87.8348	14737088.0
2020-06-16 15:00:00	AAPL	Stock	87.83	88.08	87.2925	88.065	19045788.0
2020-06-16 16:00:00	AAPL	Stock	88.02	88.15	87.7025	88.0625	9650796.0
2020-06-16 17:00:00	AAPL	Stock	88.0275	88.075	87.575	87.7475	85944.0
2020-06-16 18:00:00	AAPL	Stock	87.75	88.0825	87.625	88.0725	93604.0
2020-06-16 19:00:00	AAPL	Stock	88.08	88.25	88.0	88.1875	154460.0
2020-06-16 04:00:00	MSFT	Stock	191.35	191.61	191.0	191.61	6509.0
2020-06-16 05:00:00	MSFT	Stock	191.84	192.26	191.58	191.91	8419.0
2020-06-16 06:00:00	MSFT	Stock	192.16	192.89	192.16	192.29	7046.0
2020-06-16 07:00:00	MSFT	Stock	191.75	192.3	191.4	191.94	33941.0
2020-06-16 08:00:00	MSFT	Stock	191.75	193.88	191.4	193.61	167674.0
2020-06-16 09:00:00	MSFT	Stock	193.67	194.49	192.28	193.86	4644149.0
2020-06-16 10:00:00	MSFT	Stock	193.88	195.58	192.11	192.28	6344826.0
2020-06-16 11:00:00	MSFT	Stock	192.3	194.59	191.46	193.88	5076818.0
2020-06-16 12:00:00	MSFT	Stock	193.9	194.13	192.82	193.89	3076005.0
2020-06-16 13:00:00	MSFT	Stock	193.885	194.11	192.93	193.2	2397898.0
2020-06-16 14:00:00	MSFT	Stock	193.2	193.63	192.22	192.977	3426254.0
2020-06-16 15:00:00	MSFT	Stock	192.96	193.93	191.5	193.67	6273344.0
2020-06-16 16:00:00	MSFT	Stock	193.83	193.95	193.48	193.84	4544507.0
2020-06-16 17:00:00	MSFT	Stock	193.84	193.84	193.1	193.16	26832.0
2020-06-16 18:00:00	MSFT	Stock	193.34	193.84	193.1	193.84	28986.0
2020-06-16 19:00:00	MSFT	Stock	193.83	194.58	193.74	194.58	34856.0
2020-06-16 04:00:00	NVDA	Stock	9.1738	9.1948	9.1613	9.1615	58200.0
2020-06-16 05:00:00	NVDA	Stock	9.1715	9.1778	9.156	9.175	83280.0
2020-06-16 06:00:00	NVDA	Stock	9.2	9.2	9.1502	9.165	105960.0
2020-06-16 07:00:00	NVDA	Stock	9.1948	9.238	9.1725	9.2	1457440.0
2020-06-16 08:00:00	NVDA	Stock	9.195	9.2482	9.185	9.2408	3185480.0
2020-06-16 09:00:00	NVDA	Stock	9.2438	9.275	9.0462	9.0492	91808000.0
2020-06-16 10:00:00	NVDA	Stock	9.049	9.109	8.8922	8.8955	114820880.0
2020-06-16 11:00:00	NVDA	Stock	8.897	9.0502	8.8388	9.0242	52879520.0
2020-06-16 12:00:00	NVDA	Stock	9.0288	9.0702	8.9875	9.0382	36406880.0
2020-06-16 13:00:00	NVDA	Stock	9.0363	9.049	8.9875	9.0138	29957520.0
2020-06-16 14:00:00	NVDA	Stock	9.0138	9.0522	8.9825	9.014	34642960.0
2020-06-16 15:00:00	NVDA	Stock	9.0135	9.0732	8.9421	9.073	74954200.0
2020-06-16 16:00:00	NVDA	Stock	9.0685	9.09	9.0608	9.0688	6739960.0
2020-06-16 17:00:00	NVDA	Stock	9.0675	9.0675	9.0398	9.05	300480.0
2020-06-16 18:00:00	NVDA	Stock	9.05	9.0738	9.0432	9.0738	234400.0
2020-06-16 19:00:00	NVDA	Stock	9.075	9.0845	9.07	9.0845	337160.0
2020-06-16 04:00:00	AMZN	Stock	130.2055	130.2055	130.2055	130.2055	2000.0
2020-06-16 05:00:00	AMZN	Stock	130.2	130.2	130.2	130.2	3120.0

> showing 50 of 58,209 rows — these rows as CSV

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