PREVIEW / stock_1hour / 2015-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-30.parquet
  size:    1.1 MB
  rows:    49,074
  symbols: 3,524

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
2015-03-30 04:00:00	AAPL	Stock	30.7725	31.1575	30.7725	31.1325	71980.0
2015-03-30 05:00:00	AAPL	Stock	31.15	31.1525	31.08	31.1	33092.0
2015-03-30 06:00:00	AAPL	Stock	31.1	31.1225	31.05	31.065	100868.0
2015-03-30 07:00:00	AAPL	Stock	31.0575	31.085	31.0375	31.075	275192.0
2015-03-30 08:00:00	AAPL	Stock	31.0625	31.11	30.8125	31.0125	666868.0
2015-03-30 09:00:00	AAPL	Stock	31.005	31.37	31.0	31.3425	31745832.0
2015-03-30 10:00:00	AAPL	Stock	31.34	31.405	31.2675	31.355	31114620.0
2015-03-30 11:00:00	AAPL	Stock	31.355	31.395	31.2275	31.265	16278784.0
2015-03-30 12:00:00	AAPL	Stock	31.265	31.38	31.255	31.3625	11555680.0
2015-03-30 13:00:00	AAPL	Stock	31.365	31.4725	31.3532	31.4475	14723544.0
2015-03-30 14:00:00	AAPL	Stock	31.4475	31.4825	31.41	31.425	12775940.0
2015-03-30 15:00:00	AAPL	Stock	31.4275	31.6	31.4275	31.5825	31247500.0
2015-03-30 16:00:00	AAPL	Stock	31.5875	31.5962	31.3235	31.5775	7887508.0
2015-03-30 17:00:00	AAPL	Stock	31.575	31.595	31.575	31.595	206416.0
2015-03-30 18:00:00	AAPL	Stock	31.595	31.61	31.5828	31.6075	213284.0
2015-03-30 19:00:00	AAPL	Stock	31.6075	31.62	31.6	31.6125	144632.0
2015-03-30 06:00:00	MSFT	Stock	41.28	41.3	41.28	41.28	8300.0
2015-03-30 07:00:00	MSFT	Stock	41.25	41.25	41.25	41.25	200.0
2015-03-30 08:00:00	MSFT	Stock	41.23	41.28	41.23	41.24	12310.0
2015-03-30 09:00:00	MSFT	Stock	41.28	41.54	41.08	41.44	4155886.0
2015-03-30 10:00:00	MSFT	Stock	41.45	41.47	41.21	41.325	4158127.0
2015-03-30 11:00:00	MSFT	Stock	41.33	41.335	41.195	41.29	3314533.0
2015-03-30 12:00:00	MSFT	Stock	41.3	41.39	41.26	41.344	2567154.0
2015-03-30 13:00:00	MSFT	Stock	41.35	41.36	41.1	41.13	3515922.0
2015-03-30 14:00:00	MSFT	Stock	41.13	41.19	41.03	41.06	3801780.0
2015-03-30 15:00:00	MSFT	Stock	41.06	41.15	40.91	40.94	9345760.0
2015-03-30 16:00:00	MSFT	Stock	40.96	41.174	40.87	40.89	2826073.0
2015-03-30 17:00:00	MSFT	Stock	40.96	40.96	40.88	40.88	226763.0
2015-03-30 18:00:00	MSFT	Stock	40.89	40.96	40.86	40.9	35405.0
2015-03-30 19:00:00	MSFT	Stock	40.91	40.91	40.86	40.9	12630.0
2015-03-30 04:00:00	NVDA	Stock	0.5402	0.5402	0.5402	0.5402	16000.0
2015-03-30 07:00:00	NVDA	Stock	0.5388	0.5388	0.535	0.535	50000.0
2015-03-30 08:00:00	NVDA	Stock	0.535	0.5352	0.5327	0.5327	48000.0
2015-03-30 09:00:00	NVDA	Stock	0.5358	0.5382	0.5338	0.5365	30194280.0
2015-03-30 10:00:00	NVDA	Stock	0.5367	0.5385	0.53	0.534	42817240.0
2015-03-30 11:00:00	NVDA	Stock	0.534	0.5382	0.5322	0.5338	39098040.0
2015-03-30 12:00:00	NVDA	Stock	0.534	0.5358	0.532	0.5354	22850680.0
2015-03-30 13:00:00	NVDA	Stock	0.5355	0.5395	0.5321	0.5365	36168920.0
2015-03-30 14:00:00	NVDA	Stock	0.5365	0.538	0.5352	0.537	18724360.0
2015-03-30 15:00:00	NVDA	Stock	0.537	0.5378	0.536	0.5367	43057200.0
2015-03-30 16:00:00	NVDA	Stock	0.5367	0.5368	0.5354	0.5367	12451400.0
2015-03-30 17:00:00	NVDA	Stock	0.5367	0.5367	0.5367	0.5367	112000.0
2015-03-30 18:00:00	NVDA	Stock	0.5367	0.5367	0.5367	0.5367	903960.0
2015-03-30 07:00:00	AMZN	Stock	18.65	18.654	18.6375	18.6375	25500.0
2015-03-30 08:00:00	AMZN	Stock	18.625	18.625	18.625	18.625	3900.0
2015-03-30 09:00:00	AMZN	Stock	18.625	18.7691	18.5775	18.7298	4757800.0
2015-03-30 10:00:00	AMZN	Stock	18.725	18.7415	18.623	18.6665	5789260.0
2015-03-30 11:00:00	AMZN	Stock	18.6695	18.6925	18.634	18.6595	3049600.0
2015-03-30 12:00:00	AMZN	Stock	18.661	18.7055	18.655	18.68	2366440.0
2015-03-30 13:00:00	AMZN	Stock	18.6815	18.7165	18.678	18.6865	2082180.0

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

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