PREVIEW / stock_1hour / 2020-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-30.parquet
  size:    1.3 MB
  rows:    57,344
  symbols: 2,502

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-09-30 04:00:00	AAPL	Stock	113.1	113.4	112.72	113.26	34925.0
2020-09-30 05:00:00	AAPL	Stock	113.26	113.27	112.44	113.07	24295.0
2020-09-30 06:00:00	AAPL	Stock	113.06	113.71	112.76	113.5	20351.0
2020-09-30 07:00:00	AAPL	Stock	113.49	113.63	113.12	113.2	228277.0
2020-09-30 08:00:00	AAPL	Stock	113.49	114.37	113.08	114.03	763160.0
2020-09-30 09:00:00	AAPL	Stock	114.01	115.86	113.6	115.76	13440168.0
2020-09-30 10:00:00	AAPL	Stock	115.74	116.49	115.32	116.17	21271093.0
2020-09-30 11:00:00	AAPL	Stock	116.155	116.695	115.71	116.58	14526325.0
2020-09-30 12:00:00	AAPL	Stock	116.58	116.89	116.05	116.24	9538541.0
2020-09-30 13:00:00	AAPL	Stock	116.24	116.97	115.78	116.82	10212225.0
2020-09-30 14:00:00	AAPL	Stock	116.83	117.26	115.67	116.374	18460400.0
2020-09-30 15:00:00	AAPL	Stock	116.37	116.65	114.96	115.61	24836178.0
2020-09-30 16:00:00	AAPL	Stock	115.79	115.982	115.19	115.33	15889951.0
2020-09-30 17:00:00	AAPL	Stock	115.3	115.6	115.3	115.57	129478.0
2020-09-30 18:00:00	AAPL	Stock	115.59	116.15	115.59	116.05	200793.0
2020-09-30 19:00:00	AAPL	Stock	116.09	116.3	116.01	116.3	182948.0
2020-09-30 04:00:00	MSFT	Stock	205.45	206.27	205.15	206.27	5875.0
2020-09-30 05:00:00	MSFT	Stock	205.63	205.7	204.78	205.7	4159.0
2020-09-30 06:00:00	MSFT	Stock	205.79	206.91	205.79	206.91	1071.0
2020-09-30 07:00:00	MSFT	Stock	206.37	206.6	206.0	206.0	19376.0
2020-09-30 08:00:00	MSFT	Stock	206.37	207.5	205.97	207.26	37729.0
2020-09-30 09:00:00	MSFT	Stock	207.01	208.48	206.54	208.4	2540344.0
2020-09-30 10:00:00	MSFT	Stock	208.404	209.79	207.89	209.168	2844379.0
2020-09-30 11:00:00	MSFT	Stock	209.15	211.8	209.02	211.44	3288729.0
2020-09-30 12:00:00	MSFT	Stock	211.445	211.98	210.61	210.85	2131421.0
2020-09-30 13:00:00	MSFT	Stock	210.84	211.66	209.95	211.62	2013039.0
2020-09-30 14:00:00	MSFT	Stock	211.6	211.96	209.46	210.542	3321121.0
2020-09-30 15:00:00	MSFT	Stock	210.53	211.295	208.53	210.32	5520728.0
2020-09-30 16:00:00	MSFT	Stock	210.95	210.95	209.0	209.0	6797628.0
2020-09-30 17:00:00	MSFT	Stock	209.34	209.91	209.16	209.91	28511.0
2020-09-30 18:00:00	MSFT	Stock	209.91	210.72	209.91	210.69	15234.0
2020-09-30 19:00:00	MSFT	Stock	210.72	211.35	210.7	210.7	14122.0
2020-09-30 04:00:00	NVDA	Stock	13.175	13.175	13.0275	13.075	83280.0
2020-09-30 05:00:00	NVDA	Stock	13.0748	13.075	13.0673	13.0673	14600.0
2020-09-30 06:00:00	NVDA	Stock	13.0875	13.1625	13.0625	13.1625	112040.0
2020-09-30 07:00:00	NVDA	Stock	13.15	13.1575	13.1278	13.1278	425920.0
2020-09-30 08:00:00	NVDA	Stock	13.1175	13.235	13.1063	13.225	1540600.0
2020-09-30 09:00:00	NVDA	Stock	13.2135	13.4765	13.1352	13.4628	92687240.0
2020-09-30 10:00:00	NVDA	Stock	13.4605	13.6102	13.4	13.5528	109714160.0
2020-09-30 11:00:00	NVDA	Stock	13.5519	13.6055	13.5125	13.5651	58414800.0
2020-09-30 12:00:00	NVDA	Stock	13.5672	13.6213	13.4883	13.535	55803920.0
2020-09-30 13:00:00	NVDA	Stock	13.5337	13.5875	13.4648	13.5801	40814600.0
2020-09-30 14:00:00	NVDA	Stock	13.5805	13.6225	13.4678	13.5728	88903080.0
2020-09-30 15:00:00	NVDA	Stock	13.57	13.618	13.4278	13.5224	119280240.0
2020-09-30 16:00:00	NVDA	Stock	13.5562	13.5562	13.4925	13.4993	39681160.0
2020-09-30 17:00:00	NVDA	Stock	13.5	13.515	13.496	13.5132	1175120.0
2020-09-30 18:00:00	NVDA	Stock	13.512	13.5625	13.512	13.5625	436480.0
2020-09-30 19:00:00	NVDA	Stock	13.5695	13.592	13.5675	13.592	398160.0
2020-09-30 04:00:00	AMZN	Stock	156.2	156.318	156.2	156.318	11460.0
2020-09-30 05:00:00	AMZN	Stock	155.8005	155.8005	155.8005	155.8005	7420.0

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

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