PREVIEW / stock_30min / 2010-10-25

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-25.parquet
  size:    1.4 MB
  rows:    74,824
  symbols: 3,497

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
2010-10-25 04:00:00	AAPL	Stock	10.9286	11.0411	10.9286	11.0411	36960.0
2010-10-25 04:30:00	AAPL	Stock	11.0361	11.0454	11.0182	11.0411	16800.0
2010-10-25 05:00:00	AAPL	Stock	11.0411	11.0411	11.0357	11.0357	30800.0
2010-10-25 05:30:00	AAPL	Stock	11.0436	11.0436	11.0368	11.0436	8400.0
2010-10-25 06:00:00	AAPL	Stock	11.0343	11.0343	11.0343	11.0343	11200.0
2010-10-25 06:30:00	AAPL	Stock	11.0286	11.03	11.0286	11.03	8400.0
2010-10-25 07:00:00	AAPL	Stock	11.0446	11.0643	11.0196	11.0625	260484.0
2010-10-25 07:30:00	AAPL	Stock	11.0611	11.0654	11.0279	11.0357	335664.0
2010-10-25 08:00:00	AAPL	Stock	11.0393	11.0454	10.9982	11.0386	2065812.0
2010-10-25 08:30:00	AAPL	Stock	11.0382	11.04	11.0286	11.0293	1159508.0
2010-10-25 09:00:00	AAPL	Stock	11.03	11.0407	11.0289	11.0407	858200.0
2010-10-25 09:30:00	AAPL	Stock	11.0396	11.1286	11.0157	11.0982	74355204.0
2010-10-25 10:00:00	AAPL	Stock	11.0982	11.12	11.0729	11.1096	51753912.0
2010-10-25 10:30:00	AAPL	Stock	11.1104	11.1164	11.0571	11.0632	37391872.0
2010-10-25 11:00:00	AAPL	Stock	11.0643	11.0786	11.0368	11.0757	24414992.0
2010-10-25 11:30:00	AAPL	Stock	11.0745	11.0861	11.0664	11.0746	13409340.0
2010-10-25 12:00:00	AAPL	Stock	11.0732	11.0768	11.0555	11.0636	10885252.0
2010-10-25 12:30:00	AAPL	Stock	11.0639	11.0818	11.0575	11.065	8913884.0
2010-10-25 13:00:00	AAPL	Stock	11.0644	11.0893	11.0618	11.0779	8795640.0
2010-10-25 13:30:00	AAPL	Stock	11.0793	11.0967	11.0757	11.0875	15184456.0
2010-10-25 14:00:00	AAPL	Stock	11.0876	11.0971	11.0828	11.0925	10598672.0
2010-10-25 14:30:00	AAPL	Stock	11.0925	11.1	11.0679	11.0796	20934508.0
2010-10-25 15:00:00	AAPL	Stock	11.0789	11.0875	11.0557	11.0718	32041968.0
2010-10-25 15:30:00	AAPL	Stock	11.0721	11.0786	11.0257	11.0296	45089548.0
2010-10-25 16:00:00	AAPL	Stock	11.03	11.0774	11.0204	11.0246	19349792.0
2010-10-25 16:30:00	AAPL	Stock	11.0246	11.0703	11.0221	11.0257	401240.0
2010-10-25 17:00:00	AAPL	Stock	11.0257	11.03	11.0246	11.0264	106456.0
2010-10-25 17:30:00	AAPL	Stock	11.0268	11.0268	11.0254	11.0254	58660.0
2010-10-25 18:00:00	AAPL	Stock	11.0268	11.03	11.0107	11.0107	308924.0
2010-10-25 18:30:00	AAPL	Stock	11.01	11.0136	10.9821	10.9857	1989652.0
2010-10-25 19:00:00	AAPL	Stock	10.9857	10.9857	10.9593	10.9643	2385628.0
2010-10-25 19:30:00	AAPL	Stock	10.9639	10.9786	10.9518	10.9639	2819180.0
2010-10-25 06:00:00	MSFT	Stock	25.39	25.39	25.37	25.37	6970.0
2010-10-25 06:30:00	MSFT	Stock	25.44	25.44	25.39	25.4	3848.0
2010-10-25 07:00:00	MSFT	Stock	25.4	25.4	25.3	25.4	32130.0
2010-10-25 07:30:00	MSFT	Stock	25.37	25.4	25.37	25.37	9530.0
2010-10-25 08:00:00	MSFT	Stock	25.38	25.4	25.21	25.3	121870.0
2010-10-25 08:30:00	MSFT	Stock	25.29	25.34	25.13	25.18	162271.0
2010-10-25 09:00:00	MSFT	Stock	25.19	25.28	25.19	25.25	124221.0
2010-10-25 09:30:00	MSFT	Stock	25.25	25.33	25.17	25.2	6243438.0
2010-10-25 10:00:00	MSFT	Stock	25.2	25.34	25.17	25.31	5272065.0
2010-10-25 10:30:00	MSFT	Stock	25.3	25.33	25.2	25.229	3791332.0
2010-10-25 11:00:00	MSFT	Stock	25.221	25.28	25.21	25.265	1566264.0
2010-10-25 11:30:00	MSFT	Stock	25.269	25.3	25.245	25.295	1693318.0
2010-10-25 12:00:00	MSFT	Stock	25.3	25.31	25.21	25.26	1855481.0
2010-10-25 12:30:00	MSFT	Stock	25.255	25.29	25.23	25.23	1467639.0
2010-10-25 13:00:00	MSFT	Stock	25.235	25.285	25.21	25.27	2047411.0
2010-10-25 13:30:00	MSFT	Stock	25.27	25.33	25.25	25.32	2909016.0
2010-10-25 14:00:00	MSFT	Stock	25.33	25.349	25.28	25.29	1895925.0
2010-10-25 14:30:00	MSFT	Stock	25.29	25.31	25.22	25.26	2407040.0

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

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