PREVIEW / stock_1hour / 2019-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-19.parquet
  size:    1.1 MB
  rows:    50,428
  symbols: 2,511

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
2019-11-19 04:00:00	AAPL	Stock	67.0	67.08	66.95	67.075	34408.0
2019-11-19 05:00:00	AAPL	Stock	67.06	67.1	67.0375	67.0875	46804.0
2019-11-19 06:00:00	AAPL	Stock	67.0525	67.14	67.0525	67.0825	56912.0
2019-11-19 07:00:00	AAPL	Stock	67.0825	67.12	66.98	67.0175	158004.0
2019-11-19 08:00:00	AAPL	Stock	67.05	67.1112	66.9375	66.9748	377032.0
2019-11-19 09:00:00	AAPL	Stock	66.9775	67.0225	66.645	66.7225	10227380.0
2019-11-19 10:00:00	AAPL	Stock	66.7148	67.0	66.4115	66.413	11769212.0
2019-11-19 11:00:00	AAPL	Stock	66.4142	66.715	66.3482	66.5975	7785460.0
2019-11-19 12:00:00	AAPL	Stock	66.5975	66.63	66.4525	66.4745	4255316.0
2019-11-19 13:00:00	AAPL	Stock	66.4738	66.6262	66.4175	66.5975	3754204.0
2019-11-19 14:00:00	AAPL	Stock	66.6	66.7938	66.6	66.6952	5159044.0
2019-11-19 15:00:00	AAPL	Stock	66.695	66.7625	66.4875	66.5725	6852528.0
2019-11-19 16:00:00	AAPL	Stock	66.5725	66.5875	66.5225	66.56	12663896.0
2019-11-19 17:00:00	AAPL	Stock	66.5725	66.5725	66.5	66.505	98624.0
2019-11-19 18:00:00	AAPL	Stock	66.505	66.5125	66.3625	66.375	84220.0
2019-11-19 19:00:00	AAPL	Stock	66.4	66.4875	66.4	66.4425	35132.0
2019-11-19 04:00:00	MSFT	Stock	150.67	151.04	150.67	151.04	4045.0
2019-11-19 05:00:00	MSFT	Stock	151.05	151.05	150.97	151.04	3381.0
2019-11-19 06:00:00	MSFT	Stock	151.05	151.14	150.92	150.95	4406.0
2019-11-19 07:00:00	MSFT	Stock	150.99	151.02	150.84	150.96	9280.0
2019-11-19 08:00:00	MSFT	Stock	150.9	151.08	150.81	150.85	25009.0
2019-11-19 09:00:00	MSFT	Stock	150.9	151.13	150.195	150.34	2682537.0
2019-11-19 10:00:00	MSFT	Stock	150.34	151.07	150.27	150.447	2615009.0
2019-11-19 11:00:00	MSFT	Stock	150.44	151.27	150.275	151.07	2532166.0
2019-11-19 12:00:00	MSFT	Stock	151.06	151.33	150.86	150.99	1448914.0
2019-11-19 13:00:00	MSFT	Stock	150.99	151.0	150.69	150.711	1242055.0
2019-11-19 14:00:00	MSFT	Stock	150.715	150.88	150.39	150.405	1676002.0
2019-11-19 15:00:00	MSFT	Stock	150.41	150.615	150.22	150.39	3174332.0
2019-11-19 16:00:00	MSFT	Stock	150.39	150.495	150.31	150.34	4698943.0
2019-11-19 17:00:00	MSFT	Stock	150.3	150.36	150.25	150.31	6158.0
2019-11-19 18:00:00	MSFT	Stock	150.28	150.33	150.05	150.05	24786.0
2019-11-19 19:00:00	MSFT	Stock	150.05	150.3	150.05	150.24	15856.0
2019-11-19 04:00:00	NVDA	Stock	5.3255	5.3325	5.3255	5.3325	29960.0
2019-11-19 05:00:00	NVDA	Stock	5.3345	5.3383	5.3345	5.3383	16000.0
2019-11-19 06:00:00	NVDA	Stock	5.3388	5.3388	5.2915	5.2915	343040.0
2019-11-19 07:00:00	NVDA	Stock	5.3108	5.3108	5.2655	5.2892	1281440.0
2019-11-19 08:00:00	NVDA	Stock	5.2938	5.3123	5.2688	5.2895	1371080.0
2019-11-19 09:00:00	NVDA	Stock	5.295	5.2995	5.1902	5.2039	82737720.0
2019-11-19 10:00:00	NVDA	Stock	5.2045	5.2102	5.1412	5.1545	112014680.0
2019-11-19 11:00:00	NVDA	Stock	5.153	5.2235	5.153	5.22	50791160.0
2019-11-19 12:00:00	NVDA	Stock	5.22	5.223	5.1862	5.201	30747160.0
2019-11-19 13:00:00	NVDA	Stock	5.2013	5.2138	5.188	5.19	21579480.0
2019-11-19 14:00:00	NVDA	Stock	5.1905	5.2208	5.1905	5.2056	22070960.0
2019-11-19 15:00:00	NVDA	Stock	5.206	5.215	5.194	5.2	34640040.0
2019-11-19 16:00:00	NVDA	Stock	5.1998	5.2022	5.1915	5.1988	15568880.0
2019-11-19 17:00:00	NVDA	Stock	5.1975	5.1995	5.195	5.1968	305720.0
2019-11-19 18:00:00	NVDA	Stock	5.1958	5.1995	5.1875	5.1912	880360.0
2019-11-19 19:00:00	NVDA	Stock	5.1912	5.1973	5.1882	5.1938	280800.0
2019-11-19 04:00:00	AMZN	Stock	87.8465	87.8465	87.8465	87.8465	2220.0
2019-11-19 07:00:00	AMZN	Stock	87.916	87.95	87.8135	87.9	85820.0

> showing 50 of 50,428 rows — these rows as CSV

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