PREVIEW / stock_1hour / 2018-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-06.parquet
  size:    1.1 MB
  rows:    48,663
  symbols: 2,804

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-08-06 04:00:00	AAPL	Stock	52.0175	52.06	51.925	51.925	8032.0
2018-08-06 05:00:00	AAPL	Stock	51.92	52.0	51.8875	52.0	16864.0
2018-08-06 06:00:00	AAPL	Stock	52.0	52.05	52.0	52.0	20708.0
2018-08-06 07:00:00	AAPL	Stock	52.03	52.0775	52.02	52.0425	159140.0
2018-08-06 08:00:00	AAPL	Stock	52.075	52.0775	51.9575	51.98	419992.0
2018-08-06 09:00:00	AAPL	Stock	51.975	52.26	51.8775	52.05	17693844.0
2018-08-06 10:00:00	AAPL	Stock	52.05	52.0725	51.83	51.91	13799484.0
2018-08-06 11:00:00	AAPL	Stock	51.91	52.075	51.7675	52.045	8757108.0
2018-08-06 12:00:00	AAPL	Stock	52.0475	52.2525	52.02	52.175	8887764.0
2018-08-06 13:00:00	AAPL	Stock	52.175	52.2925	52.13	52.1755	10314244.0
2018-08-06 14:00:00	AAPL	Stock	52.176	52.3025	52.145	52.2725	7890184.0
2018-08-06 15:00:00	AAPL	Stock	52.2732	52.3125	52.1925	52.265	13633696.0
2018-08-06 16:00:00	AAPL	Stock	52.2675	52.2725	52.1498	52.2725	8156840.0
2018-08-06 17:00:00	AAPL	Stock	52.25	52.2625	52.2375	52.2625	25168.0
2018-08-06 18:00:00	AAPL	Stock	52.26	52.26	52.23	52.23	15548.0
2018-08-06 19:00:00	AAPL	Stock	52.2375	52.2825	52.2275	52.265	45152.0
2018-08-06 04:00:00	MSFT	Stock	108.1	108.1	108.0	108.0	350.0
2018-08-06 05:00:00	MSFT	Stock	108.15	108.15	108.05	108.15	2408.0
2018-08-06 06:00:00	MSFT	Stock	108.3	108.3	108.3	108.3	1600.0
2018-08-06 07:00:00	MSFT	Stock	108.23	108.39	108.23	108.35	4861.0
2018-08-06 08:00:00	MSFT	Stock	108.38	108.38	108.14	108.17	24680.0
2018-08-06 09:00:00	MSFT	Stock	108.14	108.3	107.6	108.15	2083610.0
2018-08-06 10:00:00	MSFT	Stock	108.16	108.42	107.82	107.885	2023031.0
2018-08-06 11:00:00	MSFT	Stock	107.885	107.95	107.559	107.89	1144003.0
2018-08-06 12:00:00	MSFT	Stock	107.89	108.13	107.88	108.075	1261964.0
2018-08-06 13:00:00	MSFT	Stock	108.075	108.25	107.83	107.87	1190906.0
2018-08-06 14:00:00	MSFT	Stock	107.873	108.13	107.86	108.051	953473.0
2018-08-06 15:00:00	MSFT	Stock	108.05	108.27	108.0	108.13	2092975.0
2018-08-06 16:00:00	MSFT	Stock	108.13	108.13	108.01	108.02	6660908.0
2018-08-06 17:00:00	MSFT	Stock	108.02	108.117	107.95	108.0	25249.0
2018-08-06 18:00:00	MSFT	Stock	107.88	108.09	107.88	108.09	3692.0
2018-08-06 19:00:00	MSFT	Stock	108.11	108.11	108.01	108.06	787.0
2018-08-06 07:00:00	NVDA	Stock	6.303	6.3062	6.3	6.3	86920.0
2018-08-06 08:00:00	NVDA	Stock	6.3	6.3	6.275	6.2862	257520.0
2018-08-06 09:00:00	NVDA	Stock	6.2862	6.2985	6.2426	6.2708	31828040.0
2018-08-06 10:00:00	NVDA	Stock	6.272	6.3042	6.261	6.2635	28952400.0
2018-08-06 11:00:00	NVDA	Stock	6.264	6.2922	6.2568	6.2875	15102640.0
2018-08-06 12:00:00	NVDA	Stock	6.2872	6.3165	6.2862	6.3155	19545920.0
2018-08-06 13:00:00	NVDA	Stock	6.3158	6.347	6.3128	6.3292	24081120.0
2018-08-06 14:00:00	NVDA	Stock	6.3285	6.337	6.3182	6.331	16556960.0
2018-08-06 15:00:00	NVDA	Stock	6.3309	6.3543	6.3278	6.3523	39819040.0
2018-08-06 16:00:00	NVDA	Stock	6.3508	6.3575	6.348	6.357	1162640.0
2018-08-06 17:00:00	NVDA	Stock	6.3548	6.3548	6.3428	6.3428	154280.0
2018-08-06 18:00:00	NVDA	Stock	6.3488	6.35	6.345	6.345	115680.0
2018-08-06 19:00:00	NVDA	Stock	6.3438	6.3438	6.3385	6.3438	68800.0
2018-08-06 04:00:00	AMZN	Stock	91.5	91.5	91.5	91.5	16780.0
2018-08-06 05:00:00	AMZN	Stock	91.295	91.394	91.295	91.394	8400.0
2018-08-06 06:00:00	AMZN	Stock	91.5	91.58	91.5	91.58	17300.0
2018-08-06 07:00:00	AMZN	Stock	91.4565	91.5335	91.4375	91.4375	72020.0
2018-08-06 08:00:00	AMZN	Stock	91.5	91.5	91.171	91.247	209060.0

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

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