PREVIEW / stock_1hour / 2017-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-29.parquet
  size:    1.1 MB
  rows:    50,077
  symbols: 2,927

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-12-29 05:00:00	AAPL	Stock	42.7	42.7	42.7	42.7	3600.0
2017-12-29 06:00:00	AAPL	Stock	42.7	42.7675	42.7	42.735	23532.0
2017-12-29 07:00:00	AAPL	Stock	42.735	42.8375	42.735	42.8075	94780.0
2017-12-29 08:00:00	AAPL	Stock	42.8125	42.8125	42.7	42.7	258184.0
2017-12-29 09:00:00	AAPL	Stock	42.7	42.7375	42.4275	42.4825	18522348.0
2017-12-29 10:00:00	AAPL	Stock	42.48	42.4875	42.3275	42.41	16595144.0
2017-12-29 11:00:00	AAPL	Stock	42.4075	42.5225	42.37	42.521	8931036.0
2017-12-29 12:00:00	AAPL	Stock	42.52	42.555	42.4975	42.5325	6713888.0
2017-12-29 13:00:00	AAPL	Stock	42.53	42.565	42.5	42.5075	5204900.0
2017-12-29 14:00:00	AAPL	Stock	42.51	42.515	42.48	42.4975	4421584.0
2017-12-29 15:00:00	AAPL	Stock	42.495	42.5225	42.305	42.325	17898840.0
2017-12-29 16:00:00	AAPL	Stock	42.3275	42.4025	42.2575	42.2825	14948432.0
2017-12-29 17:00:00	AAPL	Stock	42.2825	42.305	42.2625	42.2825	91040.0
2017-12-29 18:00:00	AAPL	Stock	42.265	42.2875	42.2625	42.275	48704.0
2017-12-29 19:00:00	AAPL	Stock	42.2625	42.275	42.2525	42.275	61264.0
2017-12-29 06:00:00	MSFT	Stock	85.99	85.99	85.99	85.99	100.0
2017-12-29 07:00:00	MSFT	Stock	85.97	85.97	85.95	85.95	600.0
2017-12-29 08:00:00	MSFT	Stock	85.77	85.98	85.77	85.8	5244.0
2017-12-29 09:00:00	MSFT	Stock	85.88	85.99	85.14	85.932	1578402.0
2017-12-29 10:00:00	MSFT	Stock	85.93	86.0	85.58	85.72	1296540.0
2017-12-29 11:00:00	MSFT	Stock	85.72	85.76	85.53	85.757	1047533.0
2017-12-29 12:00:00	MSFT	Stock	85.76	85.91	85.74	85.826	826944.0
2017-12-29 13:00:00	MSFT	Stock	85.82	85.94	85.73	85.93	1091525.0
2017-12-29 14:00:00	MSFT	Stock	85.93	85.99	85.84	85.96	838406.0
2017-12-29 15:00:00	MSFT	Stock	85.955	86.05	85.5	85.59	4518194.0
2017-12-29 16:00:00	MSFT	Stock	85.54	85.7	85.4	85.4	5445030.0
2017-12-29 17:00:00	MSFT	Stock	85.4	85.49	85.37	85.47	1954.0
2017-12-29 18:00:00	MSFT	Stock	85.34	85.47	85.34	85.47	2230.0
2017-12-29 19:00:00	MSFT	Stock	85.45	85.48	85.43	85.48	2111.0
2017-12-29 07:00:00	NVDA	Stock	4.9583	4.9623	4.95	4.95	111640.0
2017-12-29 08:00:00	NVDA	Stock	4.9623	4.9725	4.9522	4.9525	995400.0
2017-12-29 09:00:00	NVDA	Stock	4.955	4.966	4.9225	4.9252	30297640.0
2017-12-29 10:00:00	NVDA	Stock	4.9252	4.9295	4.8975	4.9055	42569560.0
2017-12-29 11:00:00	NVDA	Stock	4.9058	4.9072	4.8868	4.8931	26173200.0
2017-12-29 12:00:00	NVDA	Stock	4.8928	4.9083	4.8915	4.901	15824240.0
2017-12-29 13:00:00	NVDA	Stock	4.9011	4.9075	4.8903	4.8912	14361400.0
2017-12-29 14:00:00	NVDA	Stock	4.8915	4.8932	4.8688	4.871	33210640.0
2017-12-29 15:00:00	NVDA	Stock	4.8712	4.8818	4.8375	4.8388	76241360.0
2017-12-29 16:00:00	NVDA	Stock	4.8375	4.842	4.8288	4.8373	21080560.0
2017-12-29 17:00:00	NVDA	Stock	4.832	4.8375	4.83	4.8313	373240.0
2017-12-29 18:00:00	NVDA	Stock	4.8368	4.8368	4.8313	4.8368	76640.0
2017-12-29 19:00:00	NVDA	Stock	4.8375	4.8425	4.837	4.8418	351840.0
2017-12-29 06:00:00	AMZN	Stock	59.375	59.375	59.375	59.375	2000.0
2017-12-29 07:00:00	AMZN	Stock	59.3	59.4725	59.3	59.47	24700.0
2017-12-29 08:00:00	AMZN	Stock	59.41	59.41	58.9995	59.1055	413880.0
2017-12-29 09:00:00	AMZN	Stock	59.1495	59.226	58.9225	59.0093	6296080.0
2017-12-29 10:00:00	AMZN	Stock	59.001	59.1175	58.925	58.971	4894320.0
2017-12-29 11:00:00	AMZN	Stock	58.971	58.99	58.863	58.9415	3471580.0
2017-12-29 12:00:00	AMZN	Stock	58.9505	58.9875	58.767	58.8015	3612860.0
2017-12-29 13:00:00	AMZN	Stock	58.8065	58.8095	58.6125	58.6345	3484280.0

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

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