PREVIEW / stock_1hour / 2012-02-29

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-29.parquet
  size:    974 KB
  rows:    45,841
  symbols: 3,532

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-02-29 04:00:00	AAPL	Stock	19.2857	19.3296	19.2679	19.2857	198800.0
2012-02-29 05:00:00	AAPL	Stock	19.2857	19.2857	19.2232	19.2232	189560.0
2012-02-29 06:00:00	AAPL	Stock	19.25	19.2607	19.2361	19.2411	96992.0
2012-02-29 07:00:00	AAPL	Stock	19.2496	19.2679	19.1879	19.2129	1089088.0
2012-02-29 08:00:00	AAPL	Stock	19.2271	19.3036	19.2075	19.2875	6529012.0
2012-02-29 09:00:00	AAPL	Stock	19.2893	19.5575	19.2857	19.4582	203194488.0
2012-02-29 10:00:00	AAPL	Stock	19.4604	19.4604	19.1893	19.2979	193154080.0
2012-02-29 11:00:00	AAPL	Stock	19.2979	19.3757	19.2429	19.3579	92161720.0
2012-02-29 12:00:00	AAPL	Stock	19.3621	19.4525	19.3354	19.4339	72808764.0
2012-02-29 13:00:00	AAPL	Stock	19.4339	19.4457	19.3457	19.4325	59003308.0
2012-02-29 14:00:00	AAPL	Stock	19.4321	19.4511	19.4	19.4214	47356960.0
2012-02-29 15:00:00	AAPL	Stock	19.4204	19.4821	19.1321	19.3707	224087780.0
2012-02-29 16:00:00	AAPL	Stock	19.3595	19.406	19.1218	19.3782	29900668.0
2012-02-29 17:00:00	AAPL	Stock	19.3507	19.3786	19.3354	19.3446	1262436.0
2012-02-29 18:00:00	AAPL	Stock	19.3464	19.3643	19.3368	19.3432	506408.0
2012-02-29 19:00:00	AAPL	Stock	19.3436	19.3718	19.3436	19.3696	652652.0
2012-02-29 05:00:00	MSFT	Stock	31.98	31.99	31.98	31.99	2200.0
2012-02-29 07:00:00	MSFT	Stock	31.99	31.99	31.99	31.99	300.0
2012-02-29 08:00:00	MSFT	Stock	31.96	31.96	31.92	31.92	13907.0
2012-02-29 09:00:00	MSFT	Stock	31.91	31.94	31.8	31.92	5990723.0
2012-02-29 10:00:00	MSFT	Stock	31.92	32.0	31.76	31.88	10994285.0
2012-02-29 11:00:00	MSFT	Stock	31.88	31.89	31.72	31.805	7845849.0
2012-02-29 12:00:00	MSFT	Stock	31.8	31.86	31.72	31.76	4408387.0
2012-02-29 13:00:00	MSFT	Stock	31.77	31.8	31.67	31.77	5398555.0
2012-02-29 14:00:00	MSFT	Stock	31.77	31.84	31.67	31.72	5253445.0
2012-02-29 15:00:00	MSFT	Stock	31.72	31.76	31.61	31.74	11383865.0
2012-02-29 16:00:00	MSFT	Stock	31.74	31.86	31.613	31.73	7120599.0
2012-02-29 17:00:00	MSFT	Stock	31.77	31.77	31.71	31.74	52603.0
2012-02-29 18:00:00	MSFT	Stock	31.75	31.75	31.71	31.71	4470.0
2012-02-29 19:00:00	MSFT	Stock	31.72	31.76	31.72	31.76	2126.0
2012-02-29 08:00:00	NVDA	Stock	0.3833	0.3838	0.3833	0.3838	67840.0
2012-02-29 09:00:00	NVDA	Stock	0.3848	0.3855	0.3829	0.3842	43817200.0
2012-02-29 10:00:00	NVDA	Stock	0.3842	0.3905	0.3838	0.3889	160526920.0
2012-02-29 11:00:00	NVDA	Stock	0.389	0.391	0.387	0.3888	92261560.0
2012-02-29 12:00:00	NVDA	Stock	0.3886	0.3893	0.3868	0.387	44355160.0
2012-02-29 13:00:00	NVDA	Stock	0.387	0.3878	0.385	0.3868	66740840.0
2012-02-29 14:00:00	NVDA	Stock	0.3869	0.387	0.3822	0.3833	45317520.0
2012-02-29 15:00:00	NVDA	Stock	0.3833	0.3834	0.3785	0.379	182332560.0
2012-02-29 16:00:00	NVDA	Stock	0.379	0.3824	0.3785	0.3788	49521120.0
2012-02-29 17:00:00	NVDA	Stock	0.3788	0.3875	0.3788	0.379	1702600.0
2012-02-29 18:00:00	NVDA	Stock	0.3798	0.3798	0.3798	0.3798	12000.0
2012-02-29 19:00:00	NVDA	Stock	0.3798	0.3808	0.3798	0.3808	50000.0
2012-02-29 06:00:00	AMZN	Stock	9.185	9.185	9.15	9.185	12000.0
2012-02-29 07:00:00	AMZN	Stock	9.154	9.154	9.15	9.15	20000.0
2012-02-29 08:00:00	AMZN	Stock	9.1685	9.2	9.168	9.2	123200.0
2012-02-29 09:00:00	AMZN	Stock	9.2	9.241	9.0845	9.1673	14731380.0
2012-02-29 10:00:00	AMZN	Stock	9.172	9.175	9.002	9.068	19717520.0
2012-02-29 11:00:00	AMZN	Stock	9.065	9.073	9.023	9.06	9659700.0
2012-02-29 12:00:00	AMZN	Stock	9.0585	9.0714	9.0445	9.0528	8941900.0
2012-02-29 13:00:00	AMZN	Stock	9.051	9.0575	9.005	9.0294	6143460.0

> showing 50 of 45,841 rows — these rows as CSV

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