PREVIEW / stock_1hour / 2021-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-19.parquet
  size:    1.5 MB
  rows:    69,081
  symbols: 2,831

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-19 04:00:00	AAPL	Stock	129.75	130.15	129.48	129.97	37269.0
2021-02-19 05:00:00	AAPL	Stock	129.98	130.26	129.85	130.26	21750.0
2021-02-19 06:00:00	AAPL	Stock	130.31	130.39	130.0	130.0	34044.0
2021-02-19 07:00:00	AAPL	Stock	130.0	130.8	129.9	130.62	213163.0
2021-02-19 08:00:00	AAPL	Stock	130.13	130.8	130.0	130.67	414889.0
2021-02-19 09:00:00	AAPL	Stock	130.67	130.69	129.45	130.44	13541009.0
2021-02-19 10:00:00	AAPL	Stock	130.44	130.525	129.475	129.945	10152059.0
2021-02-19 11:00:00	AAPL	Stock	129.94	130.71	129.82	130.09	7800963.0
2021-02-19 12:00:00	AAPL	Stock	130.07	130.17	129.03	129.335	8606476.0
2021-02-19 13:00:00	AAPL	Stock	129.33	129.42	128.8	129.125	7640863.0
2021-02-19 14:00:00	AAPL	Stock	129.13	129.655	128.8	129.645	6235228.0
2021-02-19 15:00:00	AAPL	Stock	129.64	130.1	129.58	129.85	11747465.0
2021-02-19 16:00:00	AAPL	Stock	129.87	129.9	129.38	129.65	7076801.0
2021-02-19 17:00:00	AAPL	Stock	129.65	129.69	129.53	129.6	72840.0
2021-02-19 18:00:00	AAPL	Stock	129.58	129.69	129.52	129.62	36194.0
2021-02-19 19:00:00	AAPL	Stock	129.62	129.75	129.58	129.72	66269.0
2021-02-19 04:00:00	MSFT	Stock	243.87	244.01	243.72	244.01	2256.0
2021-02-19 05:00:00	MSFT	Stock	243.72	244.18	243.61	244.04	4157.0
2021-02-19 06:00:00	MSFT	Stock	243.85	243.98	243.67	243.85	1505.0
2021-02-19 07:00:00	MSFT	Stock	243.78	244.53	243.7	244.53	10821.0
2021-02-19 08:00:00	MSFT	Stock	243.75	244.69	243.75	244.6	12240.0
2021-02-19 09:00:00	MSFT	Stock	244.49	244.55	241.24	241.64	3939232.0
2021-02-19 10:00:00	MSFT	Stock	241.66	242.25	241.35	242.13	2833210.0
2021-02-19 11:00:00	MSFT	Stock	242.13	242.66	241.6	241.642	1766130.0
2021-02-19 12:00:00	MSFT	Stock	241.64	241.822	240.397	241.035	2215885.0
2021-02-19 13:00:00	MSFT	Stock	241.04	241.74	240.18	241.095	1666906.0
2021-02-19 14:00:00	MSFT	Stock	241.1	241.39	240.5	241.25	1416611.0
2021-02-19 15:00:00	MSFT	Stock	241.25	241.8	240.54	241.03	3656139.0
2021-02-19 16:00:00	MSFT	Stock	240.97	241.19	240.5	240.7	3562825.0
2021-02-19 17:00:00	MSFT	Stock	240.8	240.8	240.53	240.62	9870.0
2021-02-19 18:00:00	MSFT	Stock	240.7	240.7	240.55	240.55	6922.0
2021-02-19 19:00:00	MSFT	Stock	240.51	240.78	240.5	240.68	4814.0
2021-02-19 04:00:00	NVDA	Stock	14.9138	14.975	14.9138	14.962	53520.0
2021-02-19 05:00:00	NVDA	Stock	14.975	14.9875	14.95	14.9875	41800.0
2021-02-19 06:00:00	NVDA	Stock	14.999	14.999	14.9605	14.9725	12000.0
2021-02-19 07:00:00	NVDA	Stock	14.95	15.0095	14.9498	14.9968	381760.0
2021-02-19 08:00:00	NVDA	Stock	14.9562	15.0625	14.9375	15.0488	1576800.0
2021-02-19 09:00:00	NVDA	Stock	15.0488	15.1105	14.9378	14.9708	38155840.0
2021-02-19 10:00:00	NVDA	Stock	14.9742	15.095	14.95	15.0701	29446880.0
2021-02-19 11:00:00	NVDA	Stock	15.0695	15.177	15.0685	15.1194	32009880.0
2021-02-19 12:00:00	NVDA	Stock	15.1178	15.134	14.8592	14.933	28602480.0
2021-02-19 13:00:00	NVDA	Stock	14.9268	14.968	14.8467	14.931	16421840.0
2021-02-19 14:00:00	NVDA	Stock	14.929	14.954	14.8478	14.9425	15358840.0
2021-02-19 15:00:00	NVDA	Stock	14.9404	14.9582	14.8878	14.93	32241800.0
2021-02-19 16:00:00	NVDA	Stock	14.9265	14.9375	14.9038	14.9075	18417160.0
2021-02-19 17:00:00	NVDA	Stock	14.9038	14.922	14.9038	14.91	101840.0
2021-02-19 18:00:00	NVDA	Stock	14.92	14.925	14.9138	14.9188	94000.0
2021-02-19 19:00:00	NVDA	Stock	14.9152	14.925	14.9128	14.925	82480.0
2021-02-19 04:00:00	AMZN	Stock	166.735	166.8	166.735	166.8	10680.0
2021-02-19 05:00:00	AMZN	Stock	166.8	166.8	166.799	166.799	16880.0

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

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