PREVIEW / stock_1hour / 2021-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-17.parquet
  size:    1.5 MB
  rows:    69,995
  symbols: 2,822

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-17 04:00:00	AAPL	Stock	133.0	133.0	132.51	132.58	27974.0
2021-02-17 05:00:00	AAPL	Stock	132.55	132.67	132.3	132.45	14060.0
2021-02-17 06:00:00	AAPL	Stock	132.5	132.66	132.37	132.52	11317.0
2021-02-17 07:00:00	AAPL	Stock	132.63	132.67	132.1	132.34	338620.0
2021-02-17 08:00:00	AAPL	Stock	132.3	133.19	131.33	131.64	797631.0
2021-02-17 09:00:00	AAPL	Stock	131.64	133.256	130.81	130.829	14729477.0
2021-02-17 10:00:00	AAPL	Stock	130.83	131.038	129.89	130.879	19340686.0
2021-02-17 11:00:00	AAPL	Stock	130.87	130.99	129.47	130.25	14114220.0
2021-02-17 12:00:00	AAPL	Stock	130.25	130.42	129.69	130.385	7484584.0
2021-02-17 13:00:00	AAPL	Stock	130.381	130.66	130.17	130.51	5432075.0
2021-02-17 14:00:00	AAPL	Stock	130.51	130.74	130.25	130.345	5302233.0
2021-02-17 15:00:00	AAPL	Stock	130.35	130.99	130.26	130.84	9686033.0
2021-02-17 16:00:00	AAPL	Stock	130.84	131.0	130.7	130.83	4571749.0
2021-02-17 17:00:00	AAPL	Stock	130.81	130.95	130.73	130.84	67333.0
2021-02-17 18:00:00	AAPL	Stock	130.83	130.86	130.7	130.79	61699.0
2021-02-17 19:00:00	AAPL	Stock	130.77	130.89	130.75	130.88	65157.0
2021-02-17 04:00:00	MSFT	Stock	243.22	243.22	243.2	243.2	1097.0
2021-02-17 05:00:00	MSFT	Stock	243.13	243.21	243.13	243.21	819.0
2021-02-17 06:00:00	MSFT	Stock	243.12	243.13	243.0	243.13	1682.0
2021-02-17 07:00:00	MSFT	Stock	243.0	243.25	242.66	243.0	16280.0
2021-02-17 08:00:00	MSFT	Stock	242.75	243.14	241.69	242.06	47580.0
2021-02-17 09:00:00	MSFT	Stock	242.1	243.261	240.65	242.25	2269073.0
2021-02-17 10:00:00	MSFT	Stock	242.29	242.92	241.081	242.65	1776294.0
2021-02-17 11:00:00	MSFT	Stock	242.63	242.91	241.31	242.09	1273973.0
2021-02-17 12:00:00	MSFT	Stock	242.08	242.88	242.02	242.72	866842.0
2021-02-17 13:00:00	MSFT	Stock	242.735	243.4	242.68	243.15	1005002.0
2021-02-17 14:00:00	MSFT	Stock	243.16	243.78	243.047	243.28	921997.0
2021-02-17 15:00:00	MSFT	Stock	243.25	244.31	243.23	244.26	1735685.0
2021-02-17 16:00:00	MSFT	Stock	244.2	244.2	243.96	244.17	3777797.0
2021-02-17 17:00:00	MSFT	Stock	244.2	244.2	244.1	244.15	4382.0
2021-02-17 18:00:00	MSFT	Stock	244.22	244.23	244.05	244.2	2856.0
2021-02-17 19:00:00	MSFT	Stock	244.2	244.3	244.15	244.16	12996.0
2021-02-17 04:00:00	NVDA	Stock	15.2812	15.2812	15.2812	15.2812	12560.0
2021-02-17 06:00:00	NVDA	Stock	15.2812	15.2812	15.2812	15.2812	10240.0
2021-02-17 07:00:00	NVDA	Stock	15.2875	15.3	15.2762	15.3	102680.0
2021-02-17 08:00:00	NVDA	Stock	15.2769	15.3125	15.1455	15.1463	1170760.0
2021-02-17 09:00:00	NVDA	Stock	15.1375	15.2235	14.9629	15.0758	34876440.0
2021-02-17 10:00:00	NVDA	Stock	15.0812	15.1125	14.8512	14.9768	45832320.0
2021-02-17 11:00:00	NVDA	Stock	14.9791	14.99	14.78	14.8568	38258560.0
2021-02-17 12:00:00	NVDA	Stock	14.8608	14.9625	14.855	14.916	18991880.0
2021-02-17 13:00:00	NVDA	Stock	14.9198	15.0273	14.9075	14.93	17487840.0
2021-02-17 14:00:00	NVDA	Stock	14.9432	14.9966	14.8388	14.8805	21886600.0
2021-02-17 15:00:00	NVDA	Stock	14.879	14.9676	14.8782	14.906	27857360.0
2021-02-17 16:00:00	NVDA	Stock	14.906	14.9438	14.8875	14.9438	1738920.0
2021-02-17 17:00:00	NVDA	Stock	14.9312	14.935	14.8815	14.8815	309200.0
2021-02-17 18:00:00	NVDA	Stock	14.8863	14.9125	14.8825	14.9125	93840.0
2021-02-17 19:00:00	NVDA	Stock	14.912	14.95	14.912	14.95	285000.0
2021-02-17 07:00:00	AMZN	Stock	163.45	163.75	163.45	163.75	45460.0
2021-02-17 08:00:00	AMZN	Stock	163.75	163.98	163.0	163.12	163360.0
2021-02-17 09:00:00	AMZN	Stock	163.0	164.725	162.7	164.3615	8174860.0

> showing 50 of 69,995 rows — these rows as CSV

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