PREVIEW / stock_1hour / 2012-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-15.parquet
  size:    908 KB
  rows:    43,179
  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-08-15 04:00:00	AAPL	Stock	22.5357	22.5786	22.5357	22.5786	30800.0
2012-08-15 05:00:00	AAPL	Stock	22.6071	22.6107	22.5893	22.5893	43316.0
2012-08-15 06:00:00	AAPL	Stock	22.5786	22.5786	22.5393	22.5714	25788.0
2012-08-15 07:00:00	AAPL	Stock	22.5711	22.5714	22.5071	22.5439	469728.0
2012-08-15 08:00:00	AAPL	Stock	22.5475	22.6229	22.5264	22.6068	1416464.0
2012-08-15 09:00:00	AAPL	Stock	22.6093	22.6429	22.5203	22.6068	49772940.0
2012-08-15 10:00:00	AAPL	Stock	22.6121	22.6175	22.5196	22.5829	38317076.0
2012-08-15 11:00:00	AAPL	Stock	22.5828	22.6243	22.5554	22.5846	21980224.0
2012-08-15 12:00:00	AAPL	Stock	22.5821	22.6021	22.5379	22.5446	14498960.0
2012-08-15 13:00:00	AAPL	Stock	22.545	22.5459	22.4393	22.4435	36828512.0
2012-08-15 14:00:00	AAPL	Stock	22.4426	22.4971	22.4196	22.4946	28410032.0
2012-08-15 15:00:00	AAPL	Stock	22.4946	22.5475	22.4907	22.5225	39399948.0
2012-08-15 16:00:00	AAPL	Stock	22.5282	22.5727	22.4917	22.5429	16164540.0
2012-08-15 17:00:00	AAPL	Stock	22.5375	22.5489	22.5321	22.5461	165984.0
2012-08-15 18:00:00	AAPL	Stock	22.5457	22.5589	22.5457	22.55	91084.0
2012-08-15 19:00:00	AAPL	Stock	22.5496	22.5536	22.5446	22.5536	134904.0
2012-08-15 08:00:00	MSFT	Stock	30.09	30.09	30.0	30.08	5890.0
2012-08-15 09:00:00	MSFT	Stock	30.05	30.28	30.02	30.24	2524562.0
2012-08-15 10:00:00	MSFT	Stock	30.24	30.27	30.12	30.16	3639528.0
2012-08-15 11:00:00	MSFT	Stock	30.163	30.2	30.124	30.18	2720980.0
2012-08-15 12:00:00	MSFT	Stock	30.17	30.19	30.14	30.145	1564896.0
2012-08-15 13:00:00	MSFT	Stock	30.15	30.15	30.08	30.12	2632155.0
2012-08-15 14:00:00	MSFT	Stock	30.115	30.13	30.08	30.11	3515372.0
2012-08-15 15:00:00	MSFT	Stock	30.115	30.25	30.11	30.19	6535778.0
2012-08-15 16:00:00	MSFT	Stock	30.2	30.29	30.14	30.28	1015742.0
2012-08-15 17:00:00	MSFT	Stock	30.24	30.24	30.24	30.24	20144.0
2012-08-15 19:00:00	MSFT	Stock	30.28	30.28	30.26	30.26	662.0
2012-08-15 08:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	4000.0
2012-08-15 09:00:00	NVDA	Stock	0.365	0.369	0.365	0.3662	100489360.0
2012-08-15 10:00:00	NVDA	Stock	0.3665	0.3685	0.366	0.3682	87141080.0
2012-08-15 11:00:00	NVDA	Stock	0.368	0.3685	0.367	0.3675	56593920.0
2012-08-15 12:00:00	NVDA	Stock	0.3675	0.368	0.367	0.3675	37270920.0
2012-08-15 13:00:00	NVDA	Stock	0.3674	0.3675	0.364	0.364	50818760.0
2012-08-15 14:00:00	NVDA	Stock	0.3641	0.3642	0.3601	0.3625	129712280.0
2012-08-15 15:00:00	NVDA	Stock	0.3625	0.3632	0.3609	0.3618	105518200.0
2012-08-15 16:00:00	NVDA	Stock	0.362	0.3648	0.3614	0.364	9234560.0
2012-08-15 17:00:00	NVDA	Stock	0.3642	0.365	0.3638	0.3638	108040.0
2012-08-15 18:00:00	NVDA	Stock	0.3632	0.3632	0.3632	0.3632	20000.0
2012-08-15 19:00:00	NVDA	Stock	0.364	0.364	0.364	0.364	16000.0
2012-08-15 08:00:00	AMZN	Stock	11.64	11.651	11.6375	11.65	34000.0
2012-08-15 09:00:00	AMZN	Stock	11.6625	11.7875	11.6125	11.7359	10053900.0
2012-08-15 10:00:00	AMZN	Stock	11.739	11.772	11.7225	11.75	10851580.0
2012-08-15 11:00:00	AMZN	Stock	11.7545	11.797	11.746	11.795	6625340.0
2012-08-15 12:00:00	AMZN	Stock	11.7935	11.8	11.754	11.765	5216180.0
2012-08-15 13:00:00	AMZN	Stock	11.7665	11.7775	11.75	11.759	4363520.0
2012-08-15 14:00:00	AMZN	Stock	11.755	11.814	11.754	11.8116	5335380.0
2012-08-15 15:00:00	AMZN	Stock	11.8116	11.907	11.8075	11.871	21053520.0
2012-08-15 16:00:00	AMZN	Stock	11.8715	11.9	11.797	11.8546	1465920.0
2012-08-15 17:00:00	AMZN	Stock	11.8875	11.898	11.871	11.898	42940.0
2012-08-15 18:00:00	AMZN	Stock	11.8965	11.898	11.895	11.8975	14000.0

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

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