PREVIEW / stock_1hour / 2020-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-26.parquet
  size:    1.3 MB
  rows:    57,997
  symbols: 2,521

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
2020-10-26 04:00:00	AAPL	Stock	113.7	113.79	113.31	113.64	75955.0
2020-10-26 05:00:00	AAPL	Stock	113.63	113.87	113.5	113.56	24891.0
2020-10-26 06:00:00	AAPL	Stock	113.6	114.28	113.52	114.09	51078.0
2020-10-26 07:00:00	AAPL	Stock	114.15	114.36	113.65	113.75	354571.0
2020-10-26 08:00:00	AAPL	Stock	114.3	115.32	113.55	113.66	639321.0
2020-10-26 09:00:00	AAPL	Stock	113.65	115.87	113.6	115.7	13708583.0
2020-10-26 10:00:00	AAPL	Stock	115.71	116.55	114.87	114.93	15124291.0
2020-10-26 11:00:00	AAPL	Stock	114.93	114.98	113.89	114.18	14365163.0
2020-10-26 12:00:00	AAPL	Stock	114.17	114.68	113.86	113.94	9380740.0
2020-10-26 13:00:00	AAPL	Stock	113.935	114.14	112.88	113.83	12448448.0
2020-10-26 14:00:00	AAPL	Stock	113.835	114.4	113.67	114.16	9783825.0
2020-10-26 15:00:00	AAPL	Stock	114.165	115.22	113.9	115.06	16555860.0
2020-10-26 16:00:00	AAPL	Stock	115.05	115.25	114.135	115.17	8375111.0
2020-10-26 17:00:00	AAPL	Stock	115.15	115.19	115.05	115.179	668639.0
2020-10-26 18:00:00	AAPL	Stock	115.18	115.25	115.08	115.09	115714.0
2020-10-26 19:00:00	AAPL	Stock	115.09	115.2	114.81	114.86	157431.0
2020-10-26 04:00:00	MSFT	Stock	214.07	214.2	213.3	214.09	25863.0
2020-10-26 05:00:00	MSFT	Stock	213.99	214.15	213.71	214.0	4758.0
2020-10-26 06:00:00	MSFT	Stock	213.9	214.36	213.8	214.02	9903.0
2020-10-26 07:00:00	MSFT	Stock	214.14	215.11	214.0	214.02	44714.0
2020-10-26 08:00:00	MSFT	Stock	214.644	215.1	213.8	214.006	71109.0
2020-10-26 09:00:00	MSFT	Stock	214.03	215.92	213.65	215.59	2465154.0
2020-10-26 10:00:00	MSFT	Stock	215.578	216.34	212.8	213.0	3435743.0
2020-10-26 11:00:00	MSFT	Stock	213.01	213.02	209.77	210.78	5452271.0
2020-10-26 12:00:00	MSFT	Stock	210.78	211.3	209.57	209.685	3134704.0
2020-10-26 13:00:00	MSFT	Stock	209.677	209.85	208.1	209.5	3736832.0
2020-10-26 14:00:00	MSFT	Stock	209.49	210.35	209.2	209.92	2721569.0
2020-10-26 15:00:00	MSFT	Stock	209.94	210.31	208.84	210.15	5467657.0
2020-10-26 16:00:00	MSFT	Stock	210.12	210.78	210.08	210.6	4155413.0
2020-10-26 17:00:00	MSFT	Stock	210.66	210.94	210.08	210.67	295457.0
2020-10-26 18:00:00	MSFT	Stock	210.7	211.0	210.7	210.85	39644.0
2020-10-26 19:00:00	MSFT	Stock	210.87	211.48	210.5	210.7	38651.0
2020-10-26 04:00:00	NVDA	Stock	13.45	13.45	13.4125	13.425	83040.0
2020-10-26 05:00:00	NVDA	Stock	13.4255	13.4255	13.4252	13.4252	18320.0
2020-10-26 07:00:00	NVDA	Stock	13.4882	13.4925	13.4325	13.4325	289480.0
2020-10-26 08:00:00	NVDA	Stock	13.4909	13.624	13.4062	13.4438	1446560.0
2020-10-26 09:00:00	NVDA	Stock	13.42	13.665	13.4132	13.6455	29533560.0
2020-10-26 10:00:00	NVDA	Stock	13.6448	13.6928	13.4132	13.4132	30937480.0
2020-10-26 11:00:00	NVDA	Stock	13.4135	13.4135	13.2434	13.2778	43105680.0
2020-10-26 12:00:00	NVDA	Stock	13.2842	13.3042	13.1125	13.1248	30425240.0
2020-10-26 13:00:00	NVDA	Stock	13.1246	13.1365	13.0385	13.1154	32697120.0
2020-10-26 14:00:00	NVDA	Stock	13.117	13.1312	13.0645	13.1091	32945600.0
2020-10-26 15:00:00	NVDA	Stock	13.1102	13.149	13.055	13.1414	56227200.0
2020-10-26 16:00:00	NVDA	Stock	13.1412	13.2428	13.135	13.145	28274280.0
2020-10-26 17:00:00	NVDA	Stock	13.1502	13.1562	13.1495	13.1562	67280.0
2020-10-26 18:00:00	NVDA	Stock	13.15	13.1613	13.15	13.1562	97440.0
2020-10-26 19:00:00	NVDA	Stock	13.1505	13.1512	13.1258	13.1258	97480.0
2020-10-26 04:00:00	AMZN	Stock	159.507	159.507	159.085	159.25	12300.0
2020-10-26 05:00:00	AMZN	Stock	159.1455	159.1455	159.1455	159.1455	2000.0
2020-10-26 07:00:00	AMZN	Stock	159.639	160.0875	159.2005	159.25	168760.0

> showing 50 of 57,997 rows — these rows as CSV

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