PREVIEW / stock_1hour / 2011-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-19.parquet
  size:    913 KB
  rows:    44,259
  symbols: 3,507

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-09-19 04:00:00	AAPL	Stock	14.1786	14.1786	14.1071	14.1071	67200.0
2011-09-19 05:00:00	AAPL	Stock	14.1071	14.1554	14.1071	14.1229	63840.0
2011-09-19 06:00:00	AAPL	Stock	14.1289	14.1514	14.1286	14.1411	146860.0
2011-09-19 07:00:00	AAPL	Stock	14.1454	14.2054	14.1411	14.1786	1089088.0
2011-09-19 08:00:00	AAPL	Stock	14.1736	14.1993	14.15	14.1811	4668664.0
2011-09-19 09:00:00	AAPL	Stock	14.1807	14.2229	14.1144	14.1214	82614308.0
2011-09-19 10:00:00	AAPL	Stock	14.1214	14.2829	14.1214	14.2706	91519988.0
2011-09-19 11:00:00	AAPL	Stock	14.2704	14.6964	14.2693	14.6243	229009228.0
2011-09-19 12:00:00	AAPL	Stock	14.6251	14.6757	14.5646	14.6393	90883884.0
2011-09-19 13:00:00	AAPL	Stock	14.6396	14.6604	14.5396	14.6443	65009140.0
2011-09-19 14:00:00	AAPL	Stock	14.645	14.7089	14.6107	14.6203	87768324.0
2011-09-19 15:00:00	AAPL	Stock	14.6243	14.7582	14.5536	14.7014	153432468.0
2011-09-19 16:00:00	AAPL	Stock	14.7033	14.7428	14.1554	14.6993	9007040.0
2011-09-19 17:00:00	AAPL	Stock	14.7007	14.7054	14.6921	14.6954	292628.0
2011-09-19 18:00:00	AAPL	Stock	14.7011	14.7389	14.6614	14.6614	1806924.0
2011-09-19 19:00:00	AAPL	Stock	14.6618	14.6779	14.6286	14.6429	687372.0
2011-09-19 04:00:00	MSFT	Stock	27.0	27.0	26.7	26.7	400.0
2011-09-19 06:00:00	MSFT	Stock	26.75	26.75	26.75	26.75	700.0
2011-09-19 07:00:00	MSFT	Stock	26.82	26.82	26.76	26.78	2200.0
2011-09-19 08:00:00	MSFT	Stock	26.78	26.89	26.78	26.84	65301.0
2011-09-19 09:00:00	MSFT	Stock	26.84	26.86	26.6	26.63	6286868.0
2011-09-19 10:00:00	MSFT	Stock	26.63	26.79	26.63	26.755	5741891.0
2011-09-19 11:00:00	MSFT	Stock	26.75	26.93	26.74	26.82	5792153.0
2011-09-19 12:00:00	MSFT	Stock	26.82	26.88	26.75	26.78	3944747.0
2011-09-19 13:00:00	MSFT	Stock	26.77	26.89	26.76	26.89	3681472.0
2011-09-19 14:00:00	MSFT	Stock	26.89	27.02	26.855	26.925	6131563.0
2011-09-19 15:00:00	MSFT	Stock	26.92	27.31	26.87	27.2	17220221.0
2011-09-19 16:00:00	MSFT	Stock	27.203	27.25	26.7	27.21	3048942.0
2011-09-19 17:00:00	MSFT	Stock	27.16	27.16	27.14	27.14	800.0
2011-09-19 18:00:00	MSFT	Stock	27.21	27.21	27.1	27.1	21901.0
2011-09-19 19:00:00	MSFT	Stock	27.1	27.1	26.96	27.05	16500.0
2011-09-19 04:00:00	NVDA	Stock	0.3895	0.3895	0.3862	0.3862	40000.0
2011-09-19 07:00:00	NVDA	Stock	0.3768	0.379	0.3768	0.379	20000.0
2011-09-19 08:00:00	NVDA	Stock	0.3835	0.3842	0.3775	0.3783	1684760.0
2011-09-19 09:00:00	NVDA	Stock	0.378	0.3828	0.3743	0.3747	139004480.0
2011-09-19 10:00:00	NVDA	Stock	0.3746	0.3763	0.3688	0.374	174353320.0
2011-09-19 11:00:00	NVDA	Stock	0.374	0.3818	0.374	0.3785	139986840.0
2011-09-19 12:00:00	NVDA	Stock	0.3784	0.3803	0.374	0.376	66242960.0
2011-09-19 13:00:00	NVDA	Stock	0.3758	0.3775	0.3753	0.3769	53879920.0
2011-09-19 14:00:00	NVDA	Stock	0.377	0.3775	0.374	0.3755	108645080.0
2011-09-19 15:00:00	NVDA	Stock	0.3754	0.382	0.375	0.3783	251569240.0
2011-09-19 16:00:00	NVDA	Stock	0.3785	0.381	0.3758	0.38	22480440.0
2011-09-19 17:00:00	NVDA	Stock	0.3788	0.38	0.3785	0.38	183600.0
2011-09-19 18:00:00	NVDA	Stock	0.3803	0.381	0.3765	0.3765	2311600.0
2011-09-19 19:00:00	NVDA	Stock	0.3765	0.3775	0.373	0.3738	1176120.0
2011-09-19 04:00:00	AMZN	Stock	11.841	11.841	11.78	11.8	12000.0
2011-09-19 05:00:00	AMZN	Stock	11.775	11.7865	11.775	11.7865	6000.0
2011-09-19 06:00:00	AMZN	Stock	11.781	11.781	11.775	11.775	4960.0
2011-09-19 07:00:00	AMZN	Stock	11.794	11.86	11.794	11.85	59200.0
2011-09-19 08:00:00	AMZN	Stock	11.856	11.875	11.83	11.845	541700.0

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

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