PREVIEW / stock_1hour / 2016-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-25.parquet
  size:    1.0 MB
  rows:    49,049
  symbols: 3,383

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-01-25 04:00:00	AAPL	Stock	25.5	25.5	25.275	25.425	33408.0
2016-01-25 05:00:00	AAPL	Stock	25.425	25.4875	25.4	25.45	20976.0
2016-01-25 06:00:00	AAPL	Stock	25.4725	25.4725	25.3625	25.42	78636.0
2016-01-25 07:00:00	AAPL	Stock	25.4	25.4125	25.33	25.3375	110088.0
2016-01-25 08:00:00	AAPL	Stock	25.35	25.4625	25.21	25.2375	759548.0
2016-01-25 09:00:00	AAPL	Stock	25.2425	25.43	25.03	25.2325	31710256.0
2016-01-25 10:00:00	AAPL	Stock	25.2275	25.3612	25.0975	25.2025	30649912.0
2016-01-25 11:00:00	AAPL	Stock	25.2	25.2025	25.0575	25.12	18779220.0
2016-01-25 12:00:00	AAPL	Stock	25.1225	25.3025	25.0625	25.21	19904832.0
2016-01-25 13:00:00	AAPL	Stock	25.21	25.275	25.1225	25.1225	14948272.0
2016-01-25 14:00:00	AAPL	Stock	25.125	25.145	25.075	25.1025	14293396.0
2016-01-25 15:00:00	AAPL	Stock	25.1025	25.1275	24.8025	24.8665	37601964.0
2016-01-25 16:00:00	AAPL	Stock	24.8575	25.2345	24.81	24.8625	18485184.0
2016-01-25 17:00:00	AAPL	Stock	24.8575	24.87	24.775	24.84	225844.0
2016-01-25 18:00:00	AAPL	Stock	24.825	24.885	24.8025	24.875	64748.0
2016-01-25 19:00:00	AAPL	Stock	24.85	24.8625	24.8	24.8625	152800.0
2016-01-25 04:00:00	MSFT	Stock	52.1	52.1	52.1	52.1	3400.0
2016-01-25 06:00:00	MSFT	Stock	52.06	52.06	52.05	52.05	851.0
2016-01-25 07:00:00	MSFT	Stock	52.3	52.3	52.2	52.2	3447.0
2016-01-25 08:00:00	MSFT	Stock	52.1	52.3	51.95	51.96	18879.0
2016-01-25 09:00:00	MSFT	Stock	51.97	52.13	51.77	52.07	3809435.0
2016-01-25 10:00:00	MSFT	Stock	52.06	52.23	51.89	52.18	4208420.0
2016-01-25 11:00:00	MSFT	Stock	52.17	52.24	52.0	52.115	3038785.0
2016-01-25 12:00:00	MSFT	Stock	52.11	52.48	52.08	52.44	3029013.0
2016-01-25 13:00:00	MSFT	Stock	52.45	52.65	52.31	52.33	3083757.0
2016-01-25 14:00:00	MSFT	Stock	52.33	52.5	52.27	52.43	2872566.0
2016-01-25 15:00:00	MSFT	Stock	52.43	52.54	51.65	51.77	9054238.0
2016-01-25 16:00:00	MSFT	Stock	51.79	51.83	51.67	51.77	1902567.0
2016-01-25 17:00:00	MSFT	Stock	51.77	51.77	51.68	51.68	800.0
2016-01-25 18:00:00	MSFT	Stock	51.69	51.77	51.68	51.7	3000.0
2016-01-25 19:00:00	MSFT	Stock	51.7	51.7	51.64	51.64	1950.0
2016-01-25 08:00:00	NVDA	Stock	0.7075	0.7075	0.7015	0.7015	8000.0
2016-01-25 09:00:00	NVDA	Stock	0.7095	0.7191	0.7095	0.7153	27429480.0
2016-01-25 10:00:00	NVDA	Stock	0.715	0.7188	0.7131	0.716	40245480.0
2016-01-25 11:00:00	NVDA	Stock	0.716	0.7161	0.709	0.7108	33626200.0
2016-01-25 12:00:00	NVDA	Stock	0.7105	0.7173	0.709	0.7168	26914600.0
2016-01-25 13:00:00	NVDA	Stock	0.7165	0.718	0.7134	0.7135	20022960.0
2016-01-25 14:00:00	NVDA	Stock	0.7133	0.717	0.7123	0.7166	25524200.0
2016-01-25 15:00:00	NVDA	Stock	0.7165	0.7175	0.7089	0.7103	76900960.0
2016-01-25 16:00:00	NVDA	Stock	0.7103	0.712	0.71	0.71	4828200.0
2016-01-25 17:00:00	NVDA	Stock	0.712	0.712	0.712	0.712	120000.0
2016-01-25 04:00:00	AMZN	Stock	29.7025	29.839	29.7	29.775	32920.0
2016-01-25 05:00:00	AMZN	Stock	29.85	29.8775	29.85	29.8775	7160.0
2016-01-25 06:00:00	AMZN	Stock	29.85	29.85	29.8495	29.85	8620.0
2016-01-25 07:00:00	AMZN	Stock	29.85	29.9675	29.85	29.949	64420.0
2016-01-25 08:00:00	AMZN	Stock	29.9695	29.9695	29.802	29.802	337080.0
2016-01-25 09:00:00	AMZN	Stock	29.802	30.425	29.728	30.2078	16366920.0
2016-01-25 10:00:00	AMZN	Stock	30.223	30.393	30.1585	30.286	12098720.0
2016-01-25 11:00:00	AMZN	Stock	30.25	30.2605	29.8305	29.9125	12967080.0
2016-01-25 12:00:00	AMZN	Stock	29.9245	30.2635	29.885	30.257	8232980.0

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

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