PREVIEW / stock_1hour / 2018-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-25.parquet
  size:    1.1 MB
  rows:    49,718
  symbols: 2,888

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-01-25 04:00:00	AAPL	Stock	43.6725	43.7125	43.64	43.7125	19072.0
2018-01-25 05:00:00	AAPL	Stock	43.6975	43.7675	43.6975	43.7625	12944.0
2018-01-25 06:00:00	AAPL	Stock	43.7425	43.775	43.7125	43.7125	42488.0
2018-01-25 07:00:00	AAPL	Stock	43.715	43.8075	43.7	43.7675	111184.0
2018-01-25 08:00:00	AAPL	Stock	43.77	43.7875	43.6725	43.715	373512.0
2018-01-25 09:00:00	AAPL	Stock	43.7325	43.74	43.1175	43.27	18643644.0
2018-01-25 10:00:00	AAPL	Stock	43.275	43.355	43.065	43.2675	21222500.0
2018-01-25 11:00:00	AAPL	Stock	43.2688	43.3938	43.2438	43.38	13556636.0
2018-01-25 12:00:00	AAPL	Stock	43.38	43.425	43.16	43.16	10966388.0
2018-01-25 13:00:00	AAPL	Stock	43.16	43.1975	43.0375	43.085	12263344.0
2018-01-25 14:00:00	AAPL	Stock	43.0875	43.0875	42.695	42.8025	25877340.0
2018-01-25 15:00:00	AAPL	Stock	42.805	42.8375	42.6325	42.775	31166320.0
2018-01-25 16:00:00	AAPL	Stock	42.7775	42.855	42.775	42.85	12345152.0
2018-01-25 17:00:00	AAPL	Stock	42.85	42.855	42.7775	42.8525	104552.0
2018-01-25 18:00:00	AAPL	Stock	42.8525	42.9325	42.85	42.91	160792.0
2018-01-25 19:00:00	AAPL	Stock	42.9125	42.9375	42.875	42.9375	72356.0
2018-01-25 06:00:00	MSFT	Stock	92.35	92.45	92.23	92.45	3097.0
2018-01-25 07:00:00	MSFT	Stock	92.29	92.55	92.29	92.42	4284.0
2018-01-25 08:00:00	MSFT	Stock	92.405	92.65	91.82	92.54	36071.0
2018-01-25 09:00:00	MSFT	Stock	92.57	92.68	91.93	92.06	3322132.0
2018-01-25 10:00:00	MSFT	Stock	92.07	92.59	91.96	92.411	3626553.0
2018-01-25 11:00:00	MSFT	Stock	92.42	93.0	92.35	92.99	3254813.0
2018-01-25 12:00:00	MSFT	Stock	92.981	93.24	92.77	92.78	2684362.0
2018-01-25 13:00:00	MSFT	Stock	92.77	92.82	92.6	92.68	1607115.0
2018-01-25 14:00:00	MSFT	Stock	92.68	92.78	92.19	92.225	2205509.0
2018-01-25 15:00:00	MSFT	Stock	92.24	92.47	92.03	92.32	3192359.0
2018-01-25 16:00:00	MSFT	Stock	92.33	92.55	92.33	92.5	3746570.0
2018-01-25 17:00:00	MSFT	Stock	92.5	92.56	92.33	92.56	3703.0
2018-01-25 18:00:00	MSFT	Stock	92.56	92.95	92.41	92.95	2814.0
2018-01-25 19:00:00	MSFT	Stock	92.55	92.79	92.55	92.6	933.0
2018-01-25 04:00:00	NVDA	Stock	5.9215	5.95	5.9215	5.95	25280.0
2018-01-25 05:00:00	NVDA	Stock	5.95	5.95	5.95	5.95	29640.0
2018-01-25 06:00:00	NVDA	Stock	5.9525	5.9525	5.93	5.9392	198000.0
2018-01-25 07:00:00	NVDA	Stock	5.9375	5.9575	5.9373	5.95	1122800.0
2018-01-25 08:00:00	NVDA	Stock	5.9375	5.961	5.9373	5.957	2429240.0
2018-01-25 09:00:00	NVDA	Stock	5.9575	5.9938	5.8938	5.9106	73451960.0
2018-01-25 10:00:00	NVDA	Stock	5.9088	5.975	5.9045	5.949	70080840.0
2018-01-25 11:00:00	NVDA	Stock	5.9475	5.972	5.9215	5.9695	48209760.0
2018-01-25 12:00:00	NVDA	Stock	5.97	5.9775	5.9295	5.9314	34068520.0
2018-01-25 13:00:00	NVDA	Stock	5.9305	5.961	5.9085	5.9513	47457920.0
2018-01-25 14:00:00	NVDA	Stock	5.953	5.9583	5.905	5.92	36685880.0
2018-01-25 15:00:00	NVDA	Stock	5.9198	5.931	5.9042	5.9085	44506480.0
2018-01-25 16:00:00	NVDA	Stock	5.9088	5.9488	5.9088	5.925	12793040.0
2018-01-25 17:00:00	NVDA	Stock	5.9263	5.936	5.9205	5.93	489120.0
2018-01-25 18:00:00	NVDA	Stock	5.9298	5.93	5.9213	5.93	369040.0
2018-01-25 19:00:00	NVDA	Stock	5.9275	5.9338	5.9275	5.9338	290680.0
2018-01-25 05:00:00	AMZN	Stock	68.3345	68.3345	68.261	68.261	8000.0
2018-01-25 06:00:00	AMZN	Stock	68.271	68.3	68.269	68.3	10820.0
2018-01-25 07:00:00	AMZN	Stock	68.3	68.5775	68.3	68.5495	217500.0
2018-01-25 08:00:00	AMZN	Stock	68.5495	68.6	68.01	68.488	428700.0

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

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