PREVIEW / stock_30min / 2011-05-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-24.parquet
  size:    1.4 MB
  rows:    75,569
  symbols: 3,549

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-05-24 05:00:00	AAPL	Stock	11.9643	11.9643	11.9439	11.9439	16044.0
2011-05-24 05:30:00	AAPL	Stock	11.9532	11.9579	11.9532	11.9579	5600.0
2011-05-24 06:30:00	AAPL	Stock	11.9475	11.9475	11.9475	11.9475	2800.0
2011-05-24 07:00:00	AAPL	Stock	11.9679	11.9679	11.9482	11.9482	35560.0
2011-05-24 07:30:00	AAPL	Stock	11.9636	11.9711	11.9636	11.9643	178500.0
2011-05-24 08:00:00	AAPL	Stock	11.9696	12.0075	11.9696	11.9946	854252.0
2011-05-24 08:30:00	AAPL	Stock	11.9904	12.0089	11.9904	12.0	406476.0
2011-05-24 09:00:00	AAPL	Stock	12.0014	12.0075	11.9607	11.9821	750288.0
2011-05-24 09:30:00	AAPL	Stock	11.9825	11.9964	11.8336	11.8571	69119876.0
2011-05-24 10:00:00	AAPL	Stock	11.8575	11.9216	11.8371	11.8997	53685856.0
2011-05-24 10:30:00	AAPL	Stock	11.9011	11.9114	11.875	11.8929	27067348.0
2011-05-24 11:00:00	AAPL	Stock	11.8929	11.9279	11.8923	11.9129	18326560.0
2011-05-24 11:30:00	AAPL	Stock	11.9129	11.9636	11.8957	11.9157	32596116.0
2011-05-24 12:00:00	AAPL	Stock	11.9157	11.9179	11.8882	11.9061	9734032.0
2011-05-24 12:30:00	AAPL	Stock	11.9071	11.9143	11.8886	11.8982	7603456.0
2011-05-24 13:00:00	AAPL	Stock	11.8961	11.9175	11.895	11.9032	8314376.0
2011-05-24 13:30:00	AAPL	Stock	11.9036	11.905	11.8786	11.8968	10450664.0
2011-05-24 14:00:00	AAPL	Stock	11.8964	11.9261	11.89	11.9215	9737084.0
2011-05-24 14:30:00	AAPL	Stock	11.9222	11.9246	11.8929	11.9041	9632252.0
2011-05-24 15:00:00	AAPL	Stock	11.905	11.9278	11.8988	11.9125	13456632.0
2011-05-24 15:30:00	AAPL	Stock	11.9139	11.9189	11.8554	11.8696	33805688.0
2011-05-24 16:00:00	AAPL	Stock	11.8693	11.9023	11.8518	11.8607	8824116.0
2011-05-24 16:30:00	AAPL	Stock	11.8689	11.9125	11.8536	11.8539	325640.0
2011-05-24 17:00:00	AAPL	Stock	11.8971	11.9066	11.8546	11.8571	293776.0
2011-05-24 17:30:00	AAPL	Stock	11.8604	11.8614	11.8571	11.8614	20440.0
2011-05-24 18:00:00	AAPL	Stock	11.8589	11.8639	11.8579	11.8579	159432.0
2011-05-24 18:30:00	AAPL	Stock	11.8568	11.8589	11.8568	11.8589	19600.0
2011-05-24 19:00:00	AAPL	Stock	11.8614	11.8614	11.8571	11.8571	39172.0
2011-05-24 19:30:00	AAPL	Stock	11.8564	11.8564	11.85	11.85	64400.0
2011-05-24 05:30:00	MSFT	Stock	24.35	24.35	24.35	24.35	100.0
2011-05-24 06:00:00	MSFT	Stock	24.35	24.35	24.35	24.35	100.0
2011-05-24 07:30:00	MSFT	Stock	24.24	24.24	24.22	24.22	708.0
2011-05-24 08:00:00	MSFT	Stock	24.24	24.27	24.22	24.25	9342.0
2011-05-24 08:30:00	MSFT	Stock	24.28	24.28	24.28	24.28	1100.0
2011-05-24 09:00:00	MSFT	Stock	24.28	24.28	24.16	24.2	111405.0
2011-05-24 09:30:00	MSFT	Stock	24.21	24.24	24.04	24.115	5556601.0
2011-05-24 10:00:00	MSFT	Stock	24.115	24.23	24.1	24.141	3994897.0
2011-05-24 10:30:00	MSFT	Stock	24.15	24.18	24.1	24.145	2970056.0
2011-05-24 11:00:00	MSFT	Stock	24.14	24.21	24.13	24.149	3552885.0
2011-05-24 11:30:00	MSFT	Stock	24.147	24.17	24.1	24.12	1995669.0
2011-05-24 12:00:00	MSFT	Stock	24.125	24.23	24.095	24.195	4789814.0
2011-05-24 12:30:00	MSFT	Stock	24.198	24.205	24.14	24.15	1811173.0
2011-05-24 13:00:00	MSFT	Stock	24.15	24.18	24.15	24.15	1111674.0
2011-05-24 13:30:00	MSFT	Stock	24.155	24.23	24.14	24.23	2154670.0
2011-05-24 14:00:00	MSFT	Stock	24.22	24.29	24.21	24.265	3417861.0
2011-05-24 14:30:00	MSFT	Stock	24.265	24.27	24.23	24.256	1822550.0
2011-05-24 15:00:00	MSFT	Stock	24.25	24.27	24.2	24.24	2782129.0
2011-05-24 15:30:00	MSFT	Stock	24.24	24.25	24.15	24.15	7493159.0
2011-05-24 16:00:00	MSFT	Stock	24.15	24.18	24.14	24.15	2653137.0
2011-05-24 16:30:00	MSFT	Stock	24.17	24.242	24.15	24.15	53920.0

> showing 50 of 75,569 rows — these rows as CSV

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