PREVIEW / stock_1hour / 2012-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-22.parquet
  size:    939 KB
  rows:    44,284
  symbols: 3,536

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-05-22 04:00:00	AAPL	Stock	20.1786	20.4286	20.1786	20.1786	224560.0
2012-05-22 05:00:00	AAPL	Stock	20.1643	20.1643	20.1107	20.1593	38220.0
2012-05-22 06:00:00	AAPL	Stock	20.1321	20.1429	20.1111	20.1429	24920.0
2012-05-22 07:00:00	AAPL	Stock	20.1561	20.2136	20.0975	20.2018	1170904.0
2012-05-22 08:00:00	AAPL	Stock	20.2032	20.3464	20.1429	20.1925	8589420.0
2012-05-22 09:00:00	AAPL	Stock	20.1932	20.4957	20.1825	20.3829	144948524.0
2012-05-22 10:00:00	AAPL	Stock	20.3807	20.4	20.1964	20.2441	145733056.0
2012-05-22 11:00:00	AAPL	Stock	20.2421	20.3429	20.1389	20.1514	56326116.0
2012-05-22 12:00:00	AAPL	Stock	20.155	20.23	20.0357	20.2037	80039652.0
2012-05-22 13:00:00	AAPL	Stock	20.2064	20.2406	20.0714	20.0941	48041140.0
2012-05-22 14:00:00	AAPL	Stock	20.0971	20.1904	20.0186	20.0296	53674208.0
2012-05-22 15:00:00	AAPL	Stock	20.03	20.0975	19.735	19.8896	132252792.0
2012-05-22 16:00:00	AAPL	Stock	19.8867	20.4238	19.7711	19.8836	11991952.0
2012-05-22 17:00:00	AAPL	Stock	19.8661	19.8918	19.8293	19.8482	158088.0
2012-05-22 18:00:00	AAPL	Stock	19.8393	19.9036	19.8386	19.8836	532924.0
2012-05-22 19:00:00	AAPL	Stock	19.8875	19.8879	19.8214	19.8396	408800.0
2012-05-22 08:00:00	MSFT	Stock	29.88	29.88	29.63	29.63	31984.0
2012-05-22 09:00:00	MSFT	Stock	29.69	29.76	29.5	29.66	3749929.0
2012-05-22 10:00:00	MSFT	Stock	29.65	29.8	29.635	29.745	5189180.0
2012-05-22 11:00:00	MSFT	Stock	29.745	29.82	29.725	29.77	3312701.0
2012-05-22 12:00:00	MSFT	Stock	29.765	29.81	29.7	29.81	4845561.0
2012-05-22 13:00:00	MSFT	Stock	29.81	29.88	29.78	29.79	2846862.0
2012-05-22 14:00:00	MSFT	Stock	29.8	29.846	29.7	29.73	3174160.0
2012-05-22 15:00:00	MSFT	Stock	29.73	29.78	29.58	29.77	11476430.0
2012-05-22 16:00:00	MSFT	Stock	29.77	29.83	29.64	29.67	4063232.0
2012-05-22 17:00:00	MSFT	Stock	29.69	29.7	29.61	29.61	9282.0
2012-05-22 18:00:00	MSFT	Stock	29.62	29.62	29.62	29.62	310.0
2012-05-22 19:00:00	MSFT	Stock	29.65	29.68	29.65	29.68	3369.0
2012-05-22 07:00:00	NVDA	Stock	0.308	0.308	0.308	0.308	8000.0
2012-05-22 08:00:00	NVDA	Stock	0.311	0.311	0.311	0.311	16000.0
2012-05-22 09:00:00	NVDA	Stock	0.308	0.308	0.3005	0.3008	45719560.0
2012-05-22 10:00:00	NVDA	Stock	0.3008	0.3032	0.299	0.3016	103236720.0
2012-05-22 11:00:00	NVDA	Stock	0.3018	0.3025	0.3005	0.3008	47585880.0
2012-05-22 12:00:00	NVDA	Stock	0.3009	0.3025	0.2998	0.3025	31780600.0
2012-05-22 13:00:00	NVDA	Stock	0.3025	0.3032	0.3018	0.3029	23541520.0
2012-05-22 14:00:00	NVDA	Stock	0.303	0.305	0.3028	0.3048	54464400.0
2012-05-22 15:00:00	NVDA	Stock	0.3045	0.3052	0.301	0.3032	87211560.0
2012-05-22 16:00:00	NVDA	Stock	0.3035	0.304	0.3012	0.3035	16080960.0
2012-05-22 18:00:00	NVDA	Stock	0.302	0.3022	0.302	0.3022	47000.0
2012-05-22 19:00:00	NVDA	Stock	0.3022	0.3022	0.3	0.3018	154000.0
2012-05-22 06:00:00	AMZN	Stock	10.8995	10.8995	10.8995	10.8995	4000.0
2012-05-22 07:00:00	AMZN	Stock	10.905	10.935	10.905	10.935	34700.0
2012-05-22 08:00:00	AMZN	Stock	10.925	10.9655	10.9	10.9	192980.0
2012-05-22 09:00:00	AMZN	Stock	10.8805	10.925	10.761	10.8295	13259580.0
2012-05-22 10:00:00	AMZN	Stock	10.828	10.9435	10.791	10.8405	17394520.0
2012-05-22 11:00:00	AMZN	Stock	10.839	10.892	10.8275	10.8575	9948480.0
2012-05-22 12:00:00	AMZN	Stock	10.8575	10.8865	10.775	10.875	6045400.0
2012-05-22 13:00:00	AMZN	Stock	10.877	10.903	10.785	10.8125	4091600.0
2012-05-22 14:00:00	AMZN	Stock	10.8135	10.878	10.8075	10.8255	6739980.0
2012-05-22 15:00:00	AMZN	Stock	10.824	10.8445	10.698	10.7805	14384500.0

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

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