PREVIEW / stock_1hour / 2020-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-13.parquet
  size:    1.3 MB
  rows:    57,993
  symbols: 2,540

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-11-13 04:00:00	AAPL	Stock	119.8	120.1	119.6	119.81	38720.0
2020-11-13 05:00:00	AAPL	Stock	119.88	120.1	119.88	120.0	24811.0
2020-11-13 06:00:00	AAPL	Stock	119.94	120.05	119.74	119.92	42157.0
2020-11-13 07:00:00	AAPL	Stock	120.02	120.02	119.62	119.69	172037.0
2020-11-13 08:00:00	AAPL	Stock	119.82	119.97	119.5	119.67	345413.0
2020-11-13 09:00:00	AAPL	Stock	119.67	119.74	118.375	118.4	10719685.0
2020-11-13 10:00:00	AAPL	Stock	118.395	118.74	117.87	118.04	12687308.0
2020-11-13 11:00:00	AAPL	Stock	118.03	118.77	117.93	118.73	8135665.0
2020-11-13 12:00:00	AAPL	Stock	118.73	119.05	118.62	118.96	6729302.0
2020-11-13 13:00:00	AAPL	Stock	118.96	119.255	118.495	118.59	6997502.0
2020-11-13 14:00:00	AAPL	Stock	118.58	118.9	118.2	118.87	6885176.0
2020-11-13 15:00:00	AAPL	Stock	118.87	119.57	118.8	119.25	12620625.0
2020-11-13 16:00:00	AAPL	Stock	119.26	119.33	119.24	119.27	5086556.0
2020-11-13 17:00:00	AAPL	Stock	119.24	119.26	119.1	119.18	76449.0
2020-11-13 18:00:00	AAPL	Stock	119.16	119.2	119.1	119.15	40065.0
2020-11-13 19:00:00	AAPL	Stock	119.17	119.25	119.08	119.25	54483.0
2020-11-13 04:00:00	MSFT	Stock	216.76	217.0	216.75	216.97	3043.0
2020-11-13 05:00:00	MSFT	Stock	217.35	217.4	216.88	216.88	914.0
2020-11-13 06:00:00	MSFT	Stock	216.83	216.99	216.8	216.99	5113.0
2020-11-13 07:00:00	MSFT	Stock	216.71	216.94	216.01	216.28	15402.0
2020-11-13 08:00:00	MSFT	Stock	216.4	216.87	215.97	216.65	18166.0
2020-11-13 09:00:00	MSFT	Stock	216.618	216.89	215.21	215.345	1785612.0
2020-11-13 10:00:00	MSFT	Stock	215.37	215.46	214.16	214.8	1980703.0
2020-11-13 11:00:00	MSFT	Stock	214.83	215.47	214.46	215.23	1428693.0
2020-11-13 12:00:00	MSFT	Stock	215.25	216.13	215.075	216.02	1383790.0
2020-11-13 13:00:00	MSFT	Stock	216.03	216.48	215.68	216.041	1557532.0
2020-11-13 14:00:00	MSFT	Stock	216.05	216.65	215.71	216.47	1470906.0
2020-11-13 15:00:00	MSFT	Stock	216.44	217.42	215.96	216.51	2676445.0
2020-11-13 16:00:00	MSFT	Stock	216.51	217.0	216.488	216.75	3245566.0
2020-11-13 17:00:00	MSFT	Stock	216.7	216.81	216.6	216.81	2438.0
2020-11-13 18:00:00	MSFT	Stock	216.89	216.94	216.52	216.6	2488.0
2020-11-13 19:00:00	MSFT	Stock	216.51	216.65	216.4	216.5	2419.0
2020-11-13 04:00:00	NVDA	Stock	13.5498	13.575	13.5498	13.575	26080.0
2020-11-13 05:00:00	NVDA	Stock	13.6418	13.6418	13.5985	13.5985	22560.0
2020-11-13 06:00:00	NVDA	Stock	13.611	13.611	13.598	13.598	13920.0
2020-11-13 07:00:00	NVDA	Stock	13.6238	13.6875	13.5755	13.6262	1112000.0
2020-11-13 08:00:00	NVDA	Stock	13.5925	13.6808	13.4902	13.617	1214480.0
2020-11-13 09:00:00	NVDA	Stock	13.6075	13.6688	13.4773	13.544	42506280.0
2020-11-13 10:00:00	NVDA	Stock	13.5438	13.5596	13.113	13.1682	57533080.0
2020-11-13 11:00:00	NVDA	Stock	13.1675	13.3202	13.1675	13.2965	29709600.0
2020-11-13 12:00:00	NVDA	Stock	13.2982	13.3045	13.1765	13.206	26593360.0
2020-11-13 13:00:00	NVDA	Stock	13.2082	13.2256	13.0592	13.0863	30476600.0
2020-11-13 14:00:00	NVDA	Stock	13.0885	13.2266	13.0792	13.2188	27474120.0
2020-11-13 15:00:00	NVDA	Stock	13.2188	13.309	13.1972	13.297	38622920.0
2020-11-13 16:00:00	NVDA	Stock	13.297	13.3125	13.2775	13.2788	18225080.0
2020-11-13 17:00:00	NVDA	Stock	13.28	13.297	13.2752	13.2845	243120.0
2020-11-13 18:00:00	NVDA	Stock	13.2803	13.2982	13.2798	13.29	185200.0
2020-11-13 19:00:00	NVDA	Stock	13.2878	13.3	13.285	13.3	158200.0
2020-11-13 07:00:00	AMZN	Stock	156.1165	156.5	156.1165	156.3	84640.0
2020-11-13 08:00:00	AMZN	Stock	156.4	156.5944	156.05	156.3	155920.0

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

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