PREVIEW / stock_1hour / 2012-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-25.parquet
  size:    920 KB
  rows:    43,696
  symbols: 3,485

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-10-25 04:00:00	AAPL	Stock	22.0271	22.125	22.0271	22.0929	126112.0
2012-10-25 05:00:00	AAPL	Stock	22.1032	22.1161	22.0964	22.0964	109116.0
2012-10-25 06:00:00	AAPL	Stock	22.0929	22.1061	22.0929	22.1061	5768.0
2012-10-25 07:00:00	AAPL	Stock	22.0932	22.175	22.0893	22.1546	763084.0
2012-10-25 08:00:00	AAPL	Stock	22.1429	22.1604	22.0764	22.1193	1785644.0
2012-10-25 09:00:00	AAPL	Stock	22.1196	22.2143	21.9139	21.9382	69271748.0
2012-10-25 10:00:00	AAPL	Stock	21.9382	22.0639	21.8986	21.9161	62101032.0
2012-10-25 11:00:00	AAPL	Stock	21.9107	22.0011	21.8054	21.8643	54813612.0
2012-10-25 12:00:00	AAPL	Stock	21.87	21.8871	21.6904	21.7971	75338088.0
2012-10-25 13:00:00	AAPL	Stock	21.7964	21.8846	21.7421	21.865	58028208.0
2012-10-25 14:00:00	AAPL	Stock	21.8675	21.91	21.7607	21.7964	69351296.0
2012-10-25 15:00:00	AAPL	Stock	21.7921	21.8271	21.6268	21.7732	139815228.0
2012-10-25 16:00:00	AAPL	Stock	21.7786	21.9912	20.8964	21.75	63148540.0
2012-10-25 17:00:00	AAPL	Stock	21.7486	21.8339	21.4282	21.7739	41578768.0
2012-10-25 18:00:00	AAPL	Stock	21.7857	21.8036	21.6614	21.7711	3276280.0
2012-10-25 19:00:00	AAPL	Stock	21.7768	21.7843	21.7504	21.7743	1720852.0
2012-10-25 04:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	500.0
2012-10-25 06:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	200.0
2012-10-25 07:00:00	MSFT	Stock	28.19	28.19	28.05	28.09	3472.0
2012-10-25 08:00:00	MSFT	Stock	28.09	28.18	28.05	28.15	69521.0
2012-10-25 09:00:00	MSFT	Stock	28.15	28.21	27.955	27.98	6008413.0
2012-10-25 10:00:00	MSFT	Stock	27.98	28.07	27.89	27.9	7267404.0
2012-10-25 11:00:00	MSFT	Stock	27.905	27.96	27.86	27.915	5905652.0
2012-10-25 12:00:00	MSFT	Stock	27.915	27.98	27.86	27.972	5364369.0
2012-10-25 13:00:00	MSFT	Stock	27.98	28.01	27.91	27.94	4736355.0
2012-10-25 14:00:00	MSFT	Stock	27.94	28.02	27.88	27.99	4961069.0
2012-10-25 15:00:00	MSFT	Stock	28.0	28.03	27.86	27.89	14026970.0
2012-10-25 16:00:00	MSFT	Stock	27.89	27.972	27.79	27.85	3884120.0
2012-10-25 17:00:00	MSFT	Stock	27.84	27.89	27.83	27.89	3407.0
2012-10-25 18:00:00	MSFT	Stock	27.85	27.87	27.85	27.87	5280.0
2012-10-25 19:00:00	MSFT	Stock	27.87	27.92	27.87	27.9	9800.0
2012-10-25 06:00:00	NVDA	Stock	0.295	0.31	0.295	0.31	12000.0
2012-10-25 08:00:00	NVDA	Stock	0.3062	0.3062	0.3062	0.3062	16000.0
2012-10-25 09:00:00	NVDA	Stock	0.3085	0.31	0.3045	0.3058	28148680.0
2012-10-25 10:00:00	NVDA	Stock	0.3058	0.3085	0.305	0.3071	58791800.0
2012-10-25 11:00:00	NVDA	Stock	0.3073	0.3083	0.305	0.3059	52089880.0
2012-10-25 12:00:00	NVDA	Stock	0.306	0.3065	0.3042	0.3059	29586640.0
2012-10-25 13:00:00	NVDA	Stock	0.3059	0.3062	0.3042	0.3054	31985000.0
2012-10-25 14:00:00	NVDA	Stock	0.3052	0.3054	0.3032	0.3041	34494920.0
2012-10-25 15:00:00	NVDA	Stock	0.3042	0.305	0.3035	0.3044	54798920.0
2012-10-25 16:00:00	NVDA	Stock	0.3045	0.3056	0.3025	0.3025	15421520.0
2012-10-25 17:00:00	NVDA	Stock	0.3052	0.3052	0.3038	0.3038	36000.0
2012-10-25 18:00:00	NVDA	Stock	0.3038	0.3052	0.3038	0.3052	20000.0
2012-10-25 08:00:00	AMZN	Stock	11.48	11.5105	11.475	11.5095	91400.0
2012-10-25 09:00:00	AMZN	Stock	11.497	11.546	11.305	11.3895	11417720.0
2012-10-25 10:00:00	AMZN	Stock	11.3795	11.4775	11.35	11.3814	11204260.0
2012-10-25 11:00:00	AMZN	Stock	11.387	11.424	11.319	11.3725	6295040.0
2012-10-25 12:00:00	AMZN	Stock	11.369	11.425	11.355	11.403	5080340.0
2012-10-25 13:00:00	AMZN	Stock	11.409	11.481	11.376	11.4431	5994940.0
2012-10-25 14:00:00	AMZN	Stock	11.4464	11.4535	11.39	11.45	6614460.0

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

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