PREVIEW / stock_1hour / 2017-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-11.parquet
  size:    1.1 MB
  rows:    49,319
  symbols: 2,959

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-11 04:00:00	AAPL	Stock	42.45	42.45	42.42	42.42	4000.0
2017-12-11 05:00:00	AAPL	Stock	42.4225	42.45	42.4225	42.45	6968.0
2017-12-11 06:00:00	AAPL	Stock	42.4225	42.4225	42.3875	42.3875	4196.0
2017-12-11 07:00:00	AAPL	Stock	42.425	42.4675	42.35	42.375	102152.0
2017-12-11 08:00:00	AAPL	Stock	42.425	42.4475	42.3375	42.355	107332.0
2017-12-11 09:00:00	AAPL	Stock	42.38	42.5455	42.1975	42.46	12684588.0
2017-12-11 10:00:00	AAPL	Stock	42.4575	43.045	42.385	42.9675	25884960.0
2017-12-11 11:00:00	AAPL	Stock	42.9688	43.05	42.8925	42.9475	13013428.0
2017-12-11 12:00:00	AAPL	Stock	42.9475	43.2225	42.9475	43.1975	10863448.0
2017-12-11 13:00:00	AAPL	Stock	43.2	43.2175	43.0575	43.08	8871924.0
2017-12-11 14:00:00	AAPL	Stock	43.0825	43.1225	43.02	43.115	8125572.0
2017-12-11 15:00:00	AAPL	Stock	43.1138	43.185	43.0525	43.165	15180768.0
2017-12-11 16:00:00	AAPL	Stock	43.1675	43.2	43.1375	43.195	30655884.0
2017-12-11 17:00:00	AAPL	Stock	43.17	43.2	43.1625	43.2	35804.0
2017-12-11 18:00:00	AAPL	Stock	43.195	43.195	43.155	43.1675	652268.0
2017-12-11 19:00:00	AAPL	Stock	43.155	43.1975	43.155	43.195	54864.0
2017-12-11 04:00:00	MSFT	Stock	84.17	84.17	84.17	84.17	421.0
2017-12-11 05:00:00	MSFT	Stock	84.17	84.17	84.17	84.17	115.0
2017-12-11 07:00:00	MSFT	Stock	84.29	84.45	84.29	84.35	5804.0
2017-12-11 08:00:00	MSFT	Stock	84.43	84.43	84.09	84.26	13639.0
2017-12-11 09:00:00	MSFT	Stock	84.29	84.61	84.12	84.6	2287274.0
2017-12-11 10:00:00	MSFT	Stock	84.6	84.7	84.424	84.525	1953945.0
2017-12-11 11:00:00	MSFT	Stock	84.53	84.87	84.48	84.836	1256373.0
2017-12-11 12:00:00	MSFT	Stock	84.84	85.22	84.82	85.2	1915441.0
2017-12-11 13:00:00	MSFT	Stock	85.204	85.37	85.055	85.33	1794222.0
2017-12-11 14:00:00	MSFT	Stock	85.33	85.33	84.94	85.035	1681327.0
2017-12-11 15:00:00	MSFT	Stock	85.03	85.26	84.933	85.22	3583905.0
2017-12-11 16:00:00	MSFT	Stock	85.23	85.35	85.23	85.35	5510437.0
2017-12-11 17:00:00	MSFT	Stock	85.35	85.49	85.35	85.48	22175.0
2017-12-11 18:00:00	MSFT	Stock	85.47	85.5	85.23	85.23	336804.0
2017-12-11 19:00:00	MSFT	Stock	85.55	85.59	85.55	85.59	6090.0
2017-12-11 04:00:00	NVDA	Stock	4.815	4.815	4.8025	4.815	104000.0
2017-12-11 05:00:00	NVDA	Stock	4.8038	4.8038	4.8038	4.8038	4920.0
2017-12-11 06:00:00	NVDA	Stock	4.804	4.804	4.8025	4.8025	26080.0
2017-12-11 07:00:00	NVDA	Stock	4.8	4.8125	4.7995	4.812	362800.0
2017-12-11 08:00:00	NVDA	Stock	4.8062	4.812	4.7938	4.8038	1198400.0
2017-12-11 09:00:00	NVDA	Stock	4.8025	4.8588	4.7938	4.8138	76472720.0
2017-12-11 10:00:00	NVDA	Stock	4.8138	4.8313	4.7952	4.7981	50688400.0
2017-12-11 11:00:00	NVDA	Stock	4.799	4.829	4.7855	4.8223	49173240.0
2017-12-11 12:00:00	NVDA	Stock	4.8217	4.8405	4.8215	4.8348	30999240.0
2017-12-11 13:00:00	NVDA	Stock	4.8347	4.8385	4.8145	4.82	24766760.0
2017-12-11 14:00:00	NVDA	Stock	4.8192	4.8435	4.8153	4.8405	25350280.0
2017-12-11 15:00:00	NVDA	Stock	4.8405	4.8695	4.8298	4.8665	58316160.0
2017-12-11 16:00:00	NVDA	Stock	4.8665	4.8698	4.865	4.8685	15237000.0
2017-12-11 17:00:00	NVDA	Stock	4.8682	4.8685	4.8553	4.8675	291240.0
2017-12-11 18:00:00	NVDA	Stock	4.8663	4.8688	4.8663	4.8688	313200.0
2017-12-11 19:00:00	NVDA	Stock	4.868	4.88	4.8675	4.87	1171800.0
2017-12-11 04:00:00	AMZN	Stock	58.1175	58.1175	58.1175	58.1175	10760.0
2017-12-11 07:00:00	AMZN	Stock	58.238	58.265	58.23	58.26	33400.0
2017-12-11 08:00:00	AMZN	Stock	58.275	58.2835	58.16	58.25	149680.0

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

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