PREVIEW / stock_1hour / 2020-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-18.parquet
  size:    1.2 MB
  rows:    52,009
  symbols: 2,420

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-02-18 04:00:00	AAPL	Stock	78.2375	78.4725	77.5175	78.25	390780.0
2020-02-18 05:00:00	AAPL	Stock	78.25	78.625	78.18	78.625	224116.0
2020-02-18 06:00:00	AAPL	Stock	78.5875	78.625	78.3525	78.3975	158596.0
2020-02-18 07:00:00	AAPL	Stock	78.375	79.05	78.375	79.025	1203996.0
2020-02-18 08:00:00	AAPL	Stock	78.6	79.935	78.4075	79.4525	2773444.0
2020-02-18 09:00:00	AAPL	Stock	79.44	79.5975	78.6525	79.435	31031836.0
2020-02-18 10:00:00	AAPL	Stock	79.435	79.66	79.1188	79.4525	17996356.0
2020-02-18 11:00:00	AAPL	Stock	79.4475	79.485	78.9	78.9038	13131528.0
2020-02-18 12:00:00	AAPL	Stock	78.9	79.3	78.8025	79.268	13364084.0
2020-02-18 13:00:00	AAPL	Stock	79.268	79.5475	79.265	79.5255	9558240.0
2020-02-18 14:00:00	AAPL	Stock	79.5275	79.9375	79.3925	79.825	10263532.0
2020-02-18 15:00:00	AAPL	Stock	79.8215	79.9225	79.575	79.75	13059368.0
2020-02-18 16:00:00	AAPL	Stock	79.75	79.875	79.7	79.75	10045960.0
2020-02-18 17:00:00	AAPL	Stock	79.7925	79.805	79.765	79.7925	56028.0
2020-02-18 18:00:00	AAPL	Stock	79.7975	79.9	79.79	79.9	87784.0
2020-02-18 19:00:00	AAPL	Stock	79.925	79.9375	79.875	79.9375	112292.0
2020-02-18 04:00:00	MSFT	Stock	184.3	185.0	184.1	184.6	18721.0
2020-02-18 05:00:00	MSFT	Stock	184.7	185.17	184.6	185.1	8985.0
2020-02-18 06:00:00	MSFT	Stock	185.21	185.29	184.99	185.0	10247.0
2020-02-18 07:00:00	MSFT	Stock	184.93	185.15	184.9	184.9	36898.0
2020-02-18 08:00:00	MSFT	Stock	184.95	185.81	184.84	185.1	132027.0
2020-02-18 09:00:00	MSFT	Stock	185.05	186.92	185.0	186.92	4001245.0
2020-02-18 10:00:00	MSFT	Stock	186.91	187.6	186.45	186.81	4150111.0
2020-02-18 11:00:00	MSFT	Stock	186.81	187.03	186.074	186.413	3203414.0
2020-02-18 12:00:00	MSFT	Stock	186.415	186.96	186.2	186.647	1675666.0
2020-02-18 13:00:00	MSFT	Stock	186.64	187.13	186.43	186.55	1650791.0
2020-02-18 14:00:00	MSFT	Stock	186.56	187.49	186.3	187.39	2079427.0
2020-02-18 15:00:00	MSFT	Stock	187.39	187.7	187.129	187.22	3380384.0
2020-02-18 16:00:00	MSFT	Stock	187.23	187.29	186.445	187.23	2521006.0
2020-02-18 17:00:00	MSFT	Stock	187.25	187.45	187.25	187.3	15681.0
2020-02-18 18:00:00	MSFT	Stock	187.28	187.55	187.26	187.55	31199.0
2020-02-18 19:00:00	MSFT	Stock	187.55	187.69	187.55	187.68	26336.0
2020-02-18 04:00:00	NVDA	Stock	7.0	7.0638	6.9255	7.035	633280.0
2020-02-18 05:00:00	NVDA	Stock	7.05	7.1213	7.05	7.1213	191600.0
2020-02-18 06:00:00	NVDA	Stock	7.1088	7.125	7.0892	7.1	245800.0
2020-02-18 07:00:00	NVDA	Stock	7.106	7.1515	7.0875	7.1342	1836000.0
2020-02-18 08:00:00	NVDA	Stock	7.1514	7.2268	7.0952	7.1438	3880080.0
2020-02-18 09:00:00	NVDA	Stock	7.1438	7.2898	7.1215	7.2625	88704320.0
2020-02-18 10:00:00	NVDA	Stock	7.2618	7.2812	7.1938	7.2734	69672600.0
2020-02-18 11:00:00	NVDA	Stock	7.273	7.31	7.2088	7.2312	50182320.0
2020-02-18 12:00:00	NVDA	Stock	7.2302	7.3463	7.225	7.3394	47517520.0
2020-02-18 13:00:00	NVDA	Stock	7.3393	7.3498	7.3085	7.3258	43688920.0
2020-02-18 14:00:00	NVDA	Stock	7.326	7.4115	7.3158	7.4104	70572720.0
2020-02-18 15:00:00	NVDA	Stock	7.4109	7.4328	7.3778	7.4142	105844400.0
2020-02-18 16:00:00	NVDA	Stock	7.4142	7.4875	7.41	7.4142	41904000.0
2020-02-18 17:00:00	NVDA	Stock	7.4688	7.4705	7.4398	7.44	915920.0
2020-02-18 18:00:00	NVDA	Stock	7.4562	7.475	7.4463	7.465	585960.0
2020-02-18 19:00:00	NVDA	Stock	7.4688	7.4832	7.4688	7.483	847160.0
2020-02-18 04:00:00	AMZN	Stock	106.25	106.25	106.1	106.1	18940.0
2020-02-18 05:00:00	AMZN	Stock	106.15	106.2445	106.15	106.15	30000.0

> showing 50 of 52,009 rows — these rows as CSV

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