PREVIEW / stock_1hour / 2021-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-11.parquet
  size:    1.5 MB
  rows:    70,239
  symbols: 2,809

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
2021-02-11 04:00:00	AAPL	Stock	135.44	135.63	135.25	135.6	18504.0
2021-02-11 05:00:00	AAPL	Stock	135.6	135.75	135.6	135.75	5704.0
2021-02-11 06:00:00	AAPL	Stock	135.7	135.82	135.68	135.78	8566.0
2021-02-11 07:00:00	AAPL	Stock	135.73	135.8	135.29	135.52	164547.0
2021-02-11 08:00:00	AAPL	Stock	135.53	135.84	135.3	135.6	309259.0
2021-02-11 09:00:00	AAPL	Stock	135.6	136.39	135.0	135.04	9307066.0
2021-02-11 10:00:00	AAPL	Stock	135.05	135.54	134.92	135.106	8362053.0
2021-02-11 11:00:00	AAPL	Stock	135.12	135.22	134.75	134.9	4909231.0
2021-02-11 12:00:00	AAPL	Stock	134.91	135.0	133.88	134.28	7698254.0
2021-02-11 13:00:00	AAPL	Stock	134.285	134.39	133.96	134.185	3928698.0
2021-02-11 14:00:00	AAPL	Stock	134.18	134.34	133.77	134.335	5891749.0
2021-02-11 15:00:00	AAPL	Stock	134.335	135.28	134.3	135.12	8232664.0
2021-02-11 16:00:00	AAPL	Stock	135.12	135.23	134.85	134.95	4605424.0
2021-02-11 17:00:00	AAPL	Stock	134.95	135.13	134.8	134.9	143675.0
2021-02-11 18:00:00	AAPL	Stock	134.84	134.99	134.8	134.96	45785.0
2021-02-11 19:00:00	AAPL	Stock	134.94	134.98	134.81	134.91	74215.0
2021-02-11 04:00:00	MSFT	Stock	243.22	244.0	243.22	244.0	2485.0
2021-02-11 05:00:00	MSFT	Stock	243.84	244.08	243.84	244.02	3985.0
2021-02-11 06:00:00	MSFT	Stock	243.79	243.99	243.79	243.98	1669.0
2021-02-11 07:00:00	MSFT	Stock	243.55	243.8	243.42	243.75	23902.0
2021-02-11 08:00:00	MSFT	Stock	243.77	244.25	243.51	244.0	40363.0
2021-02-11 09:00:00	MSFT	Stock	244.02	245.15	242.6	242.625	1739336.0
2021-02-11 10:00:00	MSFT	Stock	242.65	243.84	242.6	243.17	1529814.0
2021-02-11 11:00:00	MSFT	Stock	243.18	243.82	242.86	243.459	982821.0
2021-02-11 12:00:00	MSFT	Stock	243.46	243.71	242.19	242.86	1209282.0
2021-02-11 13:00:00	MSFT	Stock	242.86	243.5	242.54	243.08	824412.0
2021-02-11 14:00:00	MSFT	Stock	243.09	243.47	242.15	243.409	894088.0
2021-02-11 15:00:00	MSFT	Stock	243.39	244.75	243.275	244.52	2252640.0
2021-02-11 16:00:00	MSFT	Stock	244.49	245.0	244.11	244.55	2915663.0
2021-02-11 17:00:00	MSFT	Stock	244.48	244.6	244.4	244.4	41933.0
2021-02-11 18:00:00	MSFT	Stock	244.48	244.6	244.2	244.5	1181.0
2021-02-11 19:00:00	MSFT	Stock	244.7	244.77	244.2	244.2	4985.0
2021-02-11 04:00:00	NVDA	Stock	14.8875	14.8875	14.8875	14.8875	4000.0
2021-02-11 05:00:00	NVDA	Stock	14.9438	15.0012	14.9285	14.9625	260360.0
2021-02-11 06:00:00	NVDA	Stock	14.9492	14.9492	14.925	14.9425	51440.0
2021-02-11 07:00:00	NVDA	Stock	14.9262	14.9262	14.84	14.895	530120.0
2021-02-11 08:00:00	NVDA	Stock	14.9125	14.9625	14.84	14.958	1740760.0
2021-02-11 09:00:00	NVDA	Stock	14.9562	15.1465	14.925	15.0325	73499400.0
2021-02-11 10:00:00	NVDA	Stock	15.0325	15.2512	15.0303	15.1622	77216880.0
2021-02-11 11:00:00	NVDA	Stock	15.1658	15.2722	15.1368	15.2002	43467880.0
2021-02-11 12:00:00	NVDA	Stock	15.2002	15.2375	14.9876	15.135	52369800.0
2021-02-11 13:00:00	NVDA	Stock	15.1333	15.2708	15.0675	15.2205	34616440.0
2021-02-11 14:00:00	NVDA	Stock	15.218	15.2188	15.1002	15.1445	33329160.0
2021-02-11 15:00:00	NVDA	Stock	15.143	15.2645	15.1186	15.2553	46380560.0
2021-02-11 16:00:00	NVDA	Stock	15.2531	15.325	15.2508	15.2782	14830040.0
2021-02-11 17:00:00	NVDA	Stock	15.275	15.2868	15.25	15.25	587040.0
2021-02-11 18:00:00	NVDA	Stock	15.25	15.275	15.2368	15.275	837560.0
2021-02-11 19:00:00	NVDA	Stock	15.275	15.3175	15.2602	15.3175	614960.0
2021-02-11 04:00:00	AMZN	Stock	164.735	164.9275	164.735	164.9275	8900.0
2021-02-11 05:00:00	AMZN	Stock	164.85	164.85	164.85	164.85	9360.0

> showing 50 of 70,239 rows — these rows as CSV

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