PREVIEW / stock_1hour / 2019-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-09.parquet
  size:    1.1 MB
  rows:    50,097
  symbols: 2,490

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-12-09 04:00:00	AAPL	Stock	67.5025	67.525	67.405	67.525	33092.0
2019-12-09 05:00:00	AAPL	Stock	67.5575	67.6	67.55	67.6	16088.0
2019-12-09 06:00:00	AAPL	Stock	67.5975	67.6	67.475	67.5	51272.0
2019-12-09 07:00:00	AAPL	Stock	67.5125	67.625	67.5	67.55	129004.0
2019-12-09 08:00:00	AAPL	Stock	67.5222	67.6375	67.475	67.555	400916.0
2019-12-09 09:00:00	AAPL	Stock	67.55	67.7	67.2875	67.3975	12824560.0
2019-12-09 10:00:00	AAPL	Stock	67.3975	67.4725	67.29	67.405	7554180.0
2019-12-09 11:00:00	AAPL	Stock	67.405	67.4075	66.485	66.56	19925280.0
2019-12-09 12:00:00	AAPL	Stock	66.56	66.625	66.2275	66.4205	24760148.0
2019-12-09 13:00:00	AAPL	Stock	66.4208	66.86	66.3975	66.805	12662584.0
2019-12-09 14:00:00	AAPL	Stock	66.8037	66.86	66.6075	66.7992	7836496.0
2019-12-09 15:00:00	AAPL	Stock	66.8	66.89	66.6525	66.73	11570516.0
2019-12-09 16:00:00	AAPL	Stock	66.73	66.7425	66.5875	66.6125	13331208.0
2019-12-09 17:00:00	AAPL	Stock	66.6175	66.73	66.585	66.6125	920800.0
2019-12-09 18:00:00	AAPL	Stock	66.6125	66.7125	66.605	66.645	81788.0
2019-12-09 19:00:00	AAPL	Stock	66.6675	66.7	66.64	66.7	43360.0
2019-12-09 04:00:00	MSFT	Stock	151.56	151.56	151.2	151.2	3515.0
2019-12-09 05:00:00	MSFT	Stock	151.1	151.44	151.1	151.37	1240.0
2019-12-09 06:00:00	MSFT	Stock	151.38	151.45	151.3	151.3	1002.0
2019-12-09 07:00:00	MSFT	Stock	151.3	151.36	151.03	151.03	13933.0
2019-12-09 08:00:00	MSFT	Stock	151.25	151.4	150.7	150.852	51452.0
2019-12-09 09:00:00	MSFT	Stock	150.93	152.21	150.82	152.01	2134449.0
2019-12-09 10:00:00	MSFT	Stock	152.01	152.085	151.665	151.75	1693218.0
2019-12-09 11:00:00	MSFT	Stock	151.75	151.9	151.42	151.859	1398568.0
2019-12-09 12:00:00	MSFT	Stock	151.855	152.09	151.67	151.8	981656.0
2019-12-09 13:00:00	MSFT	Stock	151.805	151.89	151.6	151.75	658016.0
2019-12-09 14:00:00	MSFT	Stock	151.74	151.774	151.26	151.461	1159701.0
2019-12-09 15:00:00	MSFT	Stock	151.47	151.63	151.22	151.36	1676325.0
2019-12-09 16:00:00	MSFT	Stock	151.36	151.815	151.06	151.1	3683182.0
2019-12-09 17:00:00	MSFT	Stock	151.19	151.36	151.1	151.24	29742.0
2019-12-09 18:00:00	MSFT	Stock	151.2	151.23	151.2	151.2	1617.0
2019-12-09 19:00:00	MSFT	Stock	151.23	151.34	151.23	151.34	12752.0
2019-12-09 04:00:00	NVDA	Stock	5.27	5.2775	5.27	5.2703	81720.0
2019-12-09 05:00:00	NVDA	Stock	5.275	5.2875	5.275	5.2805	32000.0
2019-12-09 06:00:00	NVDA	Stock	5.2825	5.2875	5.28	5.28	199200.0
2019-12-09 07:00:00	NVDA	Stock	5.2875	5.2918	5.282	5.2875	163720.0
2019-12-09 08:00:00	NVDA	Stock	5.275	5.2918	5.2675	5.275	362560.0
2019-12-09 09:00:00	NVDA	Stock	5.275	5.3525	5.2693	5.3334	37928760.0
2019-12-09 10:00:00	NVDA	Stock	5.334	5.3592	5.3285	5.3448	22903200.0
2019-12-09 11:00:00	NVDA	Stock	5.3443	5.3458	5.3078	5.3214	21731080.0
2019-12-09 12:00:00	NVDA	Stock	5.321	5.339	5.3188	5.3362	16247360.0
2019-12-09 13:00:00	NVDA	Stock	5.3358	5.3368	5.316	5.3208	17260240.0
2019-12-09 14:00:00	NVDA	Stock	5.3207	5.3231	5.3042	5.31	12646200.0
2019-12-09 15:00:00	NVDA	Stock	5.311	5.3198	5.3	5.303	25622640.0
2019-12-09 16:00:00	NVDA	Stock	5.3042	5.3242	5.2875	5.2966	33611040.0
2019-12-09 17:00:00	NVDA	Stock	5.2875	5.2975	5.2875	5.2875	86560.0
2019-12-09 18:00:00	NVDA	Stock	5.295	5.297	5.295	5.297	20880.0
2019-12-09 19:00:00	NVDA	Stock	5.3	5.3032	5.2913	5.2913	53760.0
2019-12-09 07:00:00	AMZN	Stock	87.597	87.6	87.555	87.555	8000.0
2019-12-09 08:00:00	AMZN	Stock	87.4055	87.5962	87.35	87.35	31920.0

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

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