PREVIEW / stock_1hour / 2018-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-19.parquet
  size:    1.1 MB
  rows:    49,614
  symbols: 2,773

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-09-19 04:00:00	AAPL	Stock	54.625	54.6825	54.625	54.6625	10304.0
2018-09-19 05:00:00	AAPL	Stock	54.6475	54.6475	54.6475	54.6475	1200.0
2018-09-19 06:00:00	AAPL	Stock	54.65	54.71	54.64	54.6725	17608.0
2018-09-19 07:00:00	AAPL	Stock	54.685	54.71	54.525	54.525	96016.0
2018-09-19 08:00:00	AAPL	Stock	54.6725	54.6725	54.4625	54.625	305780.0
2018-09-19 09:00:00	AAPL	Stock	54.625	54.905	54.0515	54.0888	15719264.0
2018-09-19 10:00:00	AAPL	Stock	54.0898	54.22	53.825	54.0575	20928804.0
2018-09-19 11:00:00	AAPL	Stock	54.0625	54.5275	54.0075	54.5225	13838752.0
2018-09-19 12:00:00	AAPL	Stock	54.5175	54.575	54.375	54.4988	8500412.0
2018-09-19 13:00:00	AAPL	Stock	54.4975	54.5	54.375	54.45	5548968.0
2018-09-19 14:00:00	AAPL	Stock	54.4475	54.515	54.3275	54.3475	6224892.0
2018-09-19 15:00:00	AAPL	Stock	54.3475	54.695	54.345	54.585	12641932.0
2018-09-19 16:00:00	AAPL	Stock	54.595	54.775	54.5925	54.7125	8562572.0
2018-09-19 17:00:00	AAPL	Stock	54.685	54.6875	54.6275	54.675	30248.0
2018-09-19 18:00:00	AAPL	Stock	54.6875	54.6975	54.635	54.695	38784.0
2018-09-19 19:00:00	AAPL	Stock	54.6625	54.72	54.64	54.7	46876.0
2018-09-19 04:00:00	MSFT	Stock	113.09	113.09	112.96	113.0	4492.0
2018-09-19 05:00:00	MSFT	Stock	113.0	113.0	112.75	112.75	2062.0
2018-09-19 06:00:00	MSFT	Stock	112.76	112.76	112.13	112.25	5260.0
2018-09-19 07:00:00	MSFT	Stock	112.44	112.45	112.15	112.25	32425.0
2018-09-19 08:00:00	MSFT	Stock	112.45	113.49	112.18	112.63	39111.0
2018-09-19 09:00:00	MSFT	Stock	112.64	113.32	111.74	111.87	3008926.0
2018-09-19 10:00:00	MSFT	Stock	111.865	112.11	111.5	111.63	3420537.0
2018-09-19 11:00:00	MSFT	Stock	111.64	112.265	111.52	111.88	2229866.0
2018-09-19 12:00:00	MSFT	Stock	111.87	111.89	111.05	111.27	2088791.0
2018-09-19 13:00:00	MSFT	Stock	111.26	111.571	111.035	111.555	1530724.0
2018-09-19 14:00:00	MSFT	Stock	111.55	111.58	111.42	111.489	1171745.0
2018-09-19 15:00:00	MSFT	Stock	111.48	111.95	111.475	111.7	3136151.0
2018-09-19 16:00:00	MSFT	Stock	111.7	111.74	111.472	111.72	3091386.0
2018-09-19 17:00:00	MSFT	Stock	111.7	111.738	111.7	111.72	2456.0
2018-09-19 18:00:00	MSFT	Stock	111.88	111.88	111.7	111.87	10300.0
2018-09-19 19:00:00	MSFT	Stock	111.75	111.9	111.75	111.88	7043.0
2018-09-19 06:00:00	NVDA	Stock	6.777	6.777	6.775	6.775	29400.0
2018-09-19 07:00:00	NVDA	Stock	6.785	6.785	6.7713	6.7713	110240.0
2018-09-19 08:00:00	NVDA	Stock	6.7875	6.7875	6.7478	6.7525	761000.0
2018-09-19 09:00:00	NVDA	Stock	6.765	6.8175	6.7223	6.7819	26789840.0
2018-09-19 10:00:00	NVDA	Stock	6.783	6.8038	6.724	6.7488	26982920.0
2018-09-19 11:00:00	NVDA	Stock	6.7498	6.8092	6.7421	6.7775	19051520.0
2018-09-19 12:00:00	NVDA	Stock	6.7788	6.779	6.7062	6.7468	21103680.0
2018-09-19 13:00:00	NVDA	Stock	6.746	6.7502	6.7248	6.7468	12001800.0
2018-09-19 14:00:00	NVDA	Stock	6.746	6.7692	6.7418	6.7652	18429960.0
2018-09-19 15:00:00	NVDA	Stock	6.764	6.8025	6.7632	6.7972	42777040.0
2018-09-19 16:00:00	NVDA	Stock	6.7995	6.8032	6.788	6.7892	13244600.0
2018-09-19 17:00:00	NVDA	Stock	6.7985	6.7992	6.7925	6.7972	96640.0
2018-09-19 18:00:00	NVDA	Stock	6.798	6.8038	6.795	6.8012	177560.0
2018-09-19 19:00:00	NVDA	Stock	6.8	6.8042	6.7998	6.8042	134640.0
2018-09-19 04:00:00	AMZN	Stock	97.35	97.35	97.3	97.3	17900.0
2018-09-19 06:00:00	AMZN	Stock	97.0	97.1	96.996	97.1	22000.0
2018-09-19 07:00:00	AMZN	Stock	97.1	97.15	96.7875	96.805	156000.0
2018-09-19 08:00:00	AMZN	Stock	97.1	97.29	96.75	97.0505	246720.0

> showing 50 of 49,614 rows — these rows as CSV

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