PREVIEW / stock_30min / 2011-09-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-15.parquet
  size:    1.4 MB
  rows:    74,290
  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.9571	13.9482	13.9571	5600.0
2011-09-15 04:30:00	AAPL	Stock	13.9696	13.975	13.9696	13.975	5600.0
2011-09-15 05:30: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.9968	13.9968	2800.0
2011-09-15 06:30:00	AAPL	Stock	13.9907	13.9907	13.9907	13.9907	5600.0
2011-09-15 07:00:00	AAPL	Stock	14.0	14.0054	13.9846	13.9893	389284.0
2011-09-15 07:30:00	AAPL	Stock	13.9929	14.0089	13.9643	13.9957	372568.0
2011-09-15 08:00:00	AAPL	Stock	13.9821	14.0036	13.95	13.9557	1187088.0
2011-09-15 08:30:00	AAPL	Stock	13.9496	13.9514	13.9089	13.9143	2886800.0
2011-09-15 09:00:00	AAPL	Stock	13.9182	13.9975	13.9157	13.9814	5075924.0
2011-09-15 09:30:00	AAPL	Stock	13.9814	13.9907	13.925	13.9536	50644496.0
2011-09-15 10:00:00	AAPL	Stock	13.9593	14.0475	13.9482	13.9957	62148744.0
2011-09-15 10:30:00	AAPL	Stock	13.9946	14.0	13.9589	13.9732	31812452.0
2011-09-15 11:00:00	AAPL	Stock	13.9711	14.0268	13.9396	14.0125	33950756.0
2011-09-15 11:30:00	AAPL	Stock	14.015	14.0475	14.0064	14.0241	26245772.0
2011-09-15 12:00:00	AAPL	Stock	14.0254	14.0271	14.0019	14.0129	18335688.0
2011-09-15 12:30:00	AAPL	Stock	14.0129	14.0304	14.0036	14.0193	15748040.0
2011-09-15 13:00:00	AAPL	Stock	14.0193	14.0457	14.0157	14.0374	17288712.0
2011-09-15 13:30:00	AAPL	Stock	14.0375	14.0393	14.0146	14.0386	16769424.0
2011-09-15 14:00:00	AAPL	Stock	14.0386	14.0464	14.0071	14.0289	23897468.0
2011-09-15 14:30:00	AAPL	Stock	14.0268	14.0536	14.0236	14.0436	17549280.0
2011-09-15 15:00:00	AAPL	Stock	14.04	14.0593	14.0179	14.0286	28055916.0
2011-09-15 15:30:00	AAPL	Stock	14.0279	14.0461	14.0221	14.0379	38144316.0
2011-09-15 16:00:00	AAPL	Stock	14.0375	14.0454	14.0086	14.0357	10258780.0
2011-09-15 16:30:00	AAPL	Stock	14.0346	14.0406	13.9811	14.0357	6537692.0
2011-09-15 17:00:00	AAPL	Stock	14.0304	14.0446	14.0289	14.0429	193508.0
2011-09-15 17:30:00	AAPL	Stock	14.0464	14.0957	14.0464	14.0896	770252.0
2011-09-15 18:00:00	AAPL	Stock	14.0925	14.1568	14.0343	14.1429	1608796.0
2011-09-15 18:30:00	AAPL	Stock	14.1339	14.1786	14.1254	14.1289	365764.0
2011-09-15 19:00:00	AAPL	Stock	14.1286	14.1429	14.1286	14.1321	243852.0
2011-09-15 19:30:00	AAPL	Stock	14.1361	14.1361	14.1143	14.1343	374808.0
2011-09-15 06:30: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.74	5900.0
2011-09-15 07:30:00	MSFT	Stock	26.74	26.74	26.65	26.72	13374.0
2011-09-15 08:00:00	MSFT	Stock	26.7	26.75	26.55	26.62	36845.0
2011-09-15 08:30:00	MSFT	Stock	26.51	26.55	26.4	26.4	44410.0
2011-09-15 09:00:00	MSFT	Stock	26.45	26.75	26.45	26.74	137749.0
2011-09-15 09:30:00	MSFT	Stock	26.73	26.84	26.31	26.795	10021020.0
2011-09-15 10:00:00	MSFT	Stock	26.79	26.88	26.63	26.73	4836588.0
2011-09-15 10:30:00	MSFT	Stock	26.731	26.75	26.62	26.66	3296442.0
2011-09-15 11:00:00	MSFT	Stock	26.651	26.84	26.59	26.84	3083719.0
2011-09-15 11:30:00	MSFT	Stock	26.84	26.88	26.765	26.83	2717256.0
2011-09-15 12:00:00	MSFT	Stock	26.83	26.9	26.79	26.868	2594811.0
2011-09-15 12:30:00	MSFT	Stock	26.87	26.97	26.868	26.95	2307406.0
2011-09-15 13:00:00	MSFT	Stock	26.95	26.98	26.88	26.882	2125493.0
2011-09-15 13:30:00	MSFT	Stock	26.89	26.98	26.85	26.96	3057377.0
2011-09-15 14:00:00	MSFT	Stock	26.953	27.0	26.94	26.984	2913942.0
2011-09-15 14:30:00	MSFT	Stock	26.985	27.0	26.97	26.99	2848951.0
2011-09-15 15:00:00	MSFT	Stock	26.999	27.03	26.918	26.945	3570887.0
2011-09-15 15:30:00	MSFT	Stock	26.945	27.005	26.92	26.96	8016571.0

> showing 50 of 74,290 rows — these rows as CSV

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