PREVIEW / stock_1hour / 2011-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-22.parquet
  size:    923 KB
  rows:    44,660
  symbols: 3,546

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
2011-08-22 04:00:00	AAPL	Stock	12.8179	12.8571	12.8179	12.8571	58800.0
2011-08-22 05:00:00	AAPL	Stock	12.8571	12.8693	12.8571	12.8693	24780.0
2011-08-22 06:00:00	AAPL	Stock	12.8571	12.8879	12.8571	12.8861	14000.0
2011-08-22 07:00:00	AAPL	Stock	12.8904	12.98	12.8575	12.9639	1050532.0
2011-08-22 08:00:00	AAPL	Stock	12.9636	12.9779	12.8971	12.9464	4316732.0
2011-08-22 09:00:00	AAPL	Stock	12.9464	13.0314	12.8314	12.8396	87296300.0
2011-08-22 10:00:00	AAPL	Stock	12.8446	12.9186	12.7807	12.8282	91096740.0
2011-08-22 11:00:00	AAPL	Stock	12.8254	12.8568	12.7082	12.7179	74191096.0
2011-08-22 12:00:00	AAPL	Stock	12.7182	12.8643	12.7111	12.8546	69790112.0
2011-08-22 13:00:00	AAPL	Stock	12.8536	12.8911	12.7468	12.8011	58451288.0
2011-08-22 14:00:00	AAPL	Stock	12.8004	12.8586	12.7107	12.7143	48951084.0
2011-08-22 15:00:00	AAPL	Stock	12.7143	12.7957	12.6818	12.7289	79728768.0
2011-08-22 16:00:00	AAPL	Stock	12.7139	12.8464	12.7139	12.8464	11217220.0
2011-08-22 17:00:00	AAPL	Stock	12.7404	12.7443	12.7368	12.7411	107128.0
2011-08-22 18:00:00	AAPL	Stock	12.7364	12.74	12.7229	12.7318	292432.0
2011-08-22 19:00:00	AAPL	Stock	12.7239	12.7321	12.7143	12.7321	415184.0
2011-08-22 06:00:00	MSFT	Stock	24.37	24.37	24.37	24.37	6000.0
2011-08-22 07:00:00	MSFT	Stock	24.34	24.38	24.31	24.35	5810.0
2011-08-22 08:00:00	MSFT	Stock	24.33	24.4	24.3	24.35	54956.0
2011-08-22 09:00:00	MSFT	Stock	24.35	24.49	24.15	24.152	8706663.0
2011-08-22 10:00:00	MSFT	Stock	24.16	24.23	23.96	23.98	7366784.0
2011-08-22 11:00:00	MSFT	Stock	23.98	24.02	23.79	23.89	8109592.0
2011-08-22 12:00:00	MSFT	Stock	23.89	24.16	23.87	24.14	5470419.0
2011-08-22 13:00:00	MSFT	Stock	24.14	24.18	23.95	24.05	3992930.0
2011-08-22 14:00:00	MSFT	Stock	24.05	24.11	23.89	23.9	5662504.0
2011-08-22 15:00:00	MSFT	Stock	23.9	24.11	23.89	23.96	11329913.0
2011-08-22 16:00:00	MSFT	Stock	23.96	24.15	23.94	24.07	3280390.0
2011-08-22 17:00:00	MSFT	Stock	23.98	24.07	23.98	24.05	50325.0
2011-08-22 18:00:00	MSFT	Stock	24.05	24.09	23.98	24.05	53205.0
2011-08-22 19:00:00	MSFT	Stock	24.05	24.05	24.05	24.05	26730.0
2011-08-22 08:00:00	NVDA	Stock	0.3002	0.3025	0.3002	0.3025	260400.0
2011-08-22 09:00:00	NVDA	Stock	0.3058	0.3078	0.2974	0.3026	78740640.0
2011-08-22 10:00:00	NVDA	Stock	0.3025	0.3048	0.3006	0.301	95382360.0
2011-08-22 11:00:00	NVDA	Stock	0.3008	0.3018	0.2951	0.2971	87571560.0
2011-08-22 12:00:00	NVDA	Stock	0.2971	0.302	0.297	0.3018	67490720.0
2011-08-22 13:00:00	NVDA	Stock	0.3018	0.3032	0.2988	0.3009	78302480.0
2011-08-22 14:00:00	NVDA	Stock	0.301	0.3025	0.2985	0.2985	65424240.0
2011-08-22 15:00:00	NVDA	Stock	0.2986	0.3002	0.297	0.2985	111071480.0
2011-08-22 16:00:00	NVDA	Stock	0.2988	0.3005	0.297	0.2998	4637760.0
2011-08-22 17:00:00	NVDA	Stock	0.2988	0.2988	0.2975	0.2975	30000.0
2011-08-22 18:00:00	NVDA	Stock	0.297	0.297	0.297	0.297	72000.0
2011-08-22 19:00:00	NVDA	Stock	0.298	0.298	0.298	0.298	12000.0
2011-08-22 04:00:00	AMZN	Stock	8.948	9.0475	8.948	9.0475	8000.0
2011-08-22 06:00:00	AMZN	Stock	9.068	9.068	9.068	9.068	2000.0
2011-08-22 07:00:00	AMZN	Stock	9.093	9.159	9.0505	9.14	89100.0
2011-08-22 08:00:00	AMZN	Stock	9.1575	9.16	9.1055	9.145	324420.0
2011-08-22 09:00:00	AMZN	Stock	9.14	9.2	8.9925	9.004	17943320.0
2011-08-22 10:00:00	AMZN	Stock	9.0112	9.21	8.994	9.0475	20003520.0
2011-08-22 11:00:00	AMZN	Stock	9.0485	9.0656	8.859	8.891	18249020.0
2011-08-22 12:00:00	AMZN	Stock	8.893	9.0495	8.8735	9.043	10682300.0

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

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