PREVIEW / stock_1hour / 2013-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-28.parquet
  size:    960 KB
  rows:    45,137
  symbols: 3,481

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
2013-01-28 04:00:00	AAPL	Stock	15.7611	15.7611	15.6875	15.6875	152516.0
2013-01-28 05:00:00	AAPL	Stock	15.7086	15.7143	15.67	15.71	104944.0
2013-01-28 06:00:00	AAPL	Stock	15.6964	15.7607	15.6857	15.75	273196.0
2013-01-28 07:00:00	AAPL	Stock	15.7536	15.8357	15.7071	15.8214	1983184.0
2013-01-28 08:00:00	AAPL	Stock	15.8214	15.8339	15.6096	15.6404	7604296.0
2013-01-28 09:00:00	AAPL	Stock	15.6389	16.0157	15.5664	16.0127	171507000.0
2013-01-28 10:00:00	AAPL	Stock	16.0104	16.1321	15.8443	16.0843	169362592.0
2013-01-28 11:00:00	AAPL	Stock	16.0875	16.1861	16.0482	16.1521	97404244.0
2013-01-28 12:00:00	AAPL	Stock	16.1547	16.1818	16.0364	16.0368	57959804.0
2013-01-28 13:00:00	AAPL	Stock	16.0404	16.0907	15.9154	16.0662	78797208.0
2013-01-28 14:00:00	AAPL	Stock	16.065	16.12	16.0157	16.0866	56934584.0
2013-01-28 15:00:00	AAPL	Stock	16.0868	16.1521	16.05	16.0618	89521936.0
2013-01-28 16:00:00	AAPL	Stock	16.0621	16.0978	15.71	16.0321	28390880.0
2013-01-28 17:00:00	AAPL	Stock	16.035	16.1214	16.0304	16.1214	2292220.0
2013-01-28 18:00:00	AAPL	Stock	16.1186	16.1354	16.1107	16.1354	917196.0
2013-01-28 19:00:00	AAPL	Stock	16.135	16.135	16.0718	16.0875	827708.0
2013-01-28 04:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	4000.0
2013-01-28 06:00:00	MSFT	Stock	28.01	28.01	28.01	28.01	1000.0
2013-01-28 07:00:00	MSFT	Stock	28.04	28.05	27.95	28.01	23320.0
2013-01-28 08:00:00	MSFT	Stock	28.03	28.06	27.86	28.0	66878.0
2013-01-28 09:00:00	MSFT	Stock	27.99	28.1	27.76	28.0	7427745.0
2013-01-28 10:00:00	MSFT	Stock	27.99	28.17	27.93	28.12	9897550.0
2013-01-28 11:00:00	MSFT	Stock	28.115	28.19	28.0	28.18	5796430.0
2013-01-28 12:00:00	MSFT	Stock	28.18	28.225	28.15	28.155	4515876.0
2013-01-28 13:00:00	MSFT	Stock	28.15	28.16	27.89	28.015	7736906.0
2013-01-28 14:00:00	MSFT	Stock	28.01	28.07	27.96	28.005	4964271.0
2013-01-28 15:00:00	MSFT	Stock	28.01	28.05	27.88	27.91	10216479.0
2013-01-28 16:00:00	MSFT	Stock	27.919	28.218	27.88	27.9	2800123.0
2013-01-28 17:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	7230.0
2013-01-28 18:00:00	MSFT	Stock	27.92	27.92	27.9	27.9	334.0
2013-01-28 19:00:00	MSFT	Stock	27.9	27.92	27.88	27.9	4751.0
2013-01-28 08:00:00	NVDA	Stock	0.3103	0.3118	0.3103	0.3118	134400.0
2013-01-28 09:00:00	NVDA	Stock	0.3105	0.3153	0.3105	0.3145	63741920.0
2013-01-28 10:00:00	NVDA	Stock	0.3143	0.315	0.3125	0.3134	63827080.0
2013-01-28 11:00:00	NVDA	Stock	0.3135	0.3155	0.313	0.315	50957120.0
2013-01-28 12:00:00	NVDA	Stock	0.315	0.3163	0.3145	0.3155	44853840.0
2013-01-28 13:00:00	NVDA	Stock	0.3155	0.3168	0.3148	0.316	46632680.0
2013-01-28 14:00:00	NVDA	Stock	0.3158	0.317	0.3158	0.317	40519320.0
2013-01-28 15:00:00	NVDA	Stock	0.317	0.3173	0.3153	0.3155	95685160.0
2013-01-28 16:00:00	NVDA	Stock	0.3155	0.3168	0.315	0.3153	6483880.0
2013-01-28 17:00:00	NVDA	Stock	0.3158	0.3158	0.3153	0.3153	26000.0
2013-01-28 06:00:00	AMZN	Stock	14.173	14.207	14.1485	14.1505	54000.0
2013-01-28 07:00:00	AMZN	Stock	14.19	14.19	14.125	14.125	63000.0
2013-01-28 08:00:00	AMZN	Stock	14.15	14.15	14.0755	14.147	193400.0
2013-01-28 09:00:00	AMZN	Stock	14.15	14.224	14.0135	14.017	14367800.0
2013-01-28 10:00:00	AMZN	Stock	14.016	14.0215	13.885	13.9225	24024880.0
2013-01-28 11:00:00	AMZN	Stock	13.9205	14.189	13.825	13.887	11634460.0
2013-01-28 12:00:00	AMZN	Stock	13.887	13.8975	13.782	13.8275	7738720.0
2013-01-28 13:00:00	AMZN	Stock	13.8275	13.8275	13.72	13.8125	7160340.0
2013-01-28 14:00:00	AMZN	Stock	13.8085	13.8895	13.807	13.8635	5781360.0

> showing 50 of 45,137 rows — these rows as CSV

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