PREVIEW / stock_1hour / 2020-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-10.parquet
  size:    1.3 MB
  rows:    58,155
  symbols: 2,432

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-10 04:00:00	AAPL	Stock	86.505	86.82	86.505	86.6	44420.0
2020-06-10 05:00:00	AAPL	Stock	86.505	86.505	86.375	86.4125	11848.0
2020-06-10 06:00:00	AAPL	Stock	86.375	86.375	86.0575	86.2625	32332.0
2020-06-10 07:00:00	AAPL	Stock	86.36	87.275	86.33	87.175	548592.0
2020-06-10 08:00:00	AAPL	Stock	86.7992	87.25	86.35	87.1225	740060.0
2020-06-10 09:00:00	AAPL	Stock	87.125	87.8175	86.5225	87.6395	26463968.0
2020-06-10 10:00:00	AAPL	Stock	87.645	87.875	87.1575	87.47	21834052.0
2020-06-10 11:00:00	AAPL	Stock	87.4625	88.21	87.3548	87.98	19913500.0
2020-06-10 12:00:00	AAPL	Stock	88.0015	88.1	87.61	87.9325	9928324.0
2020-06-10 13:00:00	AAPL	Stock	87.9275	88.09	87.8125	87.9	7461728.0
2020-06-10 14:00:00	AAPL	Stock	87.9	88.6925	87.5625	88.1312	21962132.0
2020-06-10 15:00:00	AAPL	Stock	88.1275	88.6625	87.8475	88.1875	20770112.0
2020-06-10 16:00:00	AAPL	Stock	88.21	88.2225	87.785	88.175	6645288.0
2020-06-10 17:00:00	AAPL	Stock	88.1775	88.3525	88.175	88.2475	99248.0
2020-06-10 18:00:00	AAPL	Stock	88.25	88.3525	87.845	87.8875	173572.0
2020-06-10 19:00:00	AAPL	Stock	87.92	87.9675	87.6375	87.75	269368.0
2020-06-10 04:00:00	MSFT	Stock	190.41	190.87	190.41	190.49	2067.0
2020-06-10 05:00:00	MSFT	Stock	190.45	190.45	189.04	189.95	2515.0
2020-06-10 06:00:00	MSFT	Stock	189.85	190.15	189.28	190.15	3562.0
2020-06-10 07:00:00	MSFT	Stock	190.31	190.8	189.75	190.8	55862.0
2020-06-10 08:00:00	MSFT	Stock	190.204	191.66	190.1	191.49	98460.0
2020-06-10 09:00:00	MSFT	Stock	191.59	192.8	191.0	192.73	4188606.0
2020-06-10 10:00:00	MSFT	Stock	192.73	193.97	192.21	193.43	5302388.0
2020-06-10 11:00:00	MSFT	Stock	193.427	193.97	192.98	193.06	2446108.0
2020-06-10 12:00:00	MSFT	Stock	193.08	195.26	192.81	194.991	3875256.0
2020-06-10 13:00:00	MSFT	Stock	194.995	196.38	194.89	195.63	4637697.0
2020-06-10 14:00:00	MSFT	Stock	195.65	197.97	194.75	196.99	6732123.0
2020-06-10 15:00:00	MSFT	Stock	196.991	198.52	196.22	196.84	6843825.0
2020-06-10 16:00:00	MSFT	Stock	196.84	196.94	193.884	196.4	3172493.0
2020-06-10 17:00:00	MSFT	Stock	196.54	196.6	196.21	196.59	15367.0
2020-06-10 18:00:00	MSFT	Stock	196.4	196.8	195.5	195.5	36264.0
2020-06-10 19:00:00	MSFT	Stock	195.5	195.75	195.0	195.26	48524.0
2020-06-10 04:00:00	NVDA	Stock	9.0935	9.0935	9.0935	9.0935	6640.0
2020-06-10 05:00:00	NVDA	Stock	9.06	9.0625	9.06	9.0605	49560.0
2020-06-10 06:00:00	NVDA	Stock	9.05	9.0625	9.025	9.0625	68560.0
2020-06-10 07:00:00	NVDA	Stock	9.07	9.1543	9.0507	9.15	952880.0
2020-06-10 08:00:00	NVDA	Stock	9.1538	9.1914	9.0592	9.145	2364320.0
2020-06-10 09:00:00	NVDA	Stock	9.145	9.3408	9.1375	9.3399	93902520.0
2020-06-10 10:00:00	NVDA	Stock	9.3398	9.5	9.3358	9.417	156127720.0
2020-06-10 11:00:00	NVDA	Stock	9.4178	9.4825	9.3958	9.4058	64267120.0
2020-06-10 12:00:00	NVDA	Stock	9.4082	9.4338	9.3765	9.3912	36754040.0
2020-06-10 13:00:00	NVDA	Stock	9.39	9.39	9.289	9.3037	40857920.0
2020-06-10 14:00:00	NVDA	Stock	9.3	9.4508	9.263	9.3972	65391800.0
2020-06-10 15:00:00	NVDA	Stock	9.393	9.4625	9.3525	9.3635	63556800.0
2020-06-10 16:00:00	NVDA	Stock	9.3635	9.3975	9.3588	9.3728	6136160.0
2020-06-10 17:00:00	NVDA	Stock	9.374	9.385	9.3662	9.3662	156640.0
2020-06-10 18:00:00	NVDA	Stock	9.3743	9.385	9.3338	9.3438	793240.0
2020-06-10 19:00:00	NVDA	Stock	9.3343	9.3345	9.3	9.3245	715360.0
2020-06-10 04:00:00	AMZN	Stock	131.0	131.0	131.0	131.0	2000.0
2020-06-10 06:00:00	AMZN	Stock	130.5	131.0	130.4955	131.0	56780.0

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

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