PREVIEW / stock_1hour / 2021-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-18.parquet
  size:    1.5 MB
  rows:    69,770
  symbols: 2,827

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-18 04:00:00	AAPL	Stock	130.5	130.5	129.84	129.9	29825.0
2021-02-18 05:00:00	AAPL	Stock	129.9	130.02	129.72	129.72	32272.0
2021-02-18 06:00:00	AAPL	Stock	129.64	129.64	128.81	129.26	139156.0
2021-02-18 07:00:00	AAPL	Stock	129.25	129.6	129.2	129.38	193835.0
2021-02-18 08:00:00	AAPL	Stock	129.41	129.58	128.68	128.7	812216.0
2021-02-18 09:00:00	AAPL	Stock	128.7	129.68	128.5	129.53	12804228.0
2021-02-18 10:00:00	AAPL	Stock	129.52	129.58	127.41	128.545	17010068.0
2021-02-18 11:00:00	AAPL	Stock	128.555	129.105	128.12	128.34	10368074.0
2021-02-18 12:00:00	AAPL	Stock	128.335	128.83	127.9	128.7	8747938.0
2021-02-18 13:00:00	AAPL	Stock	128.7	129.07	128.45	128.56	7310199.0
2021-02-18 14:00:00	AAPL	Stock	128.56	129.13	128.462	129.075	6784627.0
2021-02-18 15:00:00	AAPL	Stock	129.075	129.995	129.03	129.713	13111711.0
2021-02-18 16:00:00	AAPL	Stock	129.71	129.79	129.29	129.35	4720078.0
2021-02-18 17:00:00	AAPL	Stock	129.35	129.4	129.22	129.3	99288.0
2021-02-18 18:00:00	AAPL	Stock	129.3	129.54	129.15	129.24	97987.0
2021-02-18 19:00:00	AAPL	Stock	129.22	129.25	129.0	129.0	99066.0
2021-02-18 04:00:00	MSFT	Stock	243.16	243.16	242.8	242.85	950.0
2021-02-18 05:00:00	MSFT	Stock	242.91	243.19	242.59	242.59	1002.0
2021-02-18 06:00:00	MSFT	Stock	242.87	242.87	242.32	242.8	1824.0
2021-02-18 07:00:00	MSFT	Stock	242.81	242.99	242.5	242.5	14148.0
2021-02-18 08:00:00	MSFT	Stock	242.69	243.59	241.55	242.12	20229.0
2021-02-18 09:00:00	MSFT	Stock	242.0	242.44	241.32	241.994	1916340.0
2021-02-18 10:00:00	MSFT	Stock	241.95	242.2	240.86	241.66	1955313.0
2021-02-18 11:00:00	MSFT	Stock	241.62	242.34	241.121	241.49	1320128.0
2021-02-18 12:00:00	MSFT	Stock	241.48	241.97	240.995	241.86	1193588.0
2021-02-18 13:00:00	MSFT	Stock	241.87	242.81	241.62	242.52	1053950.0
2021-02-18 14:00:00	MSFT	Stock	242.51	243.48	242.47	243.31	1032121.0
2021-02-18 15:00:00	MSFT	Stock	243.31	243.93	243.195	243.79	2355723.0
2021-02-18 16:00:00	MSFT	Stock	243.79	243.84	243.23	243.45	2813997.0
2021-02-18 17:00:00	MSFT	Stock	243.45	243.45	243.15	243.3	4423.0
2021-02-18 18:00:00	MSFT	Stock	243.47	243.75	242.46	242.72	8692.0
2021-02-18 19:00:00	MSFT	Stock	242.74	242.94	242.55	242.94	3258.0
2021-02-18 04:00:00	NVDA	Stock	14.8138	14.8302	14.8138	14.8302	14960.0
2021-02-18 05:00:00	NVDA	Stock	14.8	14.8	14.6875	14.6975	56840.0
2021-02-18 06:00:00	NVDA	Stock	14.6532	14.7028	14.65	14.7028	87840.0
2021-02-18 07:00:00	NVDA	Stock	14.7472	14.8032	14.7375	14.7575	403920.0
2021-02-18 08:00:00	NVDA	Stock	14.7995	14.8152	14.6888	14.7012	1302800.0
2021-02-18 09:00:00	NVDA	Stock	14.7	14.869	14.625	14.8241	30993040.0
2021-02-18 10:00:00	NVDA	Stock	14.8138	14.8318	14.5775	14.6855	40143960.0
2021-02-18 11:00:00	NVDA	Stock	14.699	14.7438	14.575	14.6442	19059880.0
2021-02-18 12:00:00	NVDA	Stock	14.643	14.682	14.5915	14.6642	11925560.0
2021-02-18 13:00:00	NVDA	Stock	14.6668	14.7662	14.6328	14.735	18442920.0
2021-02-18 14:00:00	NVDA	Stock	14.739	14.786	14.696	14.772	15956360.0
2021-02-18 15:00:00	NVDA	Stock	14.7668	14.8732	14.7593	14.829	35734000.0
2021-02-18 16:00:00	NVDA	Stock	14.829	14.85	14.8062	14.829	19865560.0
2021-02-18 17:00:00	NVDA	Stock	14.835	14.85	14.8062	14.8062	173320.0
2021-02-18 18:00:00	NVDA	Stock	14.8338	14.8338	14.8062	14.8235	53520.0
2021-02-18 19:00:00	NVDA	Stock	14.7962	14.825	14.7962	14.8052	30560.0
2021-02-18 05:00:00	AMZN	Stock	164.0	164.0	164.0	164.0	2400.0
2021-02-18 06:00:00	AMZN	Stock	164.3	164.3	164.3	164.3	2480.0

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

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