PREVIEW / stock_1hour / 2011-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-21.parquet
  size:    971 KB
  rows:    46,510
  symbols: 3,531

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-03-21 04:00:00	AAPL	Stock	11.8929	12.0	11.8929	12.0	121800.0
2011-03-21 05:00:00	AAPL	Stock	11.9821	12.0	11.97	11.9821	56000.0
2011-03-21 06:00:00	AAPL	Stock	12.0	12.0	11.9857	11.9929	78400.0
2011-03-21 07:00:00	AAPL	Stock	11.9929	12.0321	11.9732	12.0096	957152.0
2011-03-21 08:00:00	AAPL	Stock	12.0036	12.0179	11.9643	11.9821	3434760.0
2011-03-21 09:00:00	AAPL	Stock	11.9836	12.1029	11.9696	12.0709	98547764.0
2011-03-21 10:00:00	AAPL	Stock	12.0714	12.0893	12.0407	12.0654	70982380.0
2011-03-21 11:00:00	AAPL	Stock	12.0661	12.1336	12.0654	12.0857	62091708.0
2011-03-21 12:00:00	AAPL	Stock	12.0868	12.1104	12.0821	12.0954	27833344.0
2011-03-21 13:00:00	AAPL	Stock	12.0952	12.0984	12.0418	12.0982	33902596.0
2011-03-21 14:00:00	AAPL	Stock	12.0986	12.1211	12.0907	12.0948	34417740.0
2011-03-21 15:00:00	AAPL	Stock	12.0936	12.1261	12.0696	12.1143	58614472.0
2011-03-21 16:00:00	AAPL	Stock	12.115	12.1307	12.0644	12.1246	8531096.0
2011-03-21 17:00:00	AAPL	Stock	12.1243	12.1332	12.0139	12.1289	456904.0
2011-03-21 18:00:00	AAPL	Stock	12.1325	12.1404	12.1179	12.1332	381164.0
2011-03-21 19:00:00	AAPL	Stock	12.1304	12.1404	12.1304	12.1382	444472.0
2011-03-21 04:00:00	MSFT	Stock	24.97	25.04	24.97	25.04	1000.0
2011-03-21 05:00:00	MSFT	Stock	25.04	25.04	25.04	25.04	100.0
2011-03-21 06:00:00	MSFT	Stock	25.05	25.11	25.03	25.03	500.0
2011-03-21 07:00:00	MSFT	Stock	25.03	25.06	25.03	25.05	4634.0
2011-03-21 08:00:00	MSFT	Stock	25.01	25.08	24.96	25.07	51959.0
2011-03-21 09:00:00	MSFT	Stock	25.07	25.51	25.04	25.502	6955218.0
2011-03-21 10:00:00	MSFT	Stock	25.5	25.58	25.45	25.52	8421029.0
2011-03-21 11:00:00	MSFT	Stock	25.52	25.56	25.28	25.28	6114222.0
2011-03-21 12:00:00	MSFT	Stock	25.282	25.41	25.28	25.335	3260855.0
2011-03-21 13:00:00	MSFT	Stock	25.331	25.37	25.27	25.31	3440923.0
2011-03-21 14:00:00	MSFT	Stock	25.32	25.33	25.25	25.25	2721035.0
2011-03-21 15:00:00	MSFT	Stock	25.25	25.35	25.17	25.34	11414341.0
2011-03-21 16:00:00	MSFT	Stock	25.35	25.55	24.89	25.29	2155655.0
2011-03-21 17:00:00	MSFT	Stock	25.26	25.376	25.23	25.376	66138.0
2011-03-21 18:00:00	MSFT	Stock	25.35	25.35	25.23	25.24	28211.0
2011-03-21 19:00:00	MSFT	Stock	25.28	25.37	25.27	25.32	14560.0
2011-03-21 06:00:00	NVDA	Stock	0.4468	0.4468	0.4468	0.4468	22000.0
2011-03-21 07:00:00	NVDA	Stock	0.45	0.4502	0.45	0.45	32000.0
2011-03-21 08:00:00	NVDA	Stock	0.45	0.452	0.4488	0.449	1073880.0
2011-03-21 09:00:00	NVDA	Stock	0.448	0.4545	0.4455	0.4462	141436640.0
2011-03-21 10:00:00	NVDA	Stock	0.446	0.4472	0.4408	0.444	213609440.0
2011-03-21 11:00:00	NVDA	Stock	0.4442	0.4475	0.4432	0.445	92067160.0
2011-03-21 12:00:00	NVDA	Stock	0.445	0.4458	0.4425	0.443	44603920.0
2011-03-21 13:00:00	NVDA	Stock	0.443	0.4432	0.4395	0.4418	68665080.0
2011-03-21 14:00:00	NVDA	Stock	0.4418	0.4475	0.4415	0.447	72137400.0
2011-03-21 15:00:00	NVDA	Stock	0.447	0.4475	0.443	0.443	98748320.0
2011-03-21 16:00:00	NVDA	Stock	0.4432	0.4455	0.4414	0.4425	17962480.0
2011-03-21 17:00:00	NVDA	Stock	0.4425	0.4444	0.4425	0.4438	174520.0
2011-03-21 18:00:00	NVDA	Stock	0.4428	0.445	0.4428	0.443	236000.0
2011-03-21 19:00:00	NVDA	Stock	0.4428	0.4428	0.442	0.4425	146320.0
2011-03-21 08:00:00	AMZN	Stock	8.147	8.225	8.091	8.091	43280.0
2011-03-21 09:00:00	AMZN	Stock	8.148	8.2	8.086	8.1439	14117920.0
2011-03-21 10:00:00	AMZN	Stock	8.143	8.2735	8.118	8.261	20575200.0
2011-03-21 11:00:00	AMZN	Stock	8.2633	8.2895	8.238	8.2419	9099020.0

> showing 50 of 46,510 rows — these rows as CSV

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