PREVIEW / stock_1hour / 2018-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-19.parquet
  size:    1.1 MB
  rows:    48,104
  symbols: 2,847

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
2018-04-19 04:00:00	AAPL	Stock	44.325	44.325	44.19	44.19	16800.0
2018-04-19 05:00:00	AAPL	Stock	44.125	44.15	44.0125	44.0975	11072.0
2018-04-19 06:00:00	AAPL	Stock	44.0875	44.0875	43.6375	43.7125	87876.0
2018-04-19 07:00:00	AAPL	Stock	43.7125	44.0125	43.7125	43.825	537260.0
2018-04-19 08:00:00	AAPL	Stock	43.82	44.0	43.625	43.7225	1349096.0
2018-04-19 09:00:00	AAPL	Stock	43.7225	43.9	43.53	43.635	20391664.0
2018-04-19 10:00:00	AAPL	Stock	43.6325	43.66	43.413	43.4275	20076088.0
2018-04-19 11:00:00	AAPL	Stock	43.4275	43.5025	43.315	43.35	14317344.0
2018-04-19 12:00:00	AAPL	Stock	43.3475	43.449	43.29	43.3375	11173804.0
2018-04-19 13:00:00	AAPL	Stock	43.335	43.495	43.3	43.4688	8302920.0
2018-04-19 14:00:00	AAPL	Stock	43.4675	43.4875	43.165	43.279	13794956.0
2018-04-19 15:00:00	AAPL	Stock	43.2775	43.395	43.1925	43.2	25090260.0
2018-04-19 16:00:00	AAPL	Stock	43.1975	43.205	43.1625	43.18	12290540.0
2018-04-19 17:00:00	AAPL	Stock	43.175	43.1875	43.15	43.18	104340.0
2018-04-19 18:00:00	AAPL	Stock	43.18	43.1875	43.165	43.175	107448.0
2018-04-19 19:00:00	AAPL	Stock	43.1825	43.185	43.125	43.15	86232.0
2018-04-19 04:00:00	MSFT	Stock	96.43	96.69	96.43	96.69	11219.0
2018-04-19 05:00:00	MSFT	Stock	96.6	96.6	96.6	96.6	2200.0
2018-04-19 06:00:00	MSFT	Stock	96.45	96.51	96.31	96.47	9649.0
2018-04-19 07:00:00	MSFT	Stock	96.46	96.66	96.44	96.66	8782.0
2018-04-19 08:00:00	MSFT	Stock	96.65	96.66	96.3	96.3	29050.0
2018-04-19 09:00:00	MSFT	Stock	96.3	96.67	95.97	96.385	2076244.0
2018-04-19 10:00:00	MSFT	Stock	96.39	97.07	96.32	96.68	3283524.0
2018-04-19 11:00:00	MSFT	Stock	96.68	96.7	95.6	95.638	2576094.0
2018-04-19 12:00:00	MSFT	Stock	95.62	95.889	95.42	95.5	3082272.0
2018-04-19 13:00:00	MSFT	Stock	95.48	95.95	95.34	95.84	1543241.0
2018-04-19 14:00:00	MSFT	Stock	95.83	95.92	95.56	95.781	1657943.0
2018-04-19 15:00:00	MSFT	Stock	95.786	96.39	95.68	96.1	4276640.0
2018-04-19 16:00:00	MSFT	Stock	96.11	96.14	96.0	96.1	2724098.0
2018-04-19 17:00:00	MSFT	Stock	96.0	96.15	96.0	96.15	3365.0
2018-04-19 18:00:00	MSFT	Stock	96.15	96.15	96.0	96.08	4450.0
2018-04-19 19:00:00	MSFT	Stock	96.05	96.08	95.9	96.08	2092.0
2018-04-19 04:00:00	NVDA	Stock	5.875	5.88	5.801	5.801	197520.0
2018-04-19 05:00:00	NVDA	Stock	5.7763	5.8015	5.77	5.8	209120.0
2018-04-19 06:00:00	NVDA	Stock	5.8025	5.8025	5.775	5.785	187600.0
2018-04-19 07:00:00	NVDA	Stock	5.8	5.8425	5.8	5.8328	2530320.0
2018-04-19 08:00:00	NVDA	Stock	5.825	5.9225	5.7788	5.78	6840440.0
2018-04-19 09:00:00	NVDA	Stock	5.78	5.8275	5.7605	5.8069	78656840.0
2018-04-19 10:00:00	NVDA	Stock	5.8068	5.8095	5.7202	5.7341	92694200.0
2018-04-19 11:00:00	NVDA	Stock	5.7375	5.7525	5.6878	5.7159	55477440.0
2018-04-19 12:00:00	NVDA	Stock	5.7166	5.7488	5.6975	5.7305	40559280.0
2018-04-19 13:00:00	NVDA	Stock	5.7298	5.7323	5.6908	5.7063	39828280.0
2018-04-19 14:00:00	NVDA	Stock	5.7058	5.7135	5.67	5.7078	40565680.0
2018-04-19 15:00:00	NVDA	Stock	5.7082	5.7413	5.695	5.7262	63540880.0
2018-04-19 16:00:00	NVDA	Stock	5.726	5.7305	5.7155	5.717	21586120.0
2018-04-19 17:00:00	NVDA	Stock	5.717	5.725	5.71	5.7225	398080.0
2018-04-19 18:00:00	NVDA	Stock	5.7225	5.7225	5.7045	5.7125	385400.0
2018-04-19 19:00:00	NVDA	Stock	5.71	5.726	5.71	5.726	402320.0
2018-04-19 04:00:00	AMZN	Stock	77.9935	77.9935	77.75	77.75	10000.0
2018-04-19 05:00:00	AMZN	Stock	77.7315	77.7315	77.6505	77.6505	6320.0

> showing 50 of 48,104 rows — these rows as CSV

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