PREVIEW / stock_1hour / 2021-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-09.parquet
  size:    1.4 MB
  rows:    65,191
  symbols: 2,901

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-07-09 04:00:00	AAPL	Stock	143.24	143.89	143.24	143.5	36614.0
2021-07-09 05:00:00	AAPL	Stock	143.51	143.6	142.86	143.0	39354.0
2021-07-09 06:00:00	AAPL	Stock	143.0	143.0	142.55	142.9	26577.0
2021-07-09 07:00:00	AAPL	Stock	142.95	143.44	142.81	143.03	189448.0
2021-07-09 08:00:00	AAPL	Stock	143.12	143.35	142.85	142.98	424002.0
2021-07-09 09:00:00	AAPL	Stock	142.96	143.98	142.6	143.935	11482999.0
2021-07-09 10:00:00	AAPL	Stock	143.9457	145.35	143.88	145.2001	19100416.0
2021-07-09 11:00:00	AAPL	Stock	145.205	145.44	144.8501	145.2319	13242771.0
2021-07-09 12:00:00	AAPL	Stock	145.2382	145.65	145.04	145.4299	11118016.0
2021-07-09 13:00:00	AAPL	Stock	145.4274	145.48	145.02	145.11	6382015.0
2021-07-09 14:00:00	AAPL	Stock	145.11	145.2472	144.8	145.165	7762040.0
2021-07-09 15:00:00	AAPL	Stock	145.16	145.29	144.84	145.11	13949560.0
2021-07-09 16:00:00	AAPL	Stock	145.11	145.11	144.9	145.0	7444071.0
2021-07-09 17:00:00	AAPL	Stock	145.0	145.11	144.95	145.11	230762.0
2021-07-09 18:00:00	AAPL	Stock	145.11	145.1699	145.05	145.06	38360.0
2021-07-09 19:00:00	AAPL	Stock	145.06	145.18	145.05	145.07	59399.0
2021-07-09 04:00:00	MSFT	Stock	277.64	278.0	277.3	277.3	3376.0
2021-07-09 05:00:00	MSFT	Stock	277.5	277.5	276.71	277.0	7084.0
2021-07-09 06:00:00	MSFT	Stock	276.82	277.0	276.21	276.66	11555.0
2021-07-09 07:00:00	MSFT	Stock	276.87	277.25	276.1	276.7	38324.0
2021-07-09 08:00:00	MSFT	Stock	276.6	277.1	276.1	276.36	35567.0
2021-07-09 09:00:00	MSFT	Stock	276.45	276.93	275.32	276.4573	2292109.0
2021-07-09 10:00:00	MSFT	Stock	276.44	277.41	275.32	277.4	2853731.0
2021-07-09 11:00:00	MSFT	Stock	277.41	277.69	276.73	277.26	1885657.0
2021-07-09 12:00:00	MSFT	Stock	277.26	277.87	277.19	277.59	1210229.0
2021-07-09 13:00:00	MSFT	Stock	277.585	277.61	277.08	277.36	1168167.0
2021-07-09 14:00:00	MSFT	Stock	277.3601	277.51	276.98	277.38	1146755.0
2021-07-09 15:00:00	MSFT	Stock	277.38	278.05	277.21	277.94	3545651.0
2021-07-09 16:00:00	MSFT	Stock	277.94	278.15	277.66	277.78	4124247.0
2021-07-09 17:00:00	MSFT	Stock	277.78	277.92	277.78	277.89	8105.0
2021-07-09 18:00:00	MSFT	Stock	277.89	277.94	277.6	277.75	7133.0
2021-07-09 19:00:00	MSFT	Stock	277.78	277.94	277.78	277.94	3532.0
2021-07-09 04:00:00	NVDA	Stock	20.075	20.075	20.0028	20.0028	36880.0
2021-07-09 05:00:00	NVDA	Stock	20.025	20.0262	20.0	20.0	39680.0
2021-07-09 06:00:00	NVDA	Stock	19.903	20.0	19.875	19.9893	261880.0
2021-07-09 07:00:00	NVDA	Stock	20.0	20.075	19.9875	20.0448	781360.0
2021-07-09 08:00:00	NVDA	Stock	20.063	20.0815	19.9698	20.0088	1039320.0
2021-07-09 09:00:00	NVDA	Stock	20.0085	20.05	19.7925	19.8972	32181080.0
2021-07-09 10:00:00	NVDA	Stock	19.8988	19.9068	19.7542	19.8443	31425400.0
2021-07-09 11:00:00	NVDA	Stock	19.8445	20.0138	19.8401	19.9138	24179160.0
2021-07-09 12:00:00	NVDA	Stock	19.917	19.9838	19.8695	19.944	14339200.0
2021-07-09 13:00:00	NVDA	Stock	19.9451	19.965	19.8952	19.9389	8072160.0
2021-07-09 14:00:00	NVDA	Stock	19.9378	19.9738	19.8804	19.9618	12521160.0
2021-07-09 15:00:00	NVDA	Stock	19.962	20.0801	19.9615	20.0503	33363760.0
2021-07-09 16:00:00	NVDA	Stock	20.0503	20.0503	20.0188	20.025	14644680.0
2021-07-09 17:00:00	NVDA	Stock	20.025	20.0288	20.0173	20.025	224760.0
2021-07-09 18:00:00	NVDA	Stock	20.025	20.0312	20.025	20.0275	27040.0
2021-07-09 19:00:00	NVDA	Stock	20.025	20.0312	20.025	20.03	52720.0
2021-07-09 05:00:00	AMZN	Stock	186.9	186.9	185.798	185.798	11040.0
2021-07-09 06:00:00	AMZN	Stock	186.0	186.245	186.0	186.1	17540.0

> showing 50 of 65,191 rows — these rows as CSV

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