PREVIEW / stock_1hour / 2016-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-19.parquet
  size:    1.0 MB
  rows:    48,165
  symbols: 3,351

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
2016-02-19 04:00:00	AAPL	Stock	24.02	24.02	24.02	24.02	720.0
2016-02-19 06:00:00	AAPL	Stock	24.065	24.07	23.9525	23.9575	26392.0
2016-02-19 07:00:00	AAPL	Stock	23.96	24.025	23.96	24.025	26324.0
2016-02-19 08:00:00	AAPL	Stock	24.0275	24.075	23.9775	24.015	270588.0
2016-02-19 09:00:00	AAPL	Stock	24.0025	24.145	23.95	24.0238	23927708.0
2016-02-19 10:00:00	AAPL	Stock	24.0225	24.1725	23.9625	24.0912	20308428.0
2016-02-19 11:00:00	AAPL	Stock	24.09	24.19	24.03	24.065	15980544.0
2016-02-19 12:00:00	AAPL	Stock	24.065	24.12	24.0275	24.055	7943452.0
2016-02-19 13:00:00	AAPL	Stock	24.0525	24.1012	24.02	24.065	9446912.0
2016-02-19 14:00:00	AAPL	Stock	24.0655	24.0975	23.9925	24.0	11553868.0
2016-02-19 15:00:00	AAPL	Stock	24.0	24.0978	23.9875	24.0075	23422552.0
2016-02-19 16:00:00	AAPL	Stock	24.01	24.025	23.99	24.0	10185804.0
2016-02-19 17:00:00	AAPL	Stock	24.0	24.01	23.9525	23.9525	2977300.0
2016-02-19 18:00:00	AAPL	Stock	23.955	23.9675	23.95	23.96	124840.0
2016-02-19 19:00:00	AAPL	Stock	23.96	23.975	23.96	23.975	75524.0
2016-02-19 08:00:00	MSFT	Stock	51.97	52.04	51.87	51.88	21346.0
2016-02-19 09:00:00	MSFT	Stock	51.85	52.28	51.63	52.13	5637940.0
2016-02-19 10:00:00	MSFT	Stock	52.12	52.27	52.0	52.04	3444155.0
2016-02-19 11:00:00	MSFT	Stock	52.04	52.27	51.92	52.01	3118133.0
2016-02-19 12:00:00	MSFT	Stock	52.01	52.07	51.87	51.92	1884558.0
2016-02-19 13:00:00	MSFT	Stock	51.92	51.99	51.82	51.95	2204394.0
2016-02-19 14:00:00	MSFT	Stock	51.95	51.995	51.53	51.59	2947951.0
2016-02-19 15:00:00	MSFT	Stock	51.59	51.95	51.56	51.81	5446672.0
2016-02-19 16:00:00	MSFT	Stock	51.82	51.96	51.71	51.924	2567129.0
2016-02-19 17:00:00	MSFT	Stock	51.83	51.83	51.83	51.83	100.0
2016-02-19 18:00:00	MSFT	Stock	51.87	51.87	51.84	51.84	400.0
2016-02-19 19:00:00	MSFT	Stock	51.83	51.87	51.83	51.87	270.0
2016-02-19 08:00:00	NVDA	Stock	0.7438	0.7538	0.7438	0.7478	151440.0
2016-02-19 09:00:00	NVDA	Stock	0.7478	0.75	0.7412	0.7458	62487480.0
2016-02-19 10:00:00	NVDA	Stock	0.7458	0.7568	0.743	0.7532	88606960.0
2016-02-19 11:00:00	NVDA	Stock	0.7532	0.7678	0.7515	0.7638	62065520.0
2016-02-19 12:00:00	NVDA	Stock	0.7638	0.7652	0.7603	0.7636	44278680.0
2016-02-19 13:00:00	NVDA	Stock	0.7635	0.7648	0.762	0.7633	40927480.0
2016-02-19 14:00:00	NVDA	Stock	0.7631	0.7643	0.7598	0.7608	41605800.0
2016-02-19 15:00:00	NVDA	Stock	0.761	0.7633	0.7595	0.761	112271600.0
2016-02-19 16:00:00	NVDA	Stock	0.761	0.7615	0.76	0.7615	48170200.0
2016-02-19 17:00:00	NVDA	Stock	0.7622	0.7625	0.7622	0.7625	168000.0
2016-02-19 18:00:00	NVDA	Stock	0.7612	0.7612	0.7612	0.7612	20000.0
2016-02-19 19:00:00	NVDA	Stock	0.7625	0.7625	0.7625	0.7625	8000.0
2016-02-19 07:00:00	AMZN	Stock	26.15	26.1505	26.068	26.1485	39700.0
2016-02-19 08:00:00	AMZN	Stock	26.125	26.15	26.0825	26.091	76800.0
2016-02-19 09:00:00	AMZN	Stock	26.0955	26.2346	25.7675	25.9718	23126540.0
2016-02-19 10:00:00	AMZN	Stock	25.9715	26.4	25.82	26.325	18813180.0
2016-02-19 11:00:00	AMZN	Stock	26.3232	26.596	26.275	26.503	11611540.0
2016-02-19 12:00:00	AMZN	Stock	26.5118	26.6148	26.4725	26.499	7304860.0
2016-02-19 13:00:00	AMZN	Stock	26.5	26.549	26.378	26.5095	11084460.0
2016-02-19 14:00:00	AMZN	Stock	26.51	26.5665	26.412	26.4235	5587940.0
2016-02-19 15:00:00	AMZN	Stock	26.427	26.7975	26.4245	26.744	18370380.0
2016-02-19 16:00:00	AMZN	Stock	26.7455	26.7825	26.4025	26.7425	964000.0
2016-02-19 17:00:00	AMZN	Stock	26.7275	26.75	26.727	26.7385	362020.0

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

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