PREVIEW / stock_1hour / 2021-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-27.parquet
  size:    1.4 MB
  rows:    65,348
  symbols: 2,964

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-04-27 04:00:00	AAPL	Stock	134.89	135.0	134.69	134.84	4706.0
2021-04-27 05:00:00	AAPL	Stock	134.86	135.1	134.65	134.74	22377.0
2021-04-27 06:00:00	AAPL	Stock	134.76	135.0	134.74	135.0	9480.0
2021-04-27 07:00:00	AAPL	Stock	134.92	135.47	134.9	135.41	220640.0
2021-04-27 08:00:00	AAPL	Stock	135.2199	135.74	134.945	135.59	461229.0
2021-04-27 09:00:00	AAPL	Stock	135.59	135.6	134.27	134.48	9277777.0
2021-04-27 10:00:00	AAPL	Stock	134.47	134.935	134.11	134.375	11447541.0
2021-04-27 11:00:00	AAPL	Stock	134.375	134.67	134.28	134.4114	5747973.0
2021-04-27 12:00:00	AAPL	Stock	134.415	135.0799	134.4101	134.6539	6526229.0
2021-04-27 13:00:00	AAPL	Stock	134.655	134.76	134.45	134.5149	3951189.0
2021-04-27 14:00:00	AAPL	Stock	134.515	134.85	134.35	134.5031	6016457.0
2021-04-27 15:00:00	AAPL	Stock	134.5	134.8	134.2	134.39	9994989.0
2021-04-27 16:00:00	AAPL	Stock	134.39	134.7931	134.2	134.47	4469687.0
2021-04-27 17:00:00	AAPL	Stock	134.4701	134.55	134.37	134.53	365457.0
2021-04-27 18:00:00	AAPL	Stock	134.54	134.87	134.5	134.86	193332.0
2021-04-27 19:00:00	AAPL	Stock	134.84	134.95	134.79	134.79	113519.0
2021-04-27 04:00:00	MSFT	Stock	262.39	262.44	262.0	262.4	1699.0
2021-04-27 05:00:00	MSFT	Stock	262.4	262.55	261.55	261.79	4567.0
2021-04-27 06:00:00	MSFT	Stock	261.72	261.99	261.72	261.99	1685.0
2021-04-27 07:00:00	MSFT	Stock	262.17	262.5	261.99	262.27	30810.0
2021-04-27 08:00:00	MSFT	Stock	262.1934	262.41	262.01	262.05	35360.0
2021-04-27 09:00:00	MSFT	Stock	262.1	262.2	260.15	260.73	2480425.0
2021-04-27 10:00:00	MSFT	Stock	260.73	261.7016	260.12	260.62	2446566.0
2021-04-27 11:00:00	MSFT	Stock	260.625	261.185	260.4301	260.98	1510675.0
2021-04-27 12:00:00	MSFT	Stock	260.97	261.63	260.6	261.14	1859906.0
2021-04-27 13:00:00	MSFT	Stock	261.15	261.57	261.0	261.4	1374581.0
2021-04-27 14:00:00	MSFT	Stock	261.4	262.4	261.03	261.895	2254607.0
2021-04-27 15:00:00	MSFT	Stock	261.9057	263.19	261.52	262.19	3977615.0
2021-04-27 16:00:00	MSFT	Stock	261.97	263.14	251.39	252.8	5430384.0
2021-04-27 17:00:00	MSFT	Stock	252.8	261.97	252.55	253.16	673451.0
2021-04-27 18:00:00	MSFT	Stock	253.21	257.5	253.1	255.3	593825.0
2021-04-27 19:00:00	MSFT	Stock	255.25	255.47	254.2	255.0	113292.0
2021-04-27 04:00:00	NVDA	Stock	15.5025	15.5025	15.5025	15.5025	10640.0
2021-04-27 05:00:00	NVDA	Stock	15.5	15.5	15.5	15.5	4000.0
2021-04-27 06:00:00	NVDA	Stock	15.485	15.485	15.485	15.485	4600.0
2021-04-27 07:00:00	NVDA	Stock	15.4988	15.5248	15.4988	15.5248	76160.0
2021-04-27 08:00:00	NVDA	Stock	15.5	15.617	15.4988	15.5628	315800.0
2021-04-27 09:00:00	NVDA	Stock	15.55	15.6705	15.4408	15.464	20830080.0
2021-04-27 10:00:00	NVDA	Stock	15.4694	15.4845	15.3639	15.4398	18860760.0
2021-04-27 11:00:00	NVDA	Stock	15.434	15.4502	15.3762	15.4388	9749200.0
2021-04-27 12:00:00	NVDA	Stock	15.4421	15.4925	15.4085	15.4155	9927320.0
2021-04-27 13:00:00	NVDA	Stock	15.4151	15.4319	15.38	15.4014	6072880.0
2021-04-27 14:00:00	NVDA	Stock	15.4029	15.4143	15.3684	15.3858	4496200.0
2021-04-27 15:00:00	NVDA	Stock	15.378	15.4362	15.3545	15.3818	19152760.0
2021-04-27 16:00:00	NVDA	Stock	15.3818	15.4338	15.3775	15.3805	8894720.0
2021-04-27 17:00:00	NVDA	Stock	15.3818	15.3963	15.3818	15.3925	430840.0
2021-04-27 18:00:00	NVDA	Stock	15.3852	15.3852	15.3775	15.3775	64040.0
2021-04-27 19:00:00	NVDA	Stock	15.3865	15.3958	15.385	15.3958	20000.0
2021-04-27 04:00:00	AMZN	Stock	171.515	171.708	171.515	171.708	15720.0
2021-04-27 05:00:00	AMZN	Stock	171.65	171.65	171.65	171.65	3640.0

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

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