PREVIEW / stock_1hour / 2017-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-26.parquet
  size:    1.0 MB
  rows:    48,980
  symbols: 3,029

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
2017-06-26 05:00:00	AAPL	Stock	36.6925	36.6925	36.6925	36.6925	3888.0
2017-06-26 06:00:00	AAPL	Stock	36.65	36.68	36.65	36.6525	9216.0
2017-06-26 07:00:00	AAPL	Stock	36.6725	36.785	36.665	36.7625	152856.0
2017-06-26 08:00:00	AAPL	Stock	36.755	36.8125	36.665	36.8075	341020.0
2017-06-26 09:00:00	AAPL	Stock	36.8075	37.07	36.775	36.99	15259500.0
2017-06-26 10:00:00	AAPL	Stock	36.9925	37.0	36.54	36.625	19418496.0
2017-06-26 11:00:00	AAPL	Stock	36.625	36.63	36.345	36.4688	16263176.0
2017-06-26 12:00:00	AAPL	Stock	36.4675	36.6225	36.4025	36.5825	8354320.0
2017-06-26 13:00:00	AAPL	Stock	36.5825	36.6025	36.5075	36.55	5044456.0
2017-06-26 14:00:00	AAPL	Stock	36.55	36.565	36.4338	36.4873	6198736.0
2017-06-26 15:00:00	AAPL	Stock	36.4875	36.5175	36.4175	36.45	13503836.0
2017-06-26 16:00:00	AAPL	Stock	36.455	36.5	36.45	36.475	9691368.0
2017-06-26 17:00:00	AAPL	Stock	36.475	36.4925	36.465	36.4675	41356.0
2017-06-26 18:00:00	AAPL	Stock	36.47	36.475	36.455	36.475	25264.0
2017-06-26 19:00:00	AAPL	Stock	36.4875	36.4875	36.4625	36.47	12356.0
2017-06-26 07:00:00	MSFT	Stock	71.45	71.51	71.4	71.51	9398.0
2017-06-26 08:00:00	MSFT	Stock	71.36	71.59	71.35	71.55	6860.0
2017-06-26 09:00:00	MSFT	Stock	71.54	71.71	71.37	71.51	2311288.0
2017-06-26 10:00:00	MSFT	Stock	71.52	71.57	70.89	71.0	3283089.0
2017-06-26 11:00:00	MSFT	Stock	71.0	71.04	70.7	70.89	1946212.0
2017-06-26 12:00:00	MSFT	Stock	70.89	71.016	70.735	70.963	1312674.0
2017-06-26 13:00:00	MSFT	Stock	70.97	70.98	70.76	70.81	1387038.0
2017-06-26 14:00:00	MSFT	Stock	70.81	70.83	70.616	70.64	1454934.0
2017-06-26 15:00:00	MSFT	Stock	70.64	70.7	70.445	70.52	4084429.0
2017-06-26 16:00:00	MSFT	Stock	70.53	70.6	70.49	70.6	2403546.0
2017-06-26 17:00:00	MSFT	Stock	70.51	70.53	70.51	70.53	98396.0
2017-06-26 04:00:00	NVDA	Stock	3.874	3.8975	3.8725	3.8975	134160.0
2017-06-26 06:00:00	NVDA	Stock	3.8928	3.8948	3.8755	3.8788	191520.0
2017-06-26 07:00:00	NVDA	Stock	3.885	3.885	3.8623	3.8725	706360.0
2017-06-26 08:00:00	NVDA	Stock	3.875	3.8922	3.8625	3.8898	4023200.0
2017-06-26 09:00:00	NVDA	Stock	3.8892	3.915	3.8475	3.8617	126323760.0
2017-06-26 10:00:00	NVDA	Stock	3.8608	3.8658	3.739	3.7535	265983720.0
2017-06-26 11:00:00	NVDA	Stock	3.7525	3.8038	3.7083	3.7988	241648920.0
2017-06-26 12:00:00	NVDA	Stock	3.799	3.8212	3.7828	3.8044	117111720.0
2017-06-26 13:00:00	NVDA	Stock	3.804	3.8085	3.7732	3.7988	77854080.0
2017-06-26 14:00:00	NVDA	Stock	3.7975	3.8185	3.78	3.8088	86299880.0
2017-06-26 15:00:00	NVDA	Stock	3.8098	3.815	3.7868	3.8035	125864600.0
2017-06-26 16:00:00	NVDA	Stock	3.803	3.8045	3.8	3.8045	7508600.0
2017-06-26 17:00:00	NVDA	Stock	3.8045	3.8083	3.8025	3.8028	482040.0
2017-06-26 18:00:00	NVDA	Stock	3.8038	3.81	3.8025	3.8062	314400.0
2017-06-26 19:00:00	NVDA	Stock	3.8062	3.8118	3.8042	3.8108	138760.0
2017-06-26 04:00:00	AMZN	Stock	50.201	50.25	50.201	50.25	14000.0
2017-06-26 07:00:00	AMZN	Stock	50.275	50.35	50.275	50.35	91500.0
2017-06-26 08:00:00	AMZN	Stock	50.34	50.5545	50.275	50.4675	377380.0
2017-06-26 09:00:00	AMZN	Stock	50.455	50.49	50.2115	50.31	10044800.0
2017-06-26 10:00:00	AMZN	Stock	50.3124	50.3145	49.803	49.8675	11825880.0
2017-06-26 11:00:00	AMZN	Stock	49.8945	50.457	49.669	49.9665	8296440.0
2017-06-26 12:00:00	AMZN	Stock	49.9715	50.0155	49.809	49.955	4513520.0
2017-06-26 13:00:00	AMZN	Stock	49.951	49.959	49.802	49.853	3392140.0
2017-06-26 14:00:00	AMZN	Stock	49.8418	49.8595	49.751	49.7917	3692540.0

> showing 50 of 48,980 rows — these rows as CSV

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