PREVIEW / stock_1hour / 2011-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-15.parquet
  size:    918 KB
  rows:    44,323
  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-15 04:00:00	AAPL	Stock	13.9482	13.975	13.9482	13.975	11200.0
2011-09-15 05:00:00	AAPL	Stock	13.9757	14.0064	13.9757	14.0	156800.0
2011-09-15 06:00:00	AAPL	Stock	13.9968	13.9968	13.9907	13.9907	8400.0
2011-09-15 07:00:00	AAPL	Stock	14.0	14.0089	13.9643	13.9957	761852.0
2011-09-15 08:00:00	AAPL	Stock	13.9821	14.0036	13.9089	13.9143	4073888.0
2011-09-15 09:00:00	AAPL	Stock	13.9182	13.9975	13.9157	13.9536	55720420.0
2011-09-15 10:00:00	AAPL	Stock	13.9593	14.0475	13.9482	13.9732	93961196.0
2011-09-15 11:00:00	AAPL	Stock	13.9711	14.0475	13.9396	14.0241	60196528.0
2011-09-15 12:00:00	AAPL	Stock	14.0254	14.0304	14.0019	14.0193	34083728.0
2011-09-15 13:00:00	AAPL	Stock	14.0193	14.0457	14.0146	14.0386	34058136.0
2011-09-15 14:00:00	AAPL	Stock	14.0386	14.0536	14.0071	14.0436	41446748.0
2011-09-15 15:00:00	AAPL	Stock	14.04	14.0593	14.0179	14.0379	66200232.0
2011-09-15 16:00:00	AAPL	Stock	14.0375	14.0454	13.9811	14.0357	16796472.0
2011-09-15 17:00:00	AAPL	Stock	14.0304	14.0957	14.0289	14.0896	963760.0
2011-09-15 18:00:00	AAPL	Stock	14.0925	14.1786	14.0343	14.1289	1974560.0
2011-09-15 19:00:00	AAPL	Stock	14.1286	14.1429	14.1143	14.1343	618660.0
2011-09-15 06:00:00	MSFT	Stock	26.64	26.64	26.6	26.6	300.0
2011-09-15 07:00:00	MSFT	Stock	26.65	26.75	26.65	26.72	19274.0
2011-09-15 08:00:00	MSFT	Stock	26.7	26.75	26.4	26.4	81255.0
2011-09-15 09:00:00	MSFT	Stock	26.45	26.84	26.31	26.795	10158769.0
2011-09-15 10:00:00	MSFT	Stock	26.79	26.88	26.62	26.66	8133030.0
2011-09-15 11:00:00	MSFT	Stock	26.651	26.88	26.59	26.83	5800975.0
2011-09-15 12:00:00	MSFT	Stock	26.83	26.97	26.79	26.95	4902217.0
2011-09-15 13:00:00	MSFT	Stock	26.95	26.98	26.85	26.96	5182870.0
2011-09-15 14:00:00	MSFT	Stock	26.953	27.0	26.94	26.99	5762893.0
2011-09-15 15:00:00	MSFT	Stock	26.999	27.03	26.918	26.96	11587458.0
2011-09-15 16:00:00	MSFT	Stock	26.99	27.0	26.824	26.98	15405933.0
2011-09-15 17:00:00	MSFT	Stock	26.5	27.0	26.5	26.99	47269.0
2011-09-15 18:00:00	MSFT	Stock	26.99	27.02	26.95	26.95	49600.0
2011-09-15 19:00:00	MSFT	Stock	26.95	26.99	26.95	26.99	990.0
2011-09-15 07:00:00	NVDA	Stock	0.3893	0.3893	0.3862	0.3875	108000.0
2011-09-15 08:00:00	NVDA	Stock	0.3875	0.3888	0.385	0.386	2583840.0
2011-09-15 09:00:00	NVDA	Stock	0.3862	0.3925	0.3842	0.3893	135697200.0
2011-09-15 10:00:00	NVDA	Stock	0.3895	0.3898	0.385	0.387	187412000.0
2011-09-15 11:00:00	NVDA	Stock	0.387	0.3875	0.3845	0.385	80282720.0
2011-09-15 12:00:00	NVDA	Stock	0.385	0.387	0.3842	0.386	51534880.0
2011-09-15 13:00:00	NVDA	Stock	0.3858	0.3875	0.384	0.3858	61223880.0
2011-09-15 14:00:00	NVDA	Stock	0.386	0.3882	0.3855	0.3875	77358600.0
2011-09-15 15:00:00	NVDA	Stock	0.3878	0.389	0.385	0.3873	138972040.0
2011-09-15 16:00:00	NVDA	Stock	0.3875	0.3878	0.385	0.386	16589320.0
2011-09-15 17:00:00	NVDA	Stock	0.382	0.3878	0.382	0.3878	324880.0
2011-09-15 18:00:00	NVDA	Stock	0.3878	0.39	0.3875	0.3895	250840.0
2011-09-15 19:00:00	NVDA	Stock	0.3895	0.39	0.3895	0.3895	286240.0
2011-09-15 04:00:00	AMZN	Stock	11.1375	11.1375	11.1375	11.1375	2000.0
2011-09-15 06:00:00	AMZN	Stock	11.155	11.175	11.151	11.175	48520.0
2011-09-15 07:00:00	AMZN	Stock	11.1565	11.1615	11.115	11.153	105700.0
2011-09-15 08:00:00	AMZN	Stock	11.1615	11.165	11.0625	11.075	341020.0
2011-09-15 09:00:00	AMZN	Stock	11.075	11.228	11.0625	11.1665	21551600.0
2011-09-15 10:00:00	AMZN	Stock	11.1705	11.209	11.063	11.0895	19045000.0
2011-09-15 11:00:00	AMZN	Stock	11.0895	11.1825	11.063	11.1715	9615720.0

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

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