PREVIEW / stock_1hour / 2012-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-12.parquet
  size:    925 KB
  rows:    43,629
  symbols: 3,466

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-12 04:00:00	AAPL	Stock	23.7507	23.7857	23.7061	23.7857	135380.0
2012-09-12 05:00:00	AAPL	Stock	23.7857	23.8568	23.7857	23.8532	77644.0
2012-09-12 06:00:00	AAPL	Stock	23.8393	23.8429	23.7857	23.7857	87528.0
2012-09-12 07:00:00	AAPL	Stock	23.8089	23.8393	23.7132	23.7139	1063272.0
2012-09-12 08:00:00	AAPL	Stock	23.7143	23.8125	23.7107	23.7714	2570148.0
2012-09-12 09:00:00	AAPL	Stock	23.775	23.8214	23.6021	23.6246	66758160.0
2012-09-12 10:00:00	AAPL	Stock	23.625	23.6357	23.5179	23.5762	70195636.0
2012-09-12 11:00:00	AAPL	Stock	23.5786	23.6964	23.5243	23.6631	51228800.0
2012-09-12 12:00:00	AAPL	Stock	23.6632	23.6854	23.5386	23.6099	39619636.0
2012-09-12 13:00:00	AAPL	Stock	23.6136	23.8775	23.4421	23.6743	197808968.0
2012-09-12 14:00:00	AAPL	Stock	23.6836	23.7975	23.5111	23.5282	106532608.0
2012-09-12 15:00:00	AAPL	Stock	23.5321	23.925	23.4286	23.9236	150618048.0
2012-09-12 16:00:00	AAPL	Stock	23.9225	24.0429	23.5282	23.9946	14681156.0
2012-09-12 17:00:00	AAPL	Stock	23.9914	23.9957	23.9211	23.9768	1307432.0
2012-09-12 18:00:00	AAPL	Stock	23.9771	24.0	23.9679	23.9714	840280.0
2012-09-12 19:00:00	AAPL	Stock	23.9811	23.9904	23.9714	23.9714	522004.0
2012-09-12 08:00:00	MSFT	Stock	30.9	30.9	30.79	30.87	8842.0
2012-09-12 09:00:00	MSFT	Stock	30.88	31.18	30.87	31.03	3581478.0
2012-09-12 10:00:00	MSFT	Stock	31.02	31.08	30.96	31.05	4198676.0
2012-09-12 11:00:00	MSFT	Stock	31.06	31.07	30.87	30.88	3200711.0
2012-09-12 12:00:00	MSFT	Stock	30.88	30.9	30.833	30.89	2254318.0
2012-09-12 13:00:00	MSFT	Stock	30.89	30.96	30.88	30.92	2572127.0
2012-09-12 14:00:00	MSFT	Stock	30.919	30.99	30.84	30.84	3956839.0
2012-09-12 15:00:00	MSFT	Stock	30.84	30.86	30.73	30.78	7490657.0
2012-09-12 16:00:00	MSFT	Stock	30.78	31.04	30.76	30.941	2793396.0
2012-09-12 17:00:00	MSFT	Stock	30.84	30.84	30.78	30.84	24745.0
2012-09-12 18:00:00	MSFT	Stock	30.84	30.86	30.83	30.83	8845.0
2012-09-12 19:00:00	MSFT	Stock	30.83	30.84	30.8	30.81	2820.0
2012-09-12 09:00:00	NVDA	Stock	0.3388	0.3415	0.337	0.3393	37794360.0
2012-09-12 10:00:00	NVDA	Stock	0.3393	0.34	0.3355	0.3382	46882480.0
2012-09-12 11:00:00	NVDA	Stock	0.3382	0.3398	0.3382	0.3385	36530920.0
2012-09-12 12:00:00	NVDA	Stock	0.3388	0.3395	0.3382	0.3393	18943320.0
2012-09-12 13:00:00	NVDA	Stock	0.3395	0.34	0.3388	0.3389	32015240.0
2012-09-12 14:00:00	NVDA	Stock	0.3389	0.3393	0.338	0.3384	34332680.0
2012-09-12 15:00:00	NVDA	Stock	0.3385	0.3398	0.3375	0.3398	78051000.0
2012-09-12 16:00:00	NVDA	Stock	0.3395	0.3398	0.336	0.3398	27615560.0
2012-09-12 17:00:00	NVDA	Stock	0.3405	0.3405	0.3405	0.3405	46400.0
2012-09-12 18:00:00	NVDA	Stock	0.3405	0.3405	0.3405	0.3405	4000.0
2012-09-12 07:00:00	AMZN	Stock	12.804	12.804	12.8	12.8015	13180.0
2012-09-12 08:00:00	AMZN	Stock	12.8395	12.8395	12.8125	12.82	70280.0
2012-09-12 09:00:00	AMZN	Stock	12.82	12.889	12.797	12.8465	6606800.0
2012-09-12 10:00:00	AMZN	Stock	12.8475	12.865	12.721	12.746	7436260.0
2012-09-12 11:00:00	AMZN	Stock	12.75	12.764	12.675	12.7421	8167280.0
2012-09-12 12:00:00	AMZN	Stock	12.743	12.7995	12.7204	12.7915	3683020.0
2012-09-12 13:00:00	AMZN	Stock	12.792	12.8115	12.7475	12.7895	4677200.0
2012-09-12 14:00:00	AMZN	Stock	12.7892	12.8095	12.7005	12.7495	4573900.0
2012-09-12 15:00:00	AMZN	Stock	12.749	12.785	12.69	12.7795	8126940.0
2012-09-12 16:00:00	AMZN	Stock	12.7815	12.8	12.7398	12.7995	1503940.0
2012-09-12 17:00:00	AMZN	Stock	12.7835	12.79	12.7835	12.79	9000.0
2012-09-12 19:00:00	AMZN	Stock	12.798	12.8115	12.7965	12.81	32000.0

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

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