PREVIEW / stock_1hour / 2020-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-13.parquet
  size:    1.2 MB
  rows:    56,443
  symbols: 2,429

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-08-13 04:00:00	AAPL	Stock	113.1225	113.1225	112.675	112.925	10136.0
2020-08-13 05:00:00	AAPL	Stock	112.9175	112.9175	112.8725	112.875	8048.0
2020-08-13 06:00:00	AAPL	Stock	112.915	113.6925	112.875	113.495	82804.0
2020-08-13 07:00:00	AAPL	Stock	113.505	113.75	113.2575	113.6875	436556.0
2020-08-13 08:00:00	AAPL	Stock	113.625	114.4825	113.2575	114.2975	1913984.0
2020-08-13 09:00:00	AAPL	Stock	114.2625	115.12	114.01	114.48	26074976.0
2020-08-13 10:00:00	AAPL	Stock	114.49	115.3125	113.9275	115.057	26170736.0
2020-08-13 11:00:00	AAPL	Stock	115.0625	115.5825	114.89	115.2812	19655176.0
2020-08-13 12:00:00	AAPL	Stock	115.2875	115.9525	115.2725	115.94	17806248.0
2020-08-13 13:00:00	AAPL	Stock	115.945	116.0425	114.9125	115.3638	19695676.0
2020-08-13 14:00:00	AAPL	Stock	115.3638	115.4245	114.1925	114.4738	23101972.0
2020-08-13 15:00:00	AAPL	Stock	114.465	115.325	114.325	115.0075	23250936.0
2020-08-13 16:00:00	AAPL	Stock	115.01	115.01	114.875	114.975	4154608.0
2020-08-13 17:00:00	AAPL	Stock	114.9575	114.9575	114.375	114.78	484684.0
2020-08-13 18:00:00	AAPL	Stock	114.8075	114.9625	114.7625	114.8425	153620.0
2020-08-13 19:00:00	AAPL	Stock	114.85	114.985	114.845	114.875	198352.0
2020-08-13 04:00:00	MSFT	Stock	209.1	209.1	208.85	208.85	1211.0
2020-08-13 05:00:00	MSFT	Stock	208.96	208.96	208.85	208.85	398.0
2020-08-13 06:00:00	MSFT	Stock	208.86	208.95	208.82	208.82	1427.0
2020-08-13 07:00:00	MSFT	Stock	208.96	209.19	208.67	208.98	12242.0
2020-08-13 08:00:00	MSFT	Stock	209.144	209.9	208.65	209.84	80065.0
2020-08-13 09:00:00	MSFT	Stock	209.72	211.29	209.21	210.26	3060703.0
2020-08-13 10:00:00	MSFT	Stock	210.255	210.83	208.841	210.36	3188355.0
2020-08-13 11:00:00	MSFT	Stock	210.362	210.953	210.34	210.87	1814998.0
2020-08-13 12:00:00	MSFT	Stock	210.88	211.35	210.6	210.92	1562811.0
2020-08-13 13:00:00	MSFT	Stock	210.94	211.04	209.25	209.855	1789149.0
2020-08-13 14:00:00	MSFT	Stock	209.84	209.915	208.15	208.67	2403538.0
2020-08-13 15:00:00	MSFT	Stock	208.71	209.22	208.41	208.72	2399533.0
2020-08-13 16:00:00	MSFT	Stock	208.7	208.85	208.39	208.8	2050774.0
2020-08-13 17:00:00	MSFT	Stock	208.765	208.765	208.5	208.51	14067.0
2020-08-13 18:00:00	MSFT	Stock	208.59	208.89	208.55	208.8	4886.0
2020-08-13 19:00:00	MSFT	Stock	208.85	209.23	208.85	209.05	22893.0
2020-08-13 04:00:00	NVDA	Stock	11.435	11.435	11.4075	11.4075	33880.0
2020-08-13 05:00:00	NVDA	Stock	11.4175	11.4175	11.4175	11.4175	8000.0
2020-08-13 06:00:00	NVDA	Stock	11.4273	11.4273	11.4188	11.4188	16000.0
2020-08-13 07:00:00	NVDA	Stock	11.4263	11.486	11.4185	11.486	690960.0
2020-08-13 08:00:00	NVDA	Stock	11.4625	11.5583	11.4205	11.553	2170840.0
2020-08-13 09:00:00	NVDA	Stock	11.553	11.7218	11.49	11.6071	77037760.0
2020-08-13 10:00:00	NVDA	Stock	11.6042	11.6109	11.4778	11.5648	52154960.0
2020-08-13 11:00:00	NVDA	Stock	11.5669	11.6385	11.5312	11.567	29742000.0
2020-08-13 12:00:00	NVDA	Stock	11.5716	11.6038	11.5472	11.574	19440080.0
2020-08-13 13:00:00	NVDA	Stock	11.5743	11.5798	11.4398	11.4881	39849040.0
2020-08-13 14:00:00	NVDA	Stock	11.4918	11.4951	11.3558	11.4303	42869600.0
2020-08-13 15:00:00	NVDA	Stock	11.4345	11.5	11.4	11.443	48397880.0
2020-08-13 16:00:00	NVDA	Stock	11.443	11.45	11.425	11.4463	7448400.0
2020-08-13 17:00:00	NVDA	Stock	11.4425	11.4475	11.44	11.4468	183960.0
2020-08-13 18:00:00	NVDA	Stock	11.4463	11.4585	11.444	11.4502	633160.0
2020-08-13 19:00:00	NVDA	Stock	11.4505	11.4875	11.4505	11.48	508200.0
2020-08-13 07:00:00	AMZN	Stock	157.65	158.0	157.65	158.0	32400.0
2020-08-13 08:00:00	AMZN	Stock	158.507	159.25	158.112	158.901	249980.0

> showing 50 of 56,443 rows — these rows as CSV

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