PREVIEW / stock_1hour / 2021-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-02.parquet
  size:    1.5 MB
  rows:    67,964
  symbols: 2,841

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-03-02 04:00:00	AAPL	Stock	126.95	127.46	126.58	127.35	58815.0
2021-03-02 05:00:00	AAPL	Stock	127.28	127.92	127.13	127.55	29486.0
2021-03-02 06:00:00	AAPL	Stock	127.43	127.81	127.3	127.7	30301.0
2021-03-02 07:00:00	AAPL	Stock	127.59	128.31	127.55	128.22	297181.0
2021-03-02 08:00:00	AAPL	Stock	127.8501	128.4	127.61	127.95	599406.0
2021-03-02 09:00:00	AAPL	Stock	127.97	128.72	126.19	126.73	14933174.0
2021-03-02 10:00:00	AAPL	Stock	126.735	127.1984	125.73	126.13	14255903.0
2021-03-02 11:00:00	AAPL	Stock	126.13	126.45	125.46	125.82	10826594.0
2021-03-02 12:00:00	AAPL	Stock	125.815	126.68	125.72	126.17	8331110.0
2021-03-02 13:00:00	AAPL	Stock	126.17	126.42	125.95	125.98	6343749.0
2021-03-02 14:00:00	AAPL	Stock	125.98	126.2002	125.58	126.015	7646795.0
2021-03-02 15:00:00	AAPL	Stock	126.02	126.3144	125.01	125.1601	14965712.0
2021-03-02 16:00:00	AAPL	Stock	125.165	125.29	125.01	125.12	7938377.0
2021-03-02 17:00:00	AAPL	Stock	125.1001	125.13	125.0	125.03	174899.0
2021-03-02 18:00:00	AAPL	Stock	125.01	125.35	125.0	125.3	132004.0
2021-03-02 19:00:00	AAPL	Stock	125.27	125.62	125.22	125.59	125276.0
2021-03-02 04:00:00	MSFT	Stock	235.75	235.88	235.06	235.58	5912.0
2021-03-02 05:00:00	MSFT	Stock	235.52	235.88	235.52	235.88	242.0
2021-03-02 06:00:00	MSFT	Stock	236.25	236.45	236.2	236.23	3163.0
2021-03-02 07:00:00	MSFT	Stock	236.19	236.87	235.88	236.53	20437.0
2021-03-02 08:00:00	MSFT	Stock	236.42	236.69	236.0	236.25	18399.0
2021-03-02 09:00:00	MSFT	Stock	236.2643	237.48	234.14	234.875	2619157.0
2021-03-02 10:00:00	MSFT	Stock	234.89	235.9	233.6	234.36	2391340.0
2021-03-02 11:00:00	MSFT	Stock	234.31	234.58	233.45	234.24	1916443.0
2021-03-02 12:00:00	MSFT	Stock	234.18	235.23	233.97	234.81	1145684.0
2021-03-02 13:00:00	MSFT	Stock	234.82	235.75	234.7743	235.24	949848.0
2021-03-02 14:00:00	MSFT	Stock	235.25	235.89	234.78	235.64	1282736.0
2021-03-02 15:00:00	MSFT	Stock	235.61	236.15	233.5	233.87	3142553.0
2021-03-02 16:00:00	MSFT	Stock	233.87	234.57	233.5163	234.0	3096195.0
2021-03-02 17:00:00	MSFT	Stock	233.7	233.9799	233.64	233.65	18137.0
2021-03-02 18:00:00	MSFT	Stock	233.65	234.75	233.65	234.5	8972.0
2021-03-02 19:00:00	MSFT	Stock	234.6	235.69	234.51	235.52	14605.0
2021-03-02 04:00:00	NVDA	Stock	13.75	13.75	13.75	13.75	4000.0
2021-03-02 05:00:00	NVDA	Stock	13.75	13.75	13.75	13.75	27280.0
2021-03-02 07:00:00	NVDA	Stock	13.8	13.825	13.8	13.825	101440.0
2021-03-02 08:00:00	NVDA	Stock	13.7852	13.855	13.7852	13.8375	265040.0
2021-03-02 09:00:00	NVDA	Stock	13.8363	13.9375	13.6668	13.7085	22894920.0
2021-03-02 10:00:00	NVDA	Stock	13.7	13.828	13.664	13.7092	27390440.0
2021-03-02 11:00:00	NVDA	Stock	13.702	13.7472	13.5752	13.6298	20087800.0
2021-03-02 12:00:00	NVDA	Stock	13.6183	13.666	13.5825	13.6152	15634520.0
2021-03-02 13:00:00	NVDA	Stock	13.6232	13.6904	13.619	13.6254	9150640.0
2021-03-02 14:00:00	NVDA	Stock	13.631	13.6615	13.544	13.595	11298720.0
2021-03-02 15:00:00	NVDA	Stock	13.5933	13.62	13.396	13.4	34651200.0
2021-03-02 16:00:00	NVDA	Stock	13.4062	13.4475	13.3938	13.425	18403680.0
2021-03-02 17:00:00	NVDA	Stock	13.4198	13.437	13.4128	13.4188	367400.0
2021-03-02 18:00:00	NVDA	Stock	13.4175	13.4485	13.4075	13.4475	242880.0
2021-03-02 19:00:00	NVDA	Stock	13.4375	13.4808	13.428	13.48	177880.0
2021-03-02 04:00:00	AMZN	Stock	156.705	156.705	156.705	156.705	2480.0
2021-03-02 07:00:00	AMZN	Stock	157.0875	157.0875	156.9	157.05	14500.0
2021-03-02 08:00:00	AMZN	Stock	157.24	157.24	156.7	157.0	53200.0

> showing 50 of 67,964 rows — these rows as CSV

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