PREVIEW / stock_1hour / 2012-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-10.parquet
  size:    931 KB
  rows:    43,643
  symbols: 3,468

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-09-10 04:00:00	AAPL	Stock	24.295	24.3	24.295	24.3	11648.0
2012-09-10 05:00:00	AAPL	Stock	24.3036	24.3236	24.3036	24.3057	8400.0
2012-09-10 06:00:00	AAPL	Stock	24.3214	24.3321	24.3054	24.3214	51156.0
2012-09-10 07:00:00	AAPL	Stock	24.3179	24.3318	24.2932	24.3293	511420.0
2012-09-10 08:00:00	AAPL	Stock	24.3261	24.3514	24.2675	24.2736	2186800.0
2012-09-10 09:00:00	AAPL	Stock	24.2714	24.4032	24.2368	24.2393	66435376.0
2012-09-10 10:00:00	AAPL	Stock	24.2429	24.2661	23.9868	24.0586	102743396.0
2012-09-10 11:00:00	AAPL	Stock	24.0595	24.1317	24.0407	24.1029	43277304.0
2012-09-10 12:00:00	AAPL	Stock	24.1021	24.1071	23.9464	24.0046	49099484.0
2012-09-10 13:00:00	AAPL	Stock	24.0039	24.0464	23.8446	23.8498	48152440.0
2012-09-10 14:00:00	AAPL	Stock	23.8457	23.91	23.7704	23.7718	60722564.0
2012-09-10 15:00:00	AAPL	Stock	23.7736	23.8393	23.6464	23.6614	99585948.0
2012-09-10 16:00:00	AAPL	Stock	23.6616	24.0064	23.6	23.6239	10094112.0
2012-09-10 17:00:00	AAPL	Stock	23.6214	23.6693	23.5536	23.565	2238208.0
2012-09-10 18:00:00	AAPL	Stock	23.5679	23.5843	23.5504	23.5739	660436.0
2012-09-10 19:00:00	AAPL	Stock	23.5786	23.5839	23.5643	23.5821	480200.0
2012-09-10 08:00:00	MSFT	Stock	30.88	30.94	30.83	30.83	4846.0
2012-09-10 09:00:00	MSFT	Stock	30.86	30.86	30.51	30.61	5000388.0
2012-09-10 10:00:00	MSFT	Stock	30.615	30.8	30.59	30.755	5834095.0
2012-09-10 11:00:00	MSFT	Stock	30.755	30.9	30.75	30.84	3876400.0
2012-09-10 12:00:00	MSFT	Stock	30.84	30.855	30.81	30.848	2708632.0
2012-09-10 13:00:00	MSFT	Stock	30.845	30.85	30.74	30.74	3504159.0
2012-09-10 14:00:00	MSFT	Stock	30.74	30.78	30.65	30.69	3605819.0
2012-09-10 15:00:00	MSFT	Stock	30.69	30.76	30.645	30.72	11281377.0
2012-09-10 16:00:00	MSFT	Stock	30.72	30.842	30.7	30.71	3048765.0
2012-09-10 17:00:00	MSFT	Stock	30.71	30.71	30.63	30.65	201752.0
2012-09-10 19:00:00	MSFT	Stock	30.66	30.66	30.65	30.65	912.0
2012-09-10 08:00:00	NVDA	Stock	0.3333	0.3333	0.3333	0.3333	49920.0
2012-09-10 09:00:00	NVDA	Stock	0.3328	0.3378	0.3328	0.3378	43736760.0
2012-09-10 10:00:00	NVDA	Stock	0.3375	0.339	0.3342	0.335	71179560.0
2012-09-10 11:00:00	NVDA	Stock	0.335	0.3365	0.335	0.3351	30202720.0
2012-09-10 12:00:00	NVDA	Stock	0.3353	0.3355	0.3335	0.335	31036160.0
2012-09-10 13:00:00	NVDA	Stock	0.3351	0.3358	0.3338	0.3338	47548880.0
2012-09-10 14:00:00	NVDA	Stock	0.3338	0.3345	0.3335	0.3338	41232160.0
2012-09-10 15:00:00	NVDA	Stock	0.3335	0.3339	0.3313	0.3321	91688160.0
2012-09-10 16:00:00	NVDA	Stock	0.3322	0.335	0.3319	0.3328	3253320.0
2012-09-10 17:00:00	NVDA	Stock	0.332	0.332	0.3313	0.3313	619000.0
2012-09-10 18:00:00	NVDA	Stock	0.3313	0.3335	0.3313	0.3335	32000.0
2012-09-10 07:00:00	AMZN	Stock	12.947	12.947	12.944	12.945	8000.0
2012-09-10 08:00:00	AMZN	Stock	12.945	12.955	12.902	12.9025	241400.0
2012-09-10 09:00:00	AMZN	Stock	12.91	13.0	12.8785	12.945	10324900.0
2012-09-10 10:00:00	AMZN	Stock	12.943	12.9795	12.8925	12.8995	11412200.0
2012-09-10 11:00:00	AMZN	Stock	12.9015	12.9395	12.8955	12.9155	5123940.0
2012-09-10 12:00:00	AMZN	Stock	12.915	12.917	12.841	12.904	5519020.0
2012-09-10 13:00:00	AMZN	Stock	12.901	12.9295	12.886	12.886	3612280.0
2012-09-10 14:00:00	AMZN	Stock	12.8865	12.937	12.865	12.869	4643660.0
2012-09-10 15:00:00	AMZN	Stock	12.8745	12.916	12.8415	12.8575	8649760.0
2012-09-10 16:00:00	AMZN	Stock	12.8515	12.9124	12.8385	12.851	342120.0
2012-09-10 17:00:00	AMZN	Stock	12.853	12.853	12.8365	12.8475	219240.0
2012-09-10 19:00:00	AMZN	Stock	12.84	12.8475	12.84	12.8475	8000.0

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

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