PREVIEW / stock_30min / 2011-08-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-01.parquet
  size:    1.4 MB
  rows:    76,275
  symbols: 3,520

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-08-01 04:00:00	AAPL	Stock	14.195	14.2143	14.1861	14.1868	67200.0
2011-08-01 04:30:00	AAPL	Stock	14.1889	14.1961	14.1639	14.1961	22400.0
2011-08-01 05:00:00	AAPL	Stock	14.1961	14.2232	14.1961	14.2107	128800.0
2011-08-01 05:30:00	AAPL	Stock	14.2232	14.2232	14.1907	14.1907	56000.0
2011-08-01 06:00:00	AAPL	Stock	14.2	14.2071	14.2	14.2	100800.0
2011-08-01 06:30:00	AAPL	Stock	14.1907	14.2071	14.1821	14.1893	181412.0
2011-08-01 07:00:00	AAPL	Stock	14.2007	14.25	14.1518	14.1607	967764.0
2011-08-01 07:30:00	AAPL	Stock	14.1714	14.1739	14.1429	14.1439	484960.0
2011-08-01 08:00:00	AAPL	Stock	14.1596	14.2143	14.1339	14.1854	4635344.0
2011-08-01 08:30:00	AAPL	Stock	14.1793	14.1868	14.1529	14.1607	2788464.0
2011-08-01 09:00:00	AAPL	Stock	14.1632	14.2182	14.1525	14.1975	5325208.0
2011-08-01 09:30:00	AAPL	Stock	14.2029	14.2679	14.1432	14.1496	115900708.0
2011-08-01 10:00:00	AAPL	Stock	14.1489	14.1575	14.0275	14.1121	92963276.0
2011-08-01 10:30:00	AAPL	Stock	14.1118	14.1432	14.0761	14.1136	37941568.0
2011-08-01 11:00:00	AAPL	Stock	14.1132	14.1368	14.0518	14.12	41378512.0
2011-08-01 11:30:00	AAPL	Stock	14.12	14.1223	14.0505	14.0618	43054872.0
2011-08-01 12:00:00	AAPL	Stock	14.0618	14.0918	14.0132	14.0829	39238276.0
2011-08-01 12:30:00	AAPL	Stock	14.0853	14.1139	14.0557	14.1024	23371796.0
2011-08-01 13:00:00	AAPL	Stock	14.1012	14.1136	14.0725	14.0911	17351852.0
2011-08-01 13:30:00	AAPL	Stock	14.0891	14.1075	14.0832	14.0991	9992052.0
2011-08-01 14:00:00	AAPL	Stock	14.1004	14.1011	14.0439	14.0493	18576124.0
2011-08-01 14:30:00	AAPL	Stock	14.0486	14.1107	14.0357	14.1046	30270548.0
2011-08-01 15:00:00	AAPL	Stock	14.1043	14.1529	14.0893	14.1471	43586956.0
2011-08-01 15:30:00	AAPL	Stock	14.1475	14.1714	14.1029	14.1693	67375672.0
2011-08-01 16:00:00	AAPL	Stock	14.1586	14.185	14.0947	14.1696	9687104.0
2011-08-01 16:30:00	AAPL	Stock	14.1518	14.1936	14.1458	14.1893	892808.0
2011-08-01 17:00:00	AAPL	Stock	14.1896	14.1911	14.1786	14.1857	412608.0
2011-08-01 17:30:00	AAPL	Stock	14.1889	14.2011	14.1689	14.1857	757484.0
2011-08-01 18:00:00	AAPL	Stock	14.1886	14.2014	14.1696	14.1982	360416.0
2011-08-01 18:30:00	AAPL	Stock	14.1982	14.2021	14.1929	14.1964	222824.0
2011-08-01 19:00:00	AAPL	Stock	14.1964	14.2136	14.1886	14.1929	853132.0
2011-08-01 19:30:00	AAPL	Stock	14.1964	14.2125	14.1921	14.2071	392924.0
2011-08-01 04:00:00	MSFT	Stock	27.62	27.62	27.62	27.62	100.0
2011-08-01 04:30:00	MSFT	Stock	27.74	27.74	27.74	27.74	200.0
2011-08-01 05:30:00	MSFT	Stock	27.81	27.81	27.81	27.81	100.0
2011-08-01 06:30:00	MSFT	Stock	27.81	27.92	27.81	27.92	4925.0
2011-08-01 07:00:00	MSFT	Stock	27.91	27.92	27.85	27.88	6825.0
2011-08-01 07:30:00	MSFT	Stock	27.88	27.88	27.8	27.83	38473.0
2011-08-01 08:00:00	MSFT	Stock	27.85	27.85	27.75	27.75	35664.0
2011-08-01 08:30:00	MSFT	Stock	27.74	27.74	27.51	27.55	85953.0
2011-08-01 09:00:00	MSFT	Stock	27.56	27.57	27.5	27.51	164455.0
2011-08-01 09:30:00	MSFT	Stock	27.51	27.685	27.41	27.416	7274170.0
2011-08-01 10:00:00	MSFT	Stock	27.41	27.415	27.02	27.04	8403179.0
2011-08-01 10:30:00	MSFT	Stock	27.045	27.19	26.98	27.07	4320280.0
2011-08-01 11:00:00	MSFT	Stock	27.07	27.14	26.98	27.13	3373068.0
2011-08-01 11:30:00	MSFT	Stock	27.13	27.14	26.88	26.91	4217451.0
2011-08-01 12:00:00	MSFT	Stock	26.91	26.945	26.75	26.889	4532802.0
2011-08-01 12:30:00	MSFT	Stock	26.88	26.91	26.79	26.87	2616355.0
2011-08-01 13:00:00	MSFT	Stock	26.861	26.99	26.84	26.95	1956645.0
2011-08-01 13:30:00	MSFT	Stock	26.955	27.06	26.948	27.05	2417750.0

> showing 50 of 76,275 rows — these rows as CSV

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