PREVIEW / stock_1hour / 2019-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-24.parquet
  size:    1.1 MB
  rows:    50,419
  symbols: 2,613

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
2019-04-24 04:00:00	AAPL	Stock	51.905	52.04	51.8825	51.9625	40448.0
2019-04-24 06:00:00	AAPL	Stock	51.9975	52.025	51.9975	51.9975	5880.0
2019-04-24 07:00:00	AAPL	Stock	52.0075	52.03	51.9125	51.9725	156092.0
2019-04-24 08:00:00	AAPL	Stock	52.0275	52.036	51.8875	51.9225	242608.0
2019-04-24 09:00:00	AAPL	Stock	51.9375	52.1	51.805	51.86	14902964.0
2019-04-24 10:00:00	AAPL	Stock	51.8575	52.0525	51.7625	52.0425	9175080.0
2019-04-24 11:00:00	AAPL	Stock	52.045	52.12	51.8775	51.9475	6974292.0
2019-04-24 12:00:00	AAPL	Stock	51.945	51.9612	51.82	51.8225	4475948.0
2019-04-24 13:00:00	AAPL	Stock	51.82	51.945	51.79	51.875	4426248.0
2019-04-24 14:00:00	AAPL	Stock	51.875	51.995	51.8575	51.9532	3734328.0
2019-04-24 15:00:00	AAPL	Stock	51.9538	51.985	51.7725	51.795	9516948.0
2019-04-24 16:00:00	AAPL	Stock	51.79	52.0	51.7625	51.975	7902144.0
2019-04-24 17:00:00	AAPL	Stock	51.975	52.1125	51.79	52.0025	479328.0
2019-04-24 18:00:00	AAPL	Stock	52.0025	52.0125	51.975	51.975	146824.0
2019-04-24 19:00:00	AAPL	Stock	51.975	52.0	51.975	52.0	42712.0
2019-04-24 04:00:00	MSFT	Stock	125.6	125.6	125.58	125.6	1190.0
2019-04-24 05:00:00	MSFT	Stock	125.64	125.8	125.64	125.8	3534.0
2019-04-24 06:00:00	MSFT	Stock	125.72	125.9	125.72	125.85	5482.0
2019-04-24 07:00:00	MSFT	Stock	125.81	125.96	125.74	125.9	33655.0
2019-04-24 08:00:00	MSFT	Stock	125.9	126.1	125.732	125.93	70322.0
2019-04-24 09:00:00	MSFT	Stock	125.91	125.94	124.52	124.85	3944847.0
2019-04-24 10:00:00	MSFT	Stock	124.845	125.42	124.7	125.17	3357522.0
2019-04-24 11:00:00	MSFT	Stock	125.18	125.25	124.875	124.94	2379958.0
2019-04-24 12:00:00	MSFT	Stock	124.943	125.19	124.86	125.036	1730762.0
2019-04-24 13:00:00	MSFT	Stock	125.04	125.17	124.99	125.07	1189014.0
2019-04-24 14:00:00	MSFT	Stock	125.06	125.28	125.005	125.23	1787718.0
2019-04-24 15:00:00	MSFT	Stock	125.23	125.46	125.0	125.09	4830262.0
2019-04-24 16:00:00	MSFT	Stock	125.07	129.25	124.85	128.75	5844333.0
2019-04-24 17:00:00	MSFT	Stock	128.75	130.3	125.01	130.23	528371.0
2019-04-24 18:00:00	MSFT	Stock	130.03	130.87	129.85	129.91	320436.0
2019-04-24 19:00:00	MSFT	Stock	129.91	129.95	129.23	129.35	82777.0
2019-04-24 04:00:00	NVDA	Stock	4.762	4.7972	4.762	4.7972	36600.0
2019-04-24 05:00:00	NVDA	Stock	4.7875	4.8025	4.7875	4.8	63960.0
2019-04-24 06:00:00	NVDA	Stock	4.7992	4.8025	4.7868	4.7868	57560.0
2019-04-24 07:00:00	NVDA	Stock	4.7825	4.8	4.7775	4.7938	387920.0
2019-04-24 08:00:00	NVDA	Stock	4.7925	4.7975	4.7778	4.7858	2431040.0
2019-04-24 09:00:00	NVDA	Stock	4.7845	4.786	4.716	4.7492	65175200.0
2019-04-24 10:00:00	NVDA	Stock	4.7513	4.792	4.7362	4.7872	46162160.0
2019-04-24 11:00:00	NVDA	Stock	4.7875	4.8093	4.7755	4.7792	45357640.0
2019-04-24 12:00:00	NVDA	Stock	4.7785	4.8	4.7712	4.7752	25923800.0
2019-04-24 13:00:00	NVDA	Stock	4.7742	4.8008	4.7734	4.796	19963120.0
2019-04-24 14:00:00	NVDA	Stock	4.7958	4.819	4.7898	4.817	21978520.0
2019-04-24 15:00:00	NVDA	Stock	4.8173	4.8203	4.778	4.7792	34388320.0
2019-04-24 16:00:00	NVDA	Stock	4.7792	4.81	4.725	4.745	16185160.0
2019-04-24 17:00:00	NVDA	Stock	4.7475	4.7792	4.7362	4.772	667320.0
2019-04-24 18:00:00	NVDA	Stock	4.7627	4.7675	4.7627	4.765	8212400.0
2019-04-24 19:00:00	NVDA	Stock	4.7685	4.7725	4.7565	4.7678	378440.0
2019-04-24 05:00:00	AMZN	Stock	96.24	96.2685	96.24	96.256	8000.0
2019-04-24 07:00:00	AMZN	Stock	96.33	96.65	96.325	96.475	267400.0
2019-04-24 08:00:00	AMZN	Stock	96.35	96.6115	96.3085	96.35	354080.0

> showing 50 of 50,419 rows — these rows as CSV

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