PREVIEW / stock_1hour / 2016-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-26.parquet
  size:    1.0 MB
  rows:    48,110
  symbols: 3,342

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-26 04:00:00	AAPL	Stock	24.2125	24.375	24.2125	24.375	16400.0
2016-02-26 05:00:00	AAPL	Stock	24.375	24.4025	24.375	24.3875	8000.0
2016-02-26 06:00:00	AAPL	Stock	24.3625	24.3625	24.3	24.3	13400.0
2016-02-26 07:00:00	AAPL	Stock	24.3025	24.3025	24.2475	24.25	45140.0
2016-02-26 08:00:00	AAPL	Stock	24.2475	24.335	24.24	24.29	279800.0
2016-02-26 09:00:00	AAPL	Stock	24.2925	24.4175	24.2825	24.375	17056968.0
2016-02-26 10:00:00	AAPL	Stock	24.375	24.4325	24.27	24.4175	17757664.0
2016-02-26 11:00:00	AAPL	Stock	24.4185	24.506	24.33	24.3475	17571908.0
2016-02-26 12:00:00	AAPL	Stock	24.345	24.3475	24.2375	24.275	11391140.0
2016-02-26 13:00:00	AAPL	Stock	24.275	24.33	24.1525	24.221	11011460.0
2016-02-26 14:00:00	AAPL	Stock	24.2225	24.2575	24.145	24.18	9258636.0
2016-02-26 15:00:00	AAPL	Stock	24.18	24.275	24.1725	24.2275	16764940.0
2016-02-26 16:00:00	AAPL	Stock	24.2275	24.3657	24.225	24.2275	5819968.0
2016-02-26 17:00:00	AAPL	Stock	24.2275	24.2275	24.2075	24.2075	24348.0
2016-02-26 18:00:00	AAPL	Stock	24.2225	24.235	24.21	24.235	65564.0
2016-02-26 19:00:00	AAPL	Stock	24.215	24.225	24.2125	24.2175	41352.0
2016-02-26 04:00:00	MSFT	Stock	52.25	52.59	52.25	52.59	3700.0
2016-02-26 06:00:00	MSFT	Stock	52.32	52.47	52.32	52.46	7220.0
2016-02-26 07:00:00	MSFT	Stock	52.48	52.48	52.31	52.31	6230.0
2016-02-26 08:00:00	MSFT	Stock	52.31	52.45	52.27	52.38	23870.0
2016-02-26 09:00:00	MSFT	Stock	52.38	52.68	52.0	52.05	3341939.0
2016-02-26 10:00:00	MSFT	Stock	52.05	52.055	51.64	51.66	5474244.0
2016-02-26 11:00:00	MSFT	Stock	51.67	51.67	51.13	51.3	4633694.0
2016-02-26 12:00:00	MSFT	Stock	51.31	51.36	51.1	51.22	2994211.0
2016-02-26 13:00:00	MSFT	Stock	51.22	51.32	51.12	51.265	3357795.0
2016-02-26 14:00:00	MSFT	Stock	51.265	51.43	51.23	51.25	3198005.0
2016-02-26 15:00:00	MSFT	Stock	51.25	51.46	51.24	51.28	8015214.0
2016-02-26 16:00:00	MSFT	Stock	51.3	51.35	51.21	51.21	2603952.0
2016-02-26 17:00:00	MSFT	Stock	51.28	51.28	51.28	51.28	1250.0
2016-02-26 18:00:00	MSFT	Stock	51.25	51.25	51.25	51.25	600.0
2016-02-26 19:00:00	MSFT	Stock	51.24	51.24	51.24	51.24	138.0
2016-02-26 07:00:00	NVDA	Stock	0.8	0.8	0.8	0.8	4000.0
2016-02-26 08:00:00	NVDA	Stock	0.7998	0.7998	0.7998	0.7998	12840.0
2016-02-26 09:00:00	NVDA	Stock	0.8018	0.8029	0.7868	0.787	38580240.0
2016-02-26 10:00:00	NVDA	Stock	0.787	0.7898	0.784	0.7879	66801200.0
2016-02-26 11:00:00	NVDA	Stock	0.788	0.7905	0.7855	0.7897	48994680.0
2016-02-26 12:00:00	NVDA	Stock	0.7898	0.7912	0.7877	0.7906	27241720.0
2016-02-26 13:00:00	NVDA	Stock	0.7906	0.792	0.7885	0.7886	21847360.0
2016-02-26 14:00:00	NVDA	Stock	0.7886	0.7908	0.7872	0.7894	45768160.0
2016-02-26 15:00:00	NVDA	Stock	0.7894	0.7938	0.789	0.792	69780720.0
2016-02-26 16:00:00	NVDA	Stock	0.792	0.7972	0.792	0.7972	27067920.0
2016-02-26 19:00:00	NVDA	Stock	0.79	0.79	0.79	0.79	32800.0
2016-02-26 06:00:00	AMZN	Stock	28.0	28.008	28.0	28.0	38480.0
2016-02-26 07:00:00	AMZN	Stock	27.95	27.9875	27.852	27.9035	120500.0
2016-02-26 08:00:00	AMZN	Stock	27.905	28.075	27.905	28.0	549780.0
2016-02-26 09:00:00	AMZN	Stock	27.993	28.125	27.8762	28.0462	15405400.0
2016-02-26 10:00:00	AMZN	Stock	28.0365	28.075	27.85	27.9985	13074940.0
2016-02-26 11:00:00	AMZN	Stock	27.997	28.007	27.778	27.8983	14591340.0
2016-02-26 12:00:00	AMZN	Stock	27.894	27.894	27.6585	27.868	13414260.0
2016-02-26 13:00:00	AMZN	Stock	27.8725	27.9005	27.7365	27.794	7192720.0

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

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