PREVIEW / stock_1hour / 2012-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-13.parquet
  size:    924 KB
  rows:    43,787
  symbols: 3,510

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
2012-04-13 04:00:00	AAPL	Stock	22.2143	22.2143	22.1893	22.1893	205800.0
2012-04-13 05:00:00	AAPL	Stock	22.2036	22.2043	22.1893	22.2014	47740.0
2012-04-13 06:00:00	AAPL	Stock	22.2018	22.2321	22.1964	22.2214	44688.0
2012-04-13 07:00:00	AAPL	Stock	22.2464	22.2536	22.2004	22.2054	887544.0
2012-04-13 08:00:00	AAPL	Stock	22.2054	22.2464	22.1118	22.2207	2636060.0
2012-04-13 09:00:00	AAPL	Stock	22.2275	22.3179	22.0496	22.0561	115718596.0
2012-04-13 10:00:00	AAPL	Stock	22.0589	22.0804	21.5539	21.7264	255585204.0
2012-04-13 11:00:00	AAPL	Stock	21.7189	21.8107	21.5829	21.7353	123719372.0
2012-04-13 12:00:00	AAPL	Stock	21.7361	21.7996	21.6857	21.7425	60931164.0
2012-04-13 13:00:00	AAPL	Stock	21.7414	21.8025	21.705	21.7143	53979800.0
2012-04-13 14:00:00	AAPL	Stock	21.7143	21.7625	21.6918	21.7407	46460820.0
2012-04-13 15:00:00	AAPL	Stock	21.74	21.8143	21.5982	21.6139	124733336.0
2012-04-13 16:00:00	AAPL	Stock	21.6154	21.8143	21.5982	21.6054	63202132.0
2012-04-13 17:00:00	AAPL	Stock	21.6057	21.6154	21.5714	21.5829	837984.0
2012-04-13 18:00:00	AAPL	Stock	21.5775	21.6071	21.5718	21.5889	290220.0
2012-04-13 19:00:00	AAPL	Stock	21.5886	21.6071	21.585	21.5893	301084.0
2012-04-13 07:00:00	MSFT	Stock	30.9	30.95	30.9	30.9	600.0
2012-04-13 08:00:00	MSFT	Stock	30.91	30.95	30.8	30.9	10700.0
2012-04-13 09:00:00	MSFT	Stock	30.92	31.1	30.72	30.92	4543069.0
2012-04-13 10:00:00	MSFT	Stock	30.92	31.16	30.77	30.91	7258409.0
2012-04-13 11:00:00	MSFT	Stock	30.91	31.1	30.88	31.02	3907433.0
2012-04-13 12:00:00	MSFT	Stock	31.03	31.08	30.93	31.07	2648001.0
2012-04-13 13:00:00	MSFT	Stock	31.08	31.11	31.02	31.025	2468824.0
2012-04-13 14:00:00	MSFT	Stock	31.022	31.08	30.95	30.98	3724388.0
2012-04-13 15:00:00	MSFT	Stock	30.97	31.075	30.8	30.81	8156312.0
2012-04-13 16:00:00	MSFT	Stock	30.81	30.962	30.79	30.81	6640539.0
2012-04-13 17:00:00	MSFT	Stock	30.83	30.945	30.79	30.85	21735.0
2012-04-13 18:00:00	MSFT	Stock	30.86	30.86	30.81	30.81	400.0
2012-04-13 19:00:00	MSFT	Stock	30.87	30.87	30.87	30.87	100.0
2012-04-13 08:00:00	NVDA	Stock	0.365	0.365	0.3638	0.3638	92000.0
2012-04-13 09:00:00	NVDA	Stock	0.3638	0.3671	0.3608	0.3608	27450600.0
2012-04-13 10:00:00	NVDA	Stock	0.3608	0.3618	0.3562	0.3579	54653640.0
2012-04-13 11:00:00	NVDA	Stock	0.3578	0.359	0.3565	0.3579	28040360.0
2012-04-13 12:00:00	NVDA	Stock	0.358	0.358	0.3545	0.3549	44686880.0
2012-04-13 13:00:00	NVDA	Stock	0.3549	0.3572	0.354	0.3559	39431360.0
2012-04-13 14:00:00	NVDA	Stock	0.3558	0.3562	0.355	0.3551	22907640.0
2012-04-13 15:00:00	NVDA	Stock	0.355	0.3553	0.3538	0.3538	79243520.0
2012-04-13 16:00:00	NVDA	Stock	0.354	0.3567	0.3538	0.354	12517360.0
2012-04-13 17:00:00	NVDA	Stock	0.354	0.354	0.3538	0.3538	48000.0
2012-04-13 18:00:00	NVDA	Stock	0.3538	0.3538	0.3538	0.3538	29000.0
2012-04-13 08:00:00	AMZN	Stock	9.5065	9.52	9.4825	9.4965	234880.0
2012-04-13 09:00:00	AMZN	Stock	9.5	9.536	9.4073	9.42	9812260.0
2012-04-13 10:00:00	AMZN	Stock	9.421	9.426	9.313	9.341	14902380.0
2012-04-13 11:00:00	AMZN	Stock	9.341	9.385	9.315	9.3617	10048680.0
2012-04-13 12:00:00	AMZN	Stock	9.3625	9.42	9.361	9.419	5220700.0
2012-04-13 13:00:00	AMZN	Stock	9.4175	9.4465	9.3966	9.414	4811740.0
2012-04-13 14:00:00	AMZN	Stock	9.4105	9.441	9.3965	9.4348	5711780.0
2012-04-13 15:00:00	AMZN	Stock	9.4345	9.476	9.41	9.417	11343100.0
2012-04-13 16:00:00	AMZN	Stock	9.4025	9.449	9.4	9.4	816340.0
2012-04-13 17:00:00	AMZN	Stock	9.423	9.4931	9.3925	9.3925	1274640.0

> showing 50 of 43,787 rows — these rows as CSV

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