PREVIEW / stock_1hour / 2011-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-11.parquet
  size:    938 KB
  rows:    44,325
  symbols: 3,552

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
2011-04-11 04:00:00	AAPL	Stock	12.0029	12.0029	11.9821	11.9821	30800.0
2011-04-11 05:00:00	AAPL	Stock	11.9857	11.9857	11.9786	11.9839	19600.0
2011-04-11 06:00:00	AAPL	Stock	11.9836	12.0354	11.9679	12.0	87360.0
2011-04-11 07:00:00	AAPL	Stock	12.0011	12.0268	11.9875	11.9918	131180.0
2011-04-11 08:00:00	AAPL	Stock	11.9979	11.9979	11.9464	11.9607	971068.0
2011-04-11 09:00:00	AAPL	Stock	11.9571	12.1516	11.8671	11.9029	65501800.0
2011-04-11 10:00:00	AAPL	Stock	11.902	11.9243	11.8571	11.8957	66959928.0
2011-04-11 11:00:00	AAPL	Stock	11.8957	11.9011	11.8036	11.8093	51040864.0
2011-04-11 12:00:00	AAPL	Stock	11.81	11.8364	11.7864	11.8032	58449160.0
2011-04-11 13:00:00	AAPL	Stock	11.8032	11.8518	11.7918	11.835	40189912.0
2011-04-11 14:00:00	AAPL	Stock	11.8345	11.8496	11.8039	11.81	32001984.0
2011-04-11 15:00:00	AAPL	Stock	11.8091	11.8214	11.7889	11.8211	67697056.0
2011-04-11 16:00:00	AAPL	Stock	11.8211	11.883	11.7947	11.8139	9245320.0
2011-04-11 17:00:00	AAPL	Stock	11.8139	11.9452	11.7918	11.8	301084.0
2011-04-11 18:00:00	AAPL	Stock	11.7979	11.8143	11.7932	11.8036	209244.0
2011-04-11 19:00:00	AAPL	Stock	11.8011	11.8054	11.7936	11.8	147532.0
2011-04-11 05:00:00	MSFT	Stock	26.25	26.25	26.24	26.24	1200.0
2011-04-11 06:00:00	MSFT	Stock	26.24	26.25	26.24	26.25	200.0
2011-04-11 07:00:00	MSFT	Stock	26.23	26.24	26.19	26.19	7100.0
2011-04-11 08:00:00	MSFT	Stock	26.18	26.21	26.16	26.16	17746.0
2011-04-11 09:00:00	MSFT	Stock	26.17	26.25	26.11	26.13	3617294.0
2011-04-11 10:00:00	MSFT	Stock	26.14	26.18	26.01	26.137	4526643.0
2011-04-11 11:00:00	MSFT	Stock	26.13	26.14	26.02	26.02	3647490.0
2011-04-11 12:00:00	MSFT	Stock	26.025	26.05	25.96	25.99	3187326.0
2011-04-11 13:00:00	MSFT	Stock	25.98	25.99	25.821	25.87	5793848.0
2011-04-11 14:00:00	MSFT	Stock	25.88	25.9	25.84	25.85	3450151.0
2011-04-11 15:00:00	MSFT	Stock	25.853	25.99	25.8	25.99	9059736.0
2011-04-11 16:00:00	MSFT	Stock	25.972	26.0	25.841	25.98	610970.0
2011-04-11 17:00:00	MSFT	Stock	25.98	26.0	25.98	25.98	63883.0
2011-04-11 18:00:00	MSFT	Stock	25.98	25.98	25.98	25.98	6800.0
2011-04-11 19:00:00	MSFT	Stock	25.98	25.98	25.8	25.9	18168.0
2011-04-11 08:00:00	NVDA	Stock	0.4395	0.4428	0.4395	0.4422	258000.0
2011-04-11 09:00:00	NVDA	Stock	0.4415	0.4428	0.435	0.436	60730400.0
2011-04-11 10:00:00	NVDA	Stock	0.436	0.4365	0.4282	0.433	134385960.0
2011-04-11 11:00:00	NVDA	Stock	0.4332	0.4354	0.4318	0.432	59108080.0
2011-04-11 12:00:00	NVDA	Stock	0.4322	0.4332	0.43	0.43	63254320.0
2011-04-11 13:00:00	NVDA	Stock	0.4301	0.432	0.4295	0.4318	55465440.0
2011-04-11 14:00:00	NVDA	Stock	0.4318	0.4335	0.4305	0.4308	51557280.0
2011-04-11 15:00:00	NVDA	Stock	0.4309	0.433	0.4295	0.433	99239040.0
2011-04-11 16:00:00	NVDA	Stock	0.4325	0.4338	0.4308	0.4308	6223560.0
2011-04-11 17:00:00	NVDA	Stock	0.4328	0.4328	0.4308	0.4308	143000.0
2011-04-11 18:00:00	NVDA	Stock	0.4325	0.4365	0.4322	0.4328	356000.0
2011-04-11 19:00:00	NVDA	Stock	0.431	0.4328	0.4308	0.4308	138240.0
2011-04-11 07:00:00	AMZN	Stock	9.2515	9.274	9.2515	9.274	4000.0
2011-04-11 08:00:00	AMZN	Stock	9.2505	9.2505	9.2175	9.2175	82000.0
2011-04-11 09:00:00	AMZN	Stock	9.225	9.3245	9.218	9.2475	11786720.0
2011-04-11 10:00:00	AMZN	Stock	9.2455	9.25	9.1765	9.2245	11321080.0
2011-04-11 11:00:00	AMZN	Stock	9.2275	9.2495	9.163	9.164	7569540.0
2011-04-11 12:00:00	AMZN	Stock	9.165	9.1885	9.139	9.159	7427340.0
2011-04-11 13:00:00	AMZN	Stock	9.1575	9.201	9.1455	9.176	6272840.0

> showing 50 of 44,325 rows — these rows as CSV

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