PREVIEW / stock_1hour / 2018-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-04.parquet
  size:    1.1 MB
  rows:    50,154
  symbols: 2,794

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-10-04 04:00:00	AAPL	Stock	57.625	57.7	57.625	57.6275	23744.0
2018-10-04 05:00:00	AAPL	Stock	57.6325	57.6325	57.445	57.575	32492.0
2018-10-04 06:00:00	AAPL	Stock	57.6625	57.675	57.5875	57.675	46760.0
2018-10-04 07:00:00	AAPL	Stock	57.72	57.895	57.615	57.69	379060.0
2018-10-04 08:00:00	AAPL	Stock	57.6812	58.0175	57.4875	57.6875	769028.0
2018-10-04 09:00:00	AAPL	Stock	57.6875	58.0875	57.2675	57.4825	19563280.0
2018-10-04 10:00:00	AAPL	Stock	57.4775	57.5825	57.2825	57.31	15358392.0
2018-10-04 11:00:00	AAPL	Stock	57.3	57.49	56.955	57.0375	13514900.0
2018-10-04 12:00:00	AAPL	Stock	57.0375	57.2175	56.825	56.9875	12649556.0
2018-10-04 13:00:00	AAPL	Stock	56.9825	57.085	56.82	56.9255	8929296.0
2018-10-04 14:00:00	AAPL	Stock	56.9225	57.1225	56.6825	57.07	11747676.0
2018-10-04 15:00:00	AAPL	Stock	57.0675	57.155	56.8472	56.9975	13503484.0
2018-10-04 16:00:00	AAPL	Stock	56.9975	57.0625	56.9475	57.06	9581456.0
2018-10-04 17:00:00	AAPL	Stock	57.0625	57.075	57.0375	57.0625	64068.0
2018-10-04 18:00:00	AAPL	Stock	57.065	57.065	57.0	57.0	48324.0
2018-10-04 19:00:00	AAPL	Stock	57.005	57.025	56.9825	57.025	40228.0
2018-10-04 05:00:00	MSFT	Stock	114.68	114.68	114.68	114.68	776.0
2018-10-04 07:00:00	MSFT	Stock	114.65	114.75	114.53	114.72	11284.0
2018-10-04 08:00:00	MSFT	Stock	114.675	115.45	114.53	114.74	123474.0
2018-10-04 09:00:00	MSFT	Stock	114.74	114.9	113.76	114.073	3344923.0
2018-10-04 10:00:00	MSFT	Stock	114.07	114.1	112.93	113.29	4120979.0
2018-10-04 11:00:00	MSFT	Stock	113.28	113.59	112.9	112.965	3205100.0
2018-10-04 12:00:00	MSFT	Stock	112.96	113.01	112.26	112.29	3748615.0
2018-10-04 13:00:00	MSFT	Stock	112.29	112.495	111.63	111.76	4141677.0
2018-10-04 14:00:00	MSFT	Stock	111.75	112.635	111.69	112.455	3380364.0
2018-10-04 15:00:00	MSFT	Stock	112.46	112.97	112.19	112.85	5022725.0
2018-10-04 16:00:00	MSFT	Stock	112.79	112.9	112.77	112.82	3751970.0
2018-10-04 17:00:00	MSFT	Stock	112.9	112.96	112.85	112.96	7427.0
2018-10-04 18:00:00	MSFT	Stock	112.96	112.96	112.82	112.82	5079.0
2018-10-04 19:00:00	MSFT	Stock	112.85	113.09	112.85	112.91	4316.0
2018-10-04 07:00:00	NVDA	Stock	7.1375	7.1375	7.1148	7.1148	126240.0
2018-10-04 08:00:00	NVDA	Stock	7.145	7.145	7.1035	7.1368	524920.0
2018-10-04 09:00:00	NVDA	Stock	7.1362	7.1562	7.0635	7.1058	41880680.0
2018-10-04 10:00:00	NVDA	Stock	7.1038	7.1065	7.0365	7.0465	57403360.0
2018-10-04 11:00:00	NVDA	Stock	7.0455	7.0896	6.9862	6.9862	42350680.0
2018-10-04 12:00:00	NVDA	Stock	6.9868	6.995	6.917	6.941	57166160.0
2018-10-04 13:00:00	NVDA	Stock	6.9402	6.9498	6.9045	6.9148	26916920.0
2018-10-04 14:00:00	NVDA	Stock	6.9164	6.986	6.911	6.9649	33309040.0
2018-10-04 15:00:00	NVDA	Stock	6.964	7.0025	6.9485	6.982	47841600.0
2018-10-04 16:00:00	NVDA	Stock	6.9822	7.0085	6.98	6.989	17011200.0
2018-10-04 17:00:00	NVDA	Stock	6.989	7.0	6.989	7.0	91200.0
2018-10-04 18:00:00	NVDA	Stock	7.0	7.01	6.9822	6.9875	278680.0
2018-10-04 19:00:00	NVDA	Stock	6.9975	6.9975	6.99	6.99	97840.0
2018-10-04 04:00:00	AMZN	Stock	97.4	97.4	97.1	97.123	19580.0
2018-10-04 05:00:00	AMZN	Stock	97.05	97.189	97.0025	97.1	39100.0
2018-10-04 06:00:00	AMZN	Stock	97.1815	97.1815	97.1815	97.1815	2000.0
2018-10-04 07:00:00	AMZN	Stock	97.3395	97.4895	97.2285	97.2285	131600.0
2018-10-04 08:00:00	AMZN	Stock	97.3495	97.88	97.175	97.3557	409960.0
2018-10-04 09:00:00	AMZN	Stock	97.4	97.8	96.411	96.9093	21731440.0
2018-10-04 10:00:00	AMZN	Stock	96.8834	96.9628	95.8395	95.8735	23809480.0

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

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