PREVIEW / stock_1hour / 2016-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-23.parquet
  size:    1.0 MB
  rows:    48,686
  symbols: 3,341

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-23 04:00:00	AAPL	Stock	24.0625	24.0625	24.0625	24.0625	4000.0
2016-02-23 05:00:00	AAPL	Stock	24.0625	24.0625	24.0625	24.0625	400.0
2016-02-23 06:00:00	AAPL	Stock	24.1125	24.1125	24.1	24.1	5932.0
2016-02-23 07:00:00	AAPL	Stock	24.1175	24.15	24.09	24.1	85580.0
2016-02-23 08:00:00	AAPL	Stock	24.115	24.1475	24.0625	24.1275	382392.0
2016-02-23 09:00:00	AAPL	Stock	24.12	24.125	24.032	24.045	11790556.0
2016-02-23 10:00:00	AAPL	Stock	24.0425	24.055	23.805	23.8162	22879680.0
2016-02-23 11:00:00	AAPL	Stock	23.815	23.895	23.7725	23.8325	14150332.0
2016-02-23 12:00:00	AAPL	Stock	23.8325	23.8525	23.7938	23.8245	6530516.0
2016-02-23 13:00:00	AAPL	Stock	23.8225	23.825	23.74	23.7875	9555656.0
2016-02-23 14:00:00	AAPL	Stock	23.7862	23.8075	23.7138	23.7325	10389888.0
2016-02-23 15:00:00	AAPL	Stock	23.7325	23.7475	23.6375	23.6725	28566632.0
2016-02-23 16:00:00	AAPL	Stock	23.6725	24.06	23.6225	23.65	12573728.0
2016-02-23 17:00:00	AAPL	Stock	23.64	23.655	23.6	23.6	106208.0
2016-02-23 18:00:00	AAPL	Stock	23.6125	23.6125	23.5675	23.5875	103720.0
2016-02-23 19:00:00	AAPL	Stock	23.5975	23.6	23.55	23.575	79888.0
2016-02-23 07:00:00	MSFT	Stock	52.35	52.4	52.32	52.32	1400.0
2016-02-23 08:00:00	MSFT	Stock	52.4	52.42	52.2	52.41	14872.0
2016-02-23 09:00:00	MSFT	Stock	52.35	52.39	51.93	52.005	2482663.0
2016-02-23 10:00:00	MSFT	Stock	52.0	52.05	51.54	51.605	3820375.0
2016-02-23 11:00:00	MSFT	Stock	51.61	51.67	51.32	51.375	3131506.0
2016-02-23 12:00:00	MSFT	Stock	51.37	51.52	51.325	51.52	1957744.0
2016-02-23 13:00:00	MSFT	Stock	51.52	51.56	51.16	51.39	2782989.0
2016-02-23 14:00:00	MSFT	Stock	51.395	51.41	51.11	51.12	2598349.0
2016-02-23 15:00:00	MSFT	Stock	51.115	51.28	50.98	51.18	6471035.0
2016-02-23 16:00:00	MSFT	Stock	51.18	51.26	51.05	51.05	3742053.0
2016-02-23 17:00:00	MSFT	Stock	51.06	51.06	51.05	51.05	1200.0
2016-02-23 18:00:00	MSFT	Stock	51.1	51.1	51.1	51.1	1900.0
2016-02-23 19:00:00	MSFT	Stock	51.1	51.12	51.1	51.12	2975.0
2016-02-23 08:00:00	NVDA	Stock	0.787	0.7875	0.787	0.7875	20000.0
2016-02-23 09:00:00	NVDA	Stock	0.7818	0.7975	0.778	0.796	40565200.0
2016-02-23 10:00:00	NVDA	Stock	0.7963	0.7963	0.7895	0.79	76719760.0
2016-02-23 11:00:00	NVDA	Stock	0.79	0.7945	0.7868	0.7911	47111320.0
2016-02-23 12:00:00	NVDA	Stock	0.791	0.7923	0.7875	0.7915	34347440.0
2016-02-23 13:00:00	NVDA	Stock	0.7913	0.792	0.789	0.7911	29538480.0
2016-02-23 14:00:00	NVDA	Stock	0.791	0.7925	0.7896	0.7898	26573440.0
2016-02-23 15:00:00	NVDA	Stock	0.7899	0.792	0.7885	0.79	82272400.0
2016-02-23 16:00:00	NVDA	Stock	0.79	0.7902	0.79	0.7902	16948120.0
2016-02-23 17:00:00	NVDA	Stock	0.7925	0.7925	0.7925	0.7925	8000.0
2016-02-23 18:00:00	NVDA	Stock	0.7888	0.7888	0.7875	0.7875	26200.0
2016-02-23 19:00:00	NVDA	Stock	0.783	0.783	0.783	0.783	9600.0
2016-02-23 04:00:00	AMZN	Stock	27.85	27.85	27.8	27.8	9400.0
2016-02-23 07:00:00	AMZN	Stock	27.8705	27.942	27.8705	27.9	39500.0
2016-02-23 08:00:00	AMZN	Stock	27.897	27.9495	27.7875	27.949	300680.0
2016-02-23 09:00:00	AMZN	Stock	27.941	27.941	27.6	27.6025	11133200.0
2016-02-23 10:00:00	AMZN	Stock	27.6145	27.6625	27.2665	27.373	16668360.0
2016-02-23 11:00:00	AMZN	Stock	27.3745	27.7065	27.29	27.636	11142160.0
2016-02-23 12:00:00	AMZN	Stock	27.634	27.7355	27.5925	27.7255	6889760.0
2016-02-23 13:00:00	AMZN	Stock	27.733	27.775	27.555	27.638	5636380.0
2016-02-23 14:00:00	AMZN	Stock	27.638	27.7645	27.6185	27.6885	6189660.0

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

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