PREVIEW / stock_1hour / 2012-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-01.parquet
  size:    927 KB
  rows:    43,993
  symbols: 3,459

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-08-01 04:00:00	AAPL	Stock	21.8571	21.9286	21.8571	21.8839	58800.0
2012-08-01 05:00:00	AAPL	Stock	21.8929	21.8929	21.875	21.875	30800.0
2012-08-01 06:00:00	AAPL	Stock	21.875	21.9036	21.875	21.8929	36932.0
2012-08-01 07:00:00	AAPL	Stock	21.8786	21.9604	21.8786	21.9571	1271144.0
2012-08-01 08:00:00	AAPL	Stock	21.9464	22.0475	21.8129	22.04	5336660.0
2012-08-01 09:00:00	AAPL	Stock	22.0396	22.0643	21.81	21.8239	65429364.0
2012-08-01 10:00:00	AAPL	Stock	21.8214	21.8868	21.7414	21.7686	67504444.0
2012-08-01 11:00:00	AAPL	Stock	21.7689	21.7975	21.6268	21.6807	47630996.0
2012-08-01 12:00:00	AAPL	Stock	21.68	21.75	21.6536	21.7089	25671632.0
2012-08-01 13:00:00	AAPL	Stock	21.7054	21.7461	21.6557	21.6625	19844552.0
2012-08-01 14:00:00	AAPL	Stock	21.6625	21.7929	21.5357	21.7782	68632200.0
2012-08-01 15:00:00	AAPL	Stock	21.7812	21.8461	21.6532	21.6729	67314520.0
2012-08-01 16:00:00	AAPL	Stock	21.6718	21.8446	21.6429	21.6696	6396740.0
2012-08-01 17:00:00	AAPL	Stock	21.6824	21.6824	21.6679	21.6682	130340.0
2012-08-01 18:00:00	AAPL	Stock	21.6686	21.6714	21.6607	21.6611	236796.0
2012-08-01 19:00:00	AAPL	Stock	21.6618	21.6786	21.6607	21.6754	182812.0
2012-08-01 06:00:00	MSFT	Stock	29.54	29.54	29.54	29.54	132.0
2012-08-01 08:00:00	MSFT	Stock	29.55	29.72	29.45	29.66	75501.0
2012-08-01 09:00:00	MSFT	Stock	29.7	29.73	29.34	29.39	2572871.0
2012-08-01 10:00:00	MSFT	Stock	29.39	29.55	29.355	29.48	4418775.0
2012-08-01 11:00:00	MSFT	Stock	29.49	29.54	29.42	29.49	3602195.0
2012-08-01 12:00:00	MSFT	Stock	29.485	29.59	29.47	29.5	3563742.0
2012-08-01 13:00:00	MSFT	Stock	29.51	29.55	29.41	29.42	3160437.0
2012-08-01 14:00:00	MSFT	Stock	29.43	29.44	29.21	29.35	4893188.0
2012-08-01 15:00:00	MSFT	Stock	29.35	29.53	29.32	29.41	6712011.0
2012-08-01 16:00:00	MSFT	Stock	29.41	29.513	29.37	29.41	1590252.0
2012-08-01 17:00:00	MSFT	Stock	29.522	29.522	29.522	29.522	3100.0
2012-08-01 18:00:00	MSFT	Stock	29.41	29.41	29.41	29.41	171.0
2012-08-01 19:00:00	MSFT	Stock	29.41	29.41	29.4	29.4	650.0
2012-08-01 08:00:00	NVDA	Stock	0.3382	0.3402	0.3382	0.3395	44000.0
2012-08-01 09:00:00	NVDA	Stock	0.341	0.3438	0.3342	0.337	35396800.0
2012-08-01 10:00:00	NVDA	Stock	0.3369	0.3389	0.3353	0.337	58310600.0
2012-08-01 11:00:00	NVDA	Stock	0.3371	0.3373	0.3355	0.337	36124200.0
2012-08-01 12:00:00	NVDA	Stock	0.337	0.3395	0.3368	0.339	34838560.0
2012-08-01 13:00:00	NVDA	Stock	0.339	0.3398	0.3355	0.3358	30747800.0
2012-08-01 14:00:00	NVDA	Stock	0.3358	0.3365	0.3333	0.3353	61931960.0
2012-08-01 15:00:00	NVDA	Stock	0.3353	0.3362	0.3342	0.3348	69991040.0
2012-08-01 16:00:00	NVDA	Stock	0.3348	0.3348	0.3348	0.3348	7359120.0
2012-08-01 17:00:00	NVDA	Stock	0.3335	0.3335	0.3335	0.3335	4000.0
2012-08-01 07:00:00	AMZN	Stock	11.72	11.75	11.7	11.7255	58000.0
2012-08-01 08:00:00	AMZN	Stock	11.665	11.7485	11.64	11.74	345180.0
2012-08-01 09:00:00	AMZN	Stock	11.7285	11.7445	11.603	11.6225	6648880.0
2012-08-01 10:00:00	AMZN	Stock	11.6205	11.6705	11.5775	11.6265	10272280.0
2012-08-01 11:00:00	AMZN	Stock	11.627	11.6815	11.5855	11.5911	5731920.0
2012-08-01 12:00:00	AMZN	Stock	11.5922	11.6275	11.584	11.596	2885180.0
2012-08-01 13:00:00	AMZN	Stock	11.5955	11.614	11.5875	11.59	2725660.0
2012-08-01 14:00:00	AMZN	Stock	11.588	11.645	11.535	11.5745	8646240.0
2012-08-01 15:00:00	AMZN	Stock	11.569	11.6325	11.5575	11.6075	11002940.0
2012-08-01 16:00:00	AMZN	Stock	11.6045	11.6174	11.6016	11.6125	205060.0
2012-08-01 18:00:00	AMZN	Stock	11.6045	11.606	11.6045	11.6045	7000.0

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

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