PREVIEW / stock_1hour / 2017-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-21.parquet
  size:    1.1 MB
  rows:    49,268
  symbols: 2,937

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-21 04:00:00	AAPL	Stock	43.5	43.5	43.5	43.5	400.0
2017-12-21 05:00:00	AAPL	Stock	43.4575	43.5	43.455	43.4625	4300.0
2017-12-21 06:00:00	AAPL	Stock	43.465	43.55	43.465	43.5025	3200.0
2017-12-21 07:00:00	AAPL	Stock	43.5	43.5875	43.5	43.5625	40452.0
2017-12-21 08:00:00	AAPL	Stock	43.5375	43.6375	43.505	43.635	170548.0
2017-12-21 09:00:00	AAPL	Stock	43.625	43.8275	43.5225	43.72	10852596.0
2017-12-21 10:00:00	AAPL	Stock	43.72	43.81	43.6425	43.8	11070700.0
2017-12-21 11:00:00	AAPL	Stock	43.8025	44.005	43.8	43.8725	14038984.0
2017-12-21 12:00:00	AAPL	Stock	43.8675	43.925	43.855	43.9112	6611112.0
2017-12-21 13:00:00	AAPL	Stock	43.91	43.9638	43.88	43.915	4810800.0
2017-12-21 14:00:00	AAPL	Stock	43.915	43.915	43.81	43.8512	4915660.0
2017-12-21 15:00:00	AAPL	Stock	43.85	43.8692	43.72	43.7525	9725656.0
2017-12-21 16:00:00	AAPL	Stock	43.775	43.8	43.735	43.7525	13895288.0
2017-12-21 17:00:00	AAPL	Stock	43.7875	43.7925	43.7525	43.7925	647604.0
2017-12-21 18:00:00	AAPL	Stock	43.7925	43.7925	43.7875	43.7875	16412.0
2017-12-21 19:00:00	AAPL	Stock	43.795	43.8	43.7875	43.79	22016.0
2017-12-21 04:00:00	MSFT	Stock	86.12	86.14	86.12	86.14	400.0
2017-12-21 05:00:00	MSFT	Stock	85.96	85.96	85.8	85.8	356.0
2017-12-21 06:00:00	MSFT	Stock	85.85	85.85	85.85	85.85	200.0
2017-12-21 07:00:00	MSFT	Stock	85.74	85.74	85.73	85.73	550.0
2017-12-21 08:00:00	MSFT	Stock	85.9	85.9	85.65	85.65	6713.0
2017-12-21 09:00:00	MSFT	Stock	85.75	86.1	85.61	85.675	2159069.0
2017-12-21 10:00:00	MSFT	Stock	85.675	86.02	85.571	85.895	1797203.0
2017-12-21 11:00:00	MSFT	Stock	85.89	86.04	85.83	86.005	1548022.0
2017-12-21 12:00:00	MSFT	Stock	86.01	86.03	85.82	85.94	1174823.0
2017-12-21 13:00:00	MSFT	Stock	85.94	86.06	85.915	85.935	940227.0
2017-12-21 14:00:00	MSFT	Stock	85.93	85.93	85.595	85.665	1020479.0
2017-12-21 15:00:00	MSFT	Stock	85.67	85.72	85.4	85.57	2582781.0
2017-12-21 16:00:00	MSFT	Stock	85.5	85.57	85.5	85.56	5452752.0
2017-12-21 17:00:00	MSFT	Stock	85.56	85.56	85.5	85.55	2478.0
2017-12-21 18:00:00	MSFT	Stock	85.52	85.52	85.5	85.5	1200.0
2017-12-21 19:00:00	MSFT	Stock	85.46	85.52	85.46	85.52	1800.0
2017-12-21 06:00:00	NVDA	Stock	4.9198	4.9198	4.9198	4.9198	26240.0
2017-12-21 07:00:00	NVDA	Stock	4.925	4.925	4.9065	4.9125	110800.0
2017-12-21 08:00:00	NVDA	Stock	4.9095	4.93	4.905	4.925	702000.0
2017-12-21 09:00:00	NVDA	Stock	4.925	4.9475	4.9	4.9223	50972840.0
2017-12-21 10:00:00	NVDA	Stock	4.9205	4.9334	4.889	4.8938	51379200.0
2017-12-21 11:00:00	NVDA	Stock	4.8945	4.927	4.8923	4.9191	36567040.0
2017-12-21 12:00:00	NVDA	Stock	4.9183	4.9308	4.9133	4.93	22849480.0
2017-12-21 13:00:00	NVDA	Stock	4.93	4.9488	4.9258	4.945	29780640.0
2017-12-21 14:00:00	NVDA	Stock	4.9445	4.9445	4.9112	4.9205	23410880.0
2017-12-21 15:00:00	NVDA	Stock	4.9198	4.923	4.8888	4.897	42849360.0
2017-12-21 16:00:00	NVDA	Stock	4.8972	4.9125	4.8972	4.8972	24684600.0
2017-12-21 17:00:00	NVDA	Stock	4.8995	4.9038	4.8975	4.8975	314680.0
2017-12-21 18:00:00	NVDA	Stock	4.901	4.907	4.901	4.907	247440.0
2017-12-21 19:00:00	NVDA	Stock	4.907	4.907	4.9053	4.9065	135680.0
2017-12-21 06:00:00	AMZN	Stock	58.8885	58.8885	58.8885	58.8885	2000.0
2017-12-21 07:00:00	AMZN	Stock	58.925	58.925	58.825	58.825	25920.0
2017-12-21 08:00:00	AMZN	Stock	58.93	59.0	58.8	58.8965	194900.0
2017-12-21 09:00:00	AMZN	Stock	58.875	58.94	58.5815	58.6655	5609220.0

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

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