PREVIEW / stock_1hour / 2020-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-07.parquet
  size:    1.3 MB
  rows:    57,420
  symbols: 2,521

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-07 04:00:00	AAPL	Stock	114.1	114.35	113.9	114.0	75565.0
2020-10-07 05:00:00	AAPL	Stock	114.01	114.13	113.79	113.79	26253.0
2020-10-07 06:00:00	AAPL	Stock	113.66	114.2	113.6	113.97	76174.0
2020-10-07 07:00:00	AAPL	Stock	114.0	114.45	113.98	114.34	553686.0
2020-10-07 08:00:00	AAPL	Stock	114.35	114.74	113.44	114.57	922519.0
2020-10-07 09:00:00	AAPL	Stock	114.57	115.246	113.134	114.65	13899770.0
2020-10-07 10:00:00	AAPL	Stock	114.654	114.93	114.13	114.915	14144684.0
2020-10-07 11:00:00	AAPL	Stock	114.92	115.16	114.67	114.681	10381051.0
2020-10-07 12:00:00	AAPL	Stock	114.69	115.0	114.13	114.967	8987228.0
2020-10-07 13:00:00	AAPL	Stock	114.966	115.55	114.87	115.21	9700862.0
2020-10-07 14:00:00	AAPL	Stock	115.21	115.5	114.99	115.29	8109621.0
2020-10-07 15:00:00	AAPL	Stock	115.295	115.45	114.84	115.05	13497322.0
2020-10-07 16:00:00	AAPL	Stock	115.08	115.1	114.8	114.95	7275050.0
2020-10-07 17:00:00	AAPL	Stock	114.95	115.2	114.95	115.18	213582.0
2020-10-07 18:00:00	AAPL	Stock	115.18	115.3	115.1	115.26	92103.0
2020-10-07 19:00:00	AAPL	Stock	115.29	115.37	115.23	115.37	183590.0
2020-10-07 04:00:00	MSFT	Stock	207.06	207.06	206.8	206.8	645.0
2020-10-07 05:00:00	MSFT	Stock	207.0	207.01	207.0	207.0	624.0
2020-10-07 06:00:00	MSFT	Stock	206.68	207.25	206.68	206.99	2479.0
2020-10-07 07:00:00	MSFT	Stock	207.1	207.29	206.72	207.29	65363.0
2020-10-07 08:00:00	MSFT	Stock	207.0	207.94	206.81	207.64	78476.0
2020-10-07 09:00:00	MSFT	Stock	207.54	208.18	207.01	207.89	2237915.0
2020-10-07 10:00:00	MSFT	Stock	207.895	207.98	206.72	207.653	2676159.0
2020-10-07 11:00:00	MSFT	Stock	207.66	208.51	207.55	208.14	1968840.0
2020-10-07 12:00:00	MSFT	Stock	208.145	208.83	207.31	208.79	1761406.0
2020-10-07 13:00:00	MSFT	Stock	208.8	209.91	208.783	209.39	1827286.0
2020-10-07 14:00:00	MSFT	Stock	209.4	210.11	209.17	209.74	1633421.0
2020-10-07 15:00:00	MSFT	Stock	209.74	210.0	209.13	209.81	4088493.0
2020-10-07 16:00:00	MSFT	Stock	209.81	209.83	209.19	209.35	5419764.0
2020-10-07 17:00:00	MSFT	Stock	209.4	209.46	209.39	209.45	4972.0
2020-10-07 18:00:00	MSFT	Stock	209.45	209.74	209.2	209.7	13803.0
2020-10-07 19:00:00	MSFT	Stock	209.47	209.83	209.25	209.8	18912.0
2020-10-07 04:00:00	NVDA	Stock	13.8538	13.9398	13.8538	13.9292	112440.0
2020-10-07 05:00:00	NVDA	Stock	13.9225	13.9278	13.9225	13.9262	17880.0
2020-10-07 06:00:00	NVDA	Stock	13.9212	13.9375	13.9	13.9	149560.0
2020-10-07 07:00:00	NVDA	Stock	13.9365	13.995	13.9078	13.995	1600000.0
2020-10-07 08:00:00	NVDA	Stock	13.95	13.991	13.9005	13.9638	2921360.0
2020-10-07 09:00:00	NVDA	Stock	13.9628	14.1192	13.7333	14.0196	84336760.0
2020-10-07 10:00:00	NVDA	Stock	14.0203	14.0312	13.8635	13.9386	86852800.0
2020-10-07 11:00:00	NVDA	Stock	13.9386	13.9863	13.9015	13.9502	36760360.0
2020-10-07 12:00:00	NVDA	Stock	13.9488	14.0125	13.9138	13.9406	36105640.0
2020-10-07 13:00:00	NVDA	Stock	13.9422	14.0188	13.9295	13.9756	28399440.0
2020-10-07 14:00:00	NVDA	Stock	13.9795	13.999	13.926	13.9415	24327000.0
2020-10-07 15:00:00	NVDA	Stock	13.9405	13.977	13.8908	13.964	43307520.0
2020-10-07 16:00:00	NVDA	Stock	13.964	13.964	13.9208	13.95	5411200.0
2020-10-07 17:00:00	NVDA	Stock	13.95	13.9795	13.944	13.9775	468880.0
2020-10-07 18:00:00	NVDA	Stock	13.975	14.0072	13.975	14.0005	582120.0
2020-10-07 19:00:00	NVDA	Stock	14.006	14.0198	13.9952	14.0198	451640.0
2020-10-07 04:00:00	AMZN	Stock	156.012	156.0165	156.012	156.0165	7440.0
2020-10-07 05:00:00	AMZN	Stock	155.95	155.95	155.95	155.95	2860.0

> showing 50 of 57,420 rows — these rows as CSV

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