PREVIEW / stock_1hour / 2021-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-21.parquet
  size:    1.4 MB
  rows:    64,615
  symbols: 2,660

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-10-21 04:00:00	AAPL	Stock	148.92	148.99	148.75	148.83	5676.0
2021-10-21 05:00:00	AAPL	Stock	148.87	148.95	148.87	148.95	4508.0
2021-10-21 06:00:00	AAPL	Stock	148.93	148.98	148.85	148.85	5312.0
2021-10-21 07:00:00	AAPL	Stock	148.85	148.95	148.61	148.65	86678.0
2021-10-21 08:00:00	AAPL	Stock	148.6799	148.95	148.6	148.8	335244.0
2021-10-21 09:00:00	AAPL	Stock	148.8	149.6	148.71	149.3689	6888562.0
2021-10-21 10:00:00	AAPL	Stock	149.36	149.62	149.09	149.31	6466749.0
2021-10-21 11:00:00	AAPL	Stock	149.315	149.52	149.1	149.273	4803664.0
2021-10-21 12:00:00	AAPL	Stock	149.2799	149.41	147.87	148.57	10643339.0
2021-10-21 13:00:00	AAPL	Stock	148.57	148.6	148.37	148.46	2830306.0
2021-10-21 14:00:00	AAPL	Stock	148.46	149.1	148.37	149.04	4198020.0
2021-10-21 15:00:00	AAPL	Stock	149.05	149.64	149.05	149.46	8234991.0
2021-10-21 16:00:00	AAPL	Stock	149.46	149.99	149.21	149.31	4570946.0
2021-10-21 17:00:00	AAPL	Stock	149.28	149.34	149.06	149.1899	66452.0
2021-10-21 18:00:00	AAPL	Stock	149.1	149.37	149.1	149.19	53234.0
2021-10-21 19:00:00	AAPL	Stock	149.17	149.33	149.14	149.15	45274.0
2021-10-21 04:00:00	MSFT	Stock	306.84	306.89	306.51	306.81	2071.0
2021-10-21 05:00:00	MSFT	Stock	307.24	307.33	307.24	307.33	1613.0
2021-10-21 06:00:00	MSFT	Stock	307.25	307.3	307.0	307.0	1026.0
2021-10-21 07:00:00	MSFT	Stock	306.91	306.92	306.54	306.54	1036.0
2021-10-21 08:00:00	MSFT	Stock	307.0	307.22	306.44	307.01	23912.0
2021-10-21 09:00:00	MSFT	Stock	306.86	308.75	306.36	308.0251	1555566.0
2021-10-21 10:00:00	MSFT	Stock	308.04	309.2	307.79	309.005	1501935.0
2021-10-21 11:00:00	MSFT	Stock	309.01	309.38	308.12	308.82	1456532.0
2021-10-21 12:00:00	MSFT	Stock	308.8399	309.46	308.8173	309.4491	1129178.0
2021-10-21 13:00:00	MSFT	Stock	309.42	309.78	309.21	309.435	1144299.0
2021-10-21 14:00:00	MSFT	Stock	309.43	309.74	309.31	309.51	891118.0
2021-10-21 15:00:00	MSFT	Stock	309.54	311.02	309.515	310.75	2692458.0
2021-10-21 16:00:00	MSFT	Stock	310.76	313.0	309.65	309.83	2422920.0
2021-10-21 17:00:00	MSFT	Stock	309.93	310.04	309.3	309.6	26032.0
2021-10-21 18:00:00	MSFT	Stock	309.69	310.0	309.68	309.85	14008.0
2021-10-21 19:00:00	MSFT	Stock	309.95	310.49	309.81	310.15	15232.0
2021-10-21 04:00:00	NVDA	Stock	22.02	22.02	21.975	22.007	14370.0
2021-10-21 05:00:00	NVDA	Stock	22.005	22.056	21.971	22.056	14840.0
2021-10-21 06:00:00	NVDA	Stock	22.05	22.052	22.017	22.017	14830.0
2021-10-21 07:00:00	NVDA	Stock	22.036	22.052	21.98	21.98	97700.0
2021-10-21 08:00:00	NVDA	Stock	22.04	22.07	21.98	22.0696	282890.0
2021-10-21 09:00:00	NVDA	Stock	22.037	22.312	22.037	22.279	21079890.0
2021-10-21 10:00:00	NVDA	Stock	22.277	22.526	22.276	22.503	34948790.0
2021-10-21 11:00:00	NVDA	Stock	22.504	22.547	22.403	22.493	16251480.0
2021-10-21 12:00:00	NVDA	Stock	22.494	22.635	22.491	22.632	15700210.0
2021-10-21 13:00:00	NVDA	Stock	22.63	22.634	22.547	22.553	9319590.0
2021-10-21 14:00:00	NVDA	Stock	22.555	22.609	22.542	22.5968	7839930.0
2021-10-21 15:00:00	NVDA	Stock	22.597	22.711	22.593	22.686	24029410.0
2021-10-21 16:00:00	NVDA	Stock	22.692	22.77	22.58	22.629	14304900.0
2021-10-21 17:00:00	NVDA	Stock	22.63	22.649	22.473	22.526	536400.0
2021-10-21 18:00:00	NVDA	Stock	22.529	22.63	22.48	22.598	182850.0
2021-10-21 19:00:00	NVDA	Stock	22.584	22.669	22.58	22.65	175680.0
2021-10-21 05:00:00	AMZN	Stock	170.75	170.75	170.75	170.75	2000.0
2021-10-21 07:00:00	AMZN	Stock	170.55	170.55	170.1275	170.1275	26540.0

> showing 50 of 64,615 rows — these rows as CSV

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