PREVIEW / stock_30min / 2013-01-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-22.parquet
  size:    1.5 MB
  rows:    78,996
  symbols: 3,501

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
2013-01-22 04:00:00	AAPL	Stock	17.8714	17.8714	17.8	17.8679	72716.0
2013-01-22 04:30:00	AAPL	Stock	17.8696	17.915	17.8696	17.9118	47600.0
2013-01-22 05:00:00	AAPL	Stock	17.9118	17.9875	17.9118	17.9875	54600.0
2013-01-22 05:30:00	AAPL	Stock	17.9871	17.9871	17.9643	17.9643	40572.0
2013-01-22 06:00:00	AAPL	Stock	17.9814	17.9875	17.9679	17.9875	109200.0
2013-01-22 06:30:00	AAPL	Stock	17.975	17.975	17.9379	17.9464	35560.0
2013-01-22 07:00:00	AAPL	Stock	17.9464	17.9571	17.8929	17.9482	625240.0
2013-01-22 07:30:00	AAPL	Stock	17.9393	17.9664	17.9179	17.9214	751016.0
2013-01-22 08:00:00	AAPL	Stock	17.9268	17.9607	17.8057	17.8568	2710512.0
2013-01-22 08:30:00	AAPL	Stock	17.855	18.0136	17.8518	17.9829	4156852.0
2013-01-22 09:00:00	AAPL	Stock	17.9829	18.0357	17.9507	18.0279	4353776.0
2013-01-22 09:30:00	AAPL	Stock	18.02	18.1386	17.9125	17.9214	80246628.0
2013-01-22 10:00:00	AAPL	Stock	17.9214	17.9318	17.8271	17.8292	43206100.0
2013-01-22 10:30:00	AAPL	Stock	17.8343	17.8779	17.8036	17.8464	36310988.0
2013-01-22 11:00:00	AAPL	Stock	17.8439	17.8564	17.7782	17.8021	25780748.0
2013-01-22 11:30:00	AAPL	Stock	17.8036	17.8114	17.7368	17.7714	25774532.0
2013-01-22 12:00:00	AAPL	Stock	17.7739	17.8529	17.7686	17.8289	21657356.0
2013-01-22 12:30:00	AAPL	Stock	17.8271	17.8457	17.7954	17.8093	12401396.0
2013-01-22 13:00:00	AAPL	Stock	17.8096	17.8711	17.7911	17.8666	19567380.0
2013-01-22 13:30:00	AAPL	Stock	17.8675	17.9129	17.8514	17.8861	19553324.0
2013-01-22 14:00:00	AAPL	Stock	17.8906	17.9693	17.8839	17.9545	26475512.0
2013-01-22 14:30:00	AAPL	Stock	17.9529	18.0071	17.9286	17.9656	28176764.0
2013-01-22 15:00:00	AAPL	Stock	17.9671	17.9771	17.9286	17.9639	22998164.0
2013-01-22 15:30:00	AAPL	Stock	17.9655	18.0318	17.9621	18.0254	49718396.0
2013-01-22 16:00:00	AAPL	Stock	18.0275	18.1246	17.8361	18.0636	19640208.0
2013-01-22 16:30:00	AAPL	Stock	18.0636	18.125	17.9626	18.1243	2239888.0
2013-01-22 17:00:00	AAPL	Stock	18.1161	18.1668	18.1161	18.1429	1397620.0
2013-01-22 17:30:00	AAPL	Stock	18.1457	18.1596	18.1161	18.1357	855344.0
2013-01-22 18:00:00	AAPL	Stock	18.1339	18.1393	18.1286	18.1379	294168.0
2013-01-22 18:30:00	AAPL	Stock	18.1375	18.1568	18.1375	18.1536	422940.0
2013-01-22 19:00:00	AAPL	Stock	18.1536	18.1554	18.1429	18.1429	255360.0
2013-01-22 19:30:00	AAPL	Stock	18.1429	18.1482	18.1179	18.1179	659456.0
2013-01-22 05:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	100.0
2013-01-22 06:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	500.0
2013-01-22 06:30:00	MSFT	Stock	27.38	27.38	27.38	27.38	500.0
2013-01-22 07:30:00	MSFT	Stock	27.3	27.3	27.28	27.28	1010.0
2013-01-22 08:00:00	MSFT	Stock	27.25	27.32	27.18	27.21	21784.0
2013-01-22 08:30:00	MSFT	Stock	27.21	27.25	27.21	27.25	3786.0
2013-01-22 09:00:00	MSFT	Stock	27.25	27.35	27.22	27.33	80926.0
2013-01-22 09:30:00	MSFT	Stock	27.3	27.45	27.26	27.34	9889322.0
2013-01-22 10:00:00	MSFT	Stock	27.34	27.35	27.25	27.3	3576461.0
2013-01-22 10:30:00	MSFT	Stock	27.305	27.32	27.21	27.295	3156927.0
2013-01-22 11:00:00	MSFT	Stock	27.295	27.3	27.05	27.13	8269999.0
2013-01-22 11:30:00	MSFT	Stock	27.13	27.14	27.05	27.08	3186924.0
2013-01-22 12:00:00	MSFT	Stock	27.08	27.15	27.05	27.145	2235859.0
2013-01-22 12:30:00	MSFT	Stock	27.14	27.22	27.14	27.2	2874242.0
2013-01-22 13:00:00	MSFT	Stock	27.2	27.205	27.15	27.15	2187925.0
2013-01-22 13:30:00	MSFT	Stock	27.15	27.18	27.13	27.165	1557245.0
2013-01-22 14:00:00	MSFT	Stock	27.16	27.2	27.14	27.145	1481714.0
2013-01-22 14:30:00	MSFT	Stock	27.15	27.19	27.14	27.175	2127626.0

> showing 50 of 78,996 rows — these rows as CSV

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